Add new iOS Contacts to Google Sheets automatically
About this Applet
Automate your workflow by sending a Telegram message, creating a Google Contact, and emailing participants when a new row is added to your Google Sheets document. This Applet runs whenever you update the specified spreadsheet with new registration or contact data. Perfect for event organizers or teams managing sign-ups across Google Sheets, Gmail, and Telegram. Customize the message to fit your tone.
If
Trigger ingredients
Filename
Path
SpreadsheetUrl
CreatedAt
RowIndex
ColumnA
ColumnB
ColumnC
ColumnD
ColumnE
ColumnF
ColumnG
ColumnH
ColumnI
ColumnJ
ColumnK
ColumnL
ColumnM
ColumnN
ColumnO
ColumnP
ColumnQ
ColumnR
ColumnS
ColumnT
ColumnU
ColumnV
ColumnW
ColumnX
ColumnY
ColumnZ
Then
Action fields
chat_id
text
include_web_page_preview
And
Action fields
full_name
which_group
phone_number
email
address
job_title
company
notes
upload_photo
And
Action fields
to
cc
bcc
subject
body
attachment_url
Services used in this Applet
You might also like...
-
272k
-
-
Track time at locations with Google Sheets
157k
-
-
Log work hours in Google Sheets with a Button Widget
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.
60 triggers, queries, and actions
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
New attachment
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time a new email with an attachment arrives in your inbox.
New contact added
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a new Google Contact is created.
New contact added to group
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This Trigger fires every time a Google Contact is added to a group.
New conversation
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a conversation starts in your Gmail inbox: a message gets its first reply and a back-and-forth begins. It fires once per conversation, not on every reply.
New email
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time a new email arrives in your Gmail inbox.
New email matching search
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires every time an email newly matches your Gmail search, whether it just arrived or just changed to match.
New label
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires once every time a new label is created in your Gmail account. New labels are typically detected within an hour.
New message in a group
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 any user sends the /ifttt command to the source group.
New message with key phrase in a group
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 a user sends a message with the /ifttt command and a key phrase to the source group.
New message with key phrase to @IFTTT
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 you send a text message with a key phrase to the @IFTTT bot on Telegram.
New photo in your channel
Polling trigger
Polling Applets run after IFTTT reaches out to the trigger service and finds a new trigger event. These trigger checks occur every 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires 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.
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 email
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 most recent emails matching your Gmail search, newest first.
Get attachment by filename
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 an attachment from a specific Gmail message, located by its filename, as links to a temporary copy of the file that IFTTT hosts and removes automatically, along with the attachment's details.
Get conversation
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 messages in a Gmail conversation, looked up by its thread id: one result per message, oldest first, each carrying the message's full content alongside the conversation's participants and message count.
History of contacts added
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 every time a new Google Contact is created.
History of contacts added to 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 every time a Google Contact is added to a group.
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.
Add label to email
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 the label you choose to a specific email message in your Gmail account.
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.
Archive email
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 archive a specific email message, removing it from your inbox without deleting it. The message remains in All Mail and stays searchable.
Create a draft
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 save a new email as a draft in your Gmail account without sending it. The draft waits in your Drafts folder until you open Gmail and send it yourself.
Create a draft reply
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 save a draft reply to a specific email in your Gmail account, kept in the original conversation. The draft waits in your Drafts folder until you send it yourself.
Create label
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 label in your Gmail account.
Create new contact
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 contact in Google Contacts.
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.
Delete email
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 move a specific email message to Trash in your Gmail account. Messages in Trash can be recovered until Gmail permanently removes them.
Forward email
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 forward an email from your Gmail account, attachments included, to the recipient you specify.
Add label to email
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 the label you choose to a specific email message in your Gmail account.
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.
Archive email
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 archive a specific email message, removing it from your inbox without deleting it. The message remains in All Mail and stays searchable.
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 5 minutes for Pro and Pro+ users, and every hour for Free users.
This trigger fires when a particular cell is updated within the spreadsheet you specify.
Create a draft
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 save a new email as a draft in your Gmail account without sending it. The draft waits in your Drafts folder until you open Gmail and send it yourself.
Create a draft reply
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 save a draft reply to a specific email in your Gmail account, kept in the original conversation. The draft waits in your Drafts folder until you send it yourself.
Create label
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 label in your Gmail account.
Create new contact
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 contact in Google Contacts.
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.
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.
Build an automation in seconds!
If
Select a trigger the automation will use
Cell updated in spreadsheet
New attachment
New contact added
New contact added to group
New conversation
New email
New email matching search
New label
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 sent email
New spreadsheet added to folder
New starred email
New worksheet in spreadsheet
Then
Select an action the automation will perform
Add label to email
Add multiple rows to spreadsheet
Add row to spreadsheet
Add row to top of spreadsheet
Archive email
Create a draft
Create a draft reply
Create label
Create new contact
Create spreadsheet
Delete email
Forward email
Remove label from conversation
Remove label from email
Reply to email
Send an email
Send message
Send mp3
Send photo
Send video
Send yourself an email
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 Gmail
Gmail and IFTTT connect your inbox to 1000+ other apps and devices to automate routine email management tasks. Keep your inbox organized, ensure timely follow-up with custom reminders, keep teams informed for urgent messages, or even change your lights if a specific email comes in. Spend less time managing your email with easy-to-use automations.
The use of information received from Google Workspace scopes will adhere to the Google User Data Policy, including the Limited Use requirements.
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 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 Google Contacts
Google Contacts is your online address book. Sync your contacts to all your devices and access them everywhere. Turn on Applets to better manage all your contacts and sync or share them across hundreds of other services.