Add new iOS Contacts to Google Sheets automatically
by
About this Applet
When a new Mailchimp campaign summary becomes available, this Applet posts key performance stats to a Slack channel, logs them in a Google Sheets spreadsheet, and sends a summary email through Gmail. This keeps your team instantly updated on how each campaign performs after sending. It’s perfect for marketing teams that track open and click rates together across platforms. Customize the email message to fit your tone.
If
Trigger ingredients
SummaryAt
CampaignName
EmailsSent
AbuseReports
Unsubscribed
SentAt
TotalBounces
TotalForwards
TotalOpens
UniqueOpens
OpenRate
TotalClicks
UniqueClicks
ClickRate
CampaignUrl
Then
Action fields
Which channel?
Message
Title
Title URL
Thumbnail URL
And
Action fields
Spreadsheet name
Formatted row
Drive folder path
And
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 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.
54 triggers, queries, and actions
Campaign summary available
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 there is a new campaign summary available.
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 campaign scheduled
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 there is a new campaign scheduled on MailChimp.
New campaign sent
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 you send a new campaign on MailChimp.
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.
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 campaign summary available
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 there was a new campaign summary available.
History of campaigns scheduled
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 there is a new campaign scheduled on MailChimp.
History of campaigns sent
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 you send a new campaign on MailChimp.
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.
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 new subscriber
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 new subscriber to the specified list.
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.
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 new subscriber
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 new subscriber to the specified list.
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.
Campaign summary available
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 there is a new campaign summary available.
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.
Build an automation in seconds!
If
Select a trigger the automation will use
Campaign summary available
Cell updated in spreadsheet
New attachment
New campaign scheduled
New campaign sent
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 subscriber
New unsubscribed email
New worksheet in spreadsheet
Then
Select an action the automation will perform
Add label to email
Add multiple rows to spreadsheet
Add new subscriber
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
Post to channel
Remove label from conversation
Remove label from email
Reply to email
Send an email
Send yourself an email
Unsubscribe email address
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 Slack
Slack brings all your team communication into one place. Turn on Applets to bring important information into channels, quickly share photos, automate reminders, and much more.
About Mailchimp
Mailchimp features and integrations allow you to send marketing emails, automated messages, and targeted campaigns. Automatically save and share your Mailchimp analytics, track subscribers, and manage campaign scheduling.