Add new iOS Contacts to Google Sheets automatically
by
About this Applet
Stay informed instantly when your connected devices change state. This Applet runs when your selected eWeLink 1-Channel Plug is turned on, sending Telegram messages, making phone calls, and logging the event to Google Sheets. Ideal for monitoring smart home power events, notifications, or tracking device usage. Customize the message to fit your tone. Note: This requires a reachable webhook endpoint.
If
Trigger ingredients
CreatedAt
DeviceName
OnorOff
TrackUrl
Then
Action fields
Target chat
Message text
Include web page preview?
And
Action fields
URL
Method
Content Type
Additional Headers
Body
And
Action fields
Voice Message?
Language to use?
And
Action fields
Spreadsheet name
Formatted row
Drive folder path
Services used in this Applet
You might also like...
-
272k
-
-
Track time at locations with Google Sheetsby
158k
-
-
Log work hours in Google Sheets with a Button Widgetby
124k
-
Related services
-
-
App store rating
Create your own workflow
Create custom workflows effortlessly by selecting triggers, queries, and actions. With IFTTT, it's simple: “If this” trigger happens, “then that” action follows. Streamline tasks and save time with automated workflows that work for you.
109 triggers, queries, and actions
1-Channel Plug turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 1-Channel Plug is turned on or off.
1-Channel Switch turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 1-Channel Switch is turned on or off.
2-Channel Plug turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink 2-Channel Plug is turned on or off.
2-Channel Switch turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 2-Channel Switch is turned on or off.
3-Channel Plug turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink Support 3-Channel Plug is turned on or off.
3-Channel Switch turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink 3-Channel Switch is turned on or off.
4-Channel Plug turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 4-Channel Plug is turned on or off.
4-Channel Switch turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink Support 4-Channel Switch is turned on or off.
Brightness is above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the brightness of selected dimmer is above threshold.
Brightness is below
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the brightness of selected dimmer is below threshold.
Button Pressed
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This Trigger fires every time your eWeLink Button is pressed.
Cell updated in spreadsheet
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Current power state
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the on/off state of the device you choose.
Current value of a cell
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current value of a single cell in your spreadsheet.
Current values of a row
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the current values in a given row. Values from columns A-Z are available as ingredients.
Find rows in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns the rows of a worksheet with a cell that contains or matches a value, with each row's number for "Update row in spreadsheet". Use it to look up rows instead of reading them one at a time.
Get rows in spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query reads 50 rows of a worksheet, starting at the row you choose, and returns the ones with data. Use it to read a table, header row included, in one run instead of one row at a time. To read on, add 50 to the start row.
History of messages in a group
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when any user sends the /ifttt command to the source group.
History of messages with key phrase in a group
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a user sends a message with the /ifttt command and a key phrase to the source group.
History of messages with key phrase to @IFTTT
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when you send a text message with a key phrase to the @IFTTT bot on Telegram.
History of photos in your channel
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new photo is posted in a public channel where you are an admin. The @IFTTT bot must also be an admin in the channel.
History of photos to @IFTTT on Telegram
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when you send a photo to the @IFTTT bot on Telegram.
History of posts in your channel
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new message is posted in a public channel where you are an admin. The @IFTTT bot must also be an admin in the channel.
History of rows added to spreadsheet
Query
A query lets your Applet retrieve extra data that isn't included in the trigger, so that your automation can include more complete or useful information.
This query returns a list of when a new row is added to a spreadsheet you specify.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Camera Action
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This will cause the camera to perform the action you selected.
Camera makes alarm
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This Action will makes the camera sound an alarm.
Change Thermostat Mode
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will change the thermostat mode (Manual/Program).
Control FanLight
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will turn on or turn off the fan or the light of your fanlight.
Create spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will create a new blank spreadsheet in a Google Drive folder you specify. If a spreadsheet with the same name already exists, no new file is created.
Enable/disable the Child Lock of Thermostat
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will enable or disable the child lock.
Fanlight on-off and speed setting
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will set the light on/off or the fan speed of fanlight.
Make a web request
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will make a web request to a publicly accessible URL. NOTE: Requests may be rate limited.
Make device sound an alarm or beep
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will set the device to sound an alarm or beep.
1-Channel Plug turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 1-Channel Plug is turned on or off.
1-Channel Switch turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 1-Channel Switch is turned on or off.
2-Channel Plug turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink 2-Channel Plug is turned on or off.
2-Channel Switch turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 2-Channel Switch is turned on or off.
3-Channel Plug turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink Support 3-Channel Plug is turned on or off.
3-Channel Switch turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink 3-Channel Switch is turned on or off.
4-Channel Plug turned on or off
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when your eWeLink Support 4-Channel Plug is turned on or off.
4-Channel Switch turned on or off
Realtime trigger
Realtime Applets run after the trigger service notifies IFTTT of a new trigger event. Since IFTTT is notified proactively of new trigger events, realtime Applets normally run within a few seconds of a trigger event occurring.
This trigger fires when your eWeLink Support 4-Channel Switch is turned on or off.
Add multiple rows to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add up to 5 rows to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Add row to top of spreadsheet
Action
An action is the task your Applet carries out after the trigger occurs. It defines what happens as the result of your automation and completes the workflow.
This action will insert a single row directly below the header row (row 1) of the first worksheet of a spreadsheet you specify, pushing existing data down.
Brightness is above
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires when the brightness of selected dimmer is above threshold.
Build an automation in seconds!
If
Select a trigger the automation will use
1-Channel Plug turned on or off
1-Channel Switch turned on or off
2-Channel Plug turned on or off
2-Channel Switch turned on or off
3-Channel Plug turned on or off
3-Channel Switch turned on or off
4-Channel Plug turned on or off
4-Channel Switch turned on or off
Brightness is above
Brightness is below
Button Pressed
Cell updated in spreadsheet
Color temperature(CT) of light appearances warm or cool
Device/Group is turned on or off
Door sensor is open or closed
Electric current goes above or below
Electric curtain is open or closed
Enabled/disabled Child Lock of Thermostat
FanLight turned on or off
Humidity goes above or below
Leak detected
Light brightness goes above or below
Light turned on or off
Light turns to a specified colour
Low Water Level of Diffuser
New message in a group
New message with key phrase in a group
New message with key phrase to @IFTTT
New photo in your channel
New photo to @IFTTT on Telegram
New post in your channel
New row added to spreadsheet
New spreadsheet added to folder
New worksheet in spreadsheet
Power goes above or below
Receive a web request
Receive a web request with a JSON payload
RF Bridge Alarm activated
Scene Controller pressed
Smart Dimmer turned on or off
Temperature goes above or below
Thermostat Mode changes
Thermostat turned on or off
Various AQIs goes above or below
Voltage goes above or below
When Camera detects a motion event
Zigbee door sensor is open or closed
Zigbee Motion Sensor
Zigbee Wireless Switch Pressed
Then
Select an action the automation will perform
Add multiple rows to spreadsheet
Add row to spreadsheet
Add row to top of spreadsheet
Camera Action
Camera makes alarm
Change Thermostat Mode
Control FanLight
Create spreadsheet
Enable/disable the Child Lock of Thermostat
Fanlight on-off and speed setting
Make a web request
Make device sound an alarm or beep
Make Telegram Phone Call
Open or close electric curtain
Press Remote Button on RF Bridge
Send message
Send mp3
Send photo
Send video
Set brightness for light
Set brightness for Smart Dimmer
Set color for light
Set color temperature for light
Set percentage of electric curtain
Set temperature
Set the security mode
Turn 1-Channel Plug on or off
Turn 1-Channel Switch on or off
Turn 2-Channel Plug on or off
Turn 2-Channel Switch on or off
Turn 3-Channel Plug on or off
Turn 3-Channel Switch on or off
Turn 4-Channel Plug on or off
Turn 4-Channel Switch on or off
Turn on or off device/group
Turn on or off light
Turn on or off Thermostat
Turn on or turn off diffuser
Turn Smart Dimmer on or off
Update cell in spreadsheet
Update multiple rows in spreadsheet
Update row in spreadsheet
You can add delays, queries, and more actions in the chat.
More on these services
About CallMeBot Phone Call
Make Free Telegram Phone Calls when a Trigger is fired. A Robot will Call you and read your message with a real voice (TTS - Text to Speech). This service requires a Telegram App installed in your phone to receive calls.
About Google Sheets
Google Sheets lets you create and edit spreadsheets stored on your Google Drive. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates.
About Webhooks
Learn to use webhooks and integrate other services on IFTTT with your DIY projects. You can create Applets that work with any device or app that can make or receive a web request. If you'd like to build your own service and Applets, check out the IFTTT Developer Dashboard. Connect a webhook to any of the 1000+ apps and services on IFTTT.
About Telegram
Use IFTTT to automatically message with Telegram. Do more with the Telegram web app. Pure instant messaging — simple, fast, secure, and synced across all your devices. Connect with some of the IFTTT applets below, or build customized integrations using the Telegram Bot Platform.
About eWeLink Smart Home
eWeLink is a smart home center that lets you control and manage your favorite smart devices from different brands in a single app.