Add new iOS Contacts to Google Sheets automatically
by
About this Applet
Automatically send a personalized Gmail follow-up or invoice to a lead or customer whenever a new row is added to your Google Sheet, ideal for sales teams, marketers, and small business owners. It runs whenever the specified spreadsheet gets a new row and maps columns to the Gmail recipient, subject, and message so each email is personalized. This applet shows how to connect Google Sheets to Gmail to automate follow-ups and billing, saving time and reducing manual errors.
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
To address
CC address
BCC address
Subject
Body
Attachment URL
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 Gmail and Google Sheets 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.
41 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 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.
New attachment
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 every time a new email with an attachment arrives in your inbox.
New conversation
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 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
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 every time a new email arrives in your Gmail inbox.
New email matching search
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 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 hour on Free, every 15 minutes on Starter, and every 5 minutes on Pro and Pro+.
This trigger fires once every time a new label is created in your Gmail account. New labels are typically detected within an hour.
New row added to 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 new row is added to a spreadsheet you specify.
New sent email
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 every time you send an email from your Gmail account, typically within a few minutes of the send. This includes emails your Applets send.
New spreadsheet added to folder
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 new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
New starred email
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 the first time you star an email in your Gmail account. It checks your most recently received starred emails, so starring a much older email might not fire it.
New worksheet 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 new worksheet is added to a spreadsheet you specify.
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.
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 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.
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 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.
History of spreadsheets added to folder
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 spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
History of when Cell was updated 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 a list of when a particular cell was updated within the spreadsheet you specify.
History of worksheets 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 a list of when a new worksheet is added to a spreadsheet 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.
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 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.
Remove label from conversation
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 remove a label from a Gmail conversation, removing it from every message in the conversation at the time the action runs. Messages added to the conversation later are not affected.
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 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.
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 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.
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.
Build an automation in seconds!
If
Select a trigger the automation will use
Cell updated in spreadsheet
New attachment
New conversation
New email
New email matching search
New label
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 spreadsheet
Delete email
Forward email
Remove label from conversation
Remove label from email
Reply to email
Send an email
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 Gmail and Google Sheets
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.