Google Sheets + Mailchimp
Track opened Mailchimp emails by creating multiple rows in Google Sheets
When an email is opened in Mailchimp, keep track of your engaged contacts by adding their information to a Google Sheets document instantly. This automated workflow saves you time by logging email open events in real-time, helping you maintain an organized record of email interactions for better customer engagement and marketing strategies. No manual data entry required, freeing up your time for more important tasks.
When an email is opened in Mailchimp, keep track of your engaged contacts by adding their information to a Google Sheets document instantly. This automated workflow saves you time by logging email open events in real-time, helping you maintain an organized record of email interactions for better customer engagement and marketing strategies. No manual data entry required, freeing up your time for more important tasks.
- When this happens...
Email OpenedTriggers when a recipient opens an email in a specific campaign.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Multiple Spreadsheet RowsCreate one or more new rows in a specific spreadsheet (with line item support).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Audience
LinkRequired
Track all links clicks
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAudienceRequired
Segment or TagRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAudienceRequired
Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Tag nameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
CompanyRequired
Address 1Required
Address 2
CityRequired
StateRequired
ZipRequired
CountryRequired
Phone
Permission ReminderRequired
Email Type OptionRequired
From NameRequired
From EmailRequired
SubjectRequired
LanguageRequired
Notify On Subscribe
Notify On Unsubscribe
Double Optin
Marketing Permissions
Use Archive Bar
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Email AddressRequired
Delete Contact
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
TagRequired
Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appAudienceRequired
Tag nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Campaign Name
AudienceRequired
Segment or Tag
Email SubjectRequired
Preview Text
From NameRequired
From Email AddressRequired
To Name
Content Type
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearchRequired
Audience
AudienceRequired
Subscriber EmailRequired
New Email
StatusRequired
Double Opt-In
Update Existing
Replace Groups
Groups
Language Code
Tag(s)
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite existing worksheets
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Audience
Trigger each time a subscriber opens an email
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Audience
Triggers when a new audience is added to your MailChimp accounts.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAudienceRequired
Note About Samples
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.AudienceRequired
Note About Samples
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Campaign Name
AudienceRequired
Segment or Tag
Email SubjectRequired
Preview Text
From NameRequired
From Email AddressRequired
To Name
Content Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Email AddressRequired
Custom Event NameRequired
Properties
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Subscriber EmailRequired
New Email
StatusRequired
Double Opt-In
Update Existing
Replace Groups
Groups
Language Code
Tag(s)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
TagRequired
Email AddressRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Email AddressRequired
NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StoreRequired
Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearchRequired
Audience
ActionThis is an event a Zap performs.SearchFind existing data in your appAudienceRequired
Tag nameRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Mailchimp
Share your ideas with Mailchimp email newsletters—then use its landing page and form builders to grow your lists and take marketing further with drip and transactional emails.
Related categories
Related Zap Templates
- Add subscribers to Mailchimp for new Google Sheets rows
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Add new Google Sheet updates to a Mailchimp list
- Create Mailchimp subscribers from a new or updated Google Sheets rows
- Add new Mailchimp list subscribers to Google Sheets
- Add Updated Mailchimp Subscribers as New Rows of Data in Google Sheets
- Add subscribers to tags on Mailchimp tags when rows are updated in Google Sheets
- Add or update Mailchimp subscribers with new or updated Google Sheets rows in Team Drive
- Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it to Google Sheets
- Copy contacts from new Google Sheets rows to Mailchimp and tag them
- Generate Google Sheets rows for new Mailchimp campaigns
- Create Google Sheets rows when new Mailchimp emails are opened
- Tag subscribers on Mailchimp when new rows appear on Google Sheets spreadsheets
- Create Mailchimp campaigns from new Google Sheets rows
- Add rows to Google Sheets spreadsheets with new Mailchimp customers
- Create Google Sheets rows for new Mailchimp subscribers with a tag
- Update Google Sheets spreadsheet rows for new Mailchimp subscribers
- Create Mailchimp tags from new Google Sheets spreadsheet rows (team drive)
- Add new Mailchimp subscribers to Google Sheets
- Add new Mailchimp subscribers to Google Sheets as rows in a spreadsheet
- Create multiple rows in Google Sheets for new Mailchimp campaigns
- Unsubscribe Mailchimp users added to new rows on Google Sheets
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
- Add or update Mailchimp subscribers with new Google Sheets rows in Team Drive
- Create or update new Mailchimp subscribers from new or updated rows in Google Sheets in Team Drive
- Create Google Sheets spreadsheet rows from new Mailchimp unsubscribers
- Add rows in Google Sheets with new Mailchimp subscribers
- Use Dropcontact to add enriched and verified data from Google Sheets to Mailchimp
- Add new orders in Mailchimp to a Google Sheet
- Create rows in Google Sheets spreadsheets for new Mailchimp orders
- Create Google Sheets rows from new clicked links in Mailchimp
- Add subscribers to Mailchimp from new Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new or updated Mailchimp subscribers
- Send Mailchimp campaigns for new Google Sheets rows
- Add new Google Sheets spreadsheet rows to Mailchimp as tagged subscribers
- Create Mailchimp custom events from new Google Sheets rows
- Create columns in Google Sheets for new Mailchimp audiences
- Update Google Sheets rows with new Mailchimp subscribers in segments or tags
- Create spreadsheets in Google Sheets for new Mailchimp audiences
- Add new Mailchimp customers to a Google Sheets spreadsheet for efficient organization
- Add new Mailchimp subscribers to Google Sheets as multiple rows
- Update Google Sheets rows with new Mailchimp audiences for seamless tracking
- Add new Mailchimp audiences to Google Sheets as rows
- Create and send Mailchimp campaigns from new Google Sheets spreadsheets
- Create and update Mailchimp subscribers from new Google Sheets spreadsheets
- Update Google Sheets rows for new or updated Mailchimp subscribers
- Create Mailchimp campaigns from new or updated Google Sheets rows
- Remove Mailchimp subscribers from a tag when new Google Sheets rows are added
- Update Google Sheets rows when new Mailchimp emails are opened
- Send Mailchimp campaigns for new or updated Google Sheets spreadsheet rows
- Create multiple spreadsheet rows in Google Sheets for new Mailchimp customers
- Add notes to Mailchimp subscribers from new or updated Google Sheets rows
- Send Mailchimp campaigns from new Google Sheets spreadsheet rows in team drive
- "copy Google Sheets worksheets when new Mailchimp links are clicked"
- Track Mailchimp link clicks by creating new rows in Google Sheets
- Track opened Mailchimp emails by creating new rows in Google Sheets
- Update Google Sheets rows for new or updated Mailchimp subscribers
- Update Google Sheets rows for every new Mailchimp subscriber
- Create new Google Sheets spreadsheets from opened Mailchimp emails
- Create Google Sheets spreadsheets for new Mailchimp subscribers in segment or tag
- Create spreadsheet columns in Google Sheets for new or updated subscribers in Mailchimp
- Create new Google Sheets columns for each new Mailchimp campaign
- Delete Google Sheets rows when new unsubscribers are identified in Mailchimp
- Create spreadsheets in Google Sheets for new or updated subscribers in Mailchimp
- "create new Google Sheets worksheets from new Mailchimp audiences"
- Create custom events in Mailchimp from new or updated rows in Google Sheets team drive
- Manage new Mailchimp audiences by processing custom actions in Google Sheets
- Copy worksheets in Google Sheets for new or updated subscribers in Mailchimp
- Track new Mailchimp unsubscribers by creating multiple rows in Google Sheets
- Add Mailchimp subscribers to tag from new or updated rows in Google Sheets team drive
- Create multiple rows in Google Sheets when new links are clicked in Mailchimp
- Update Google Sheets rows with new Mailchimp campaigns details
- Remove Mailchimp subscribers from tag when new or updated rows appear in Google Sheets
- Handle new or updated Google Sheets rows with custom actions in Mailchimp
- Create new Mailchimp tags from new Google Sheets rows
- Create new Mailchimp tags from new Google Sheets spreadsheets
- Create new Mailchimp tags from new Google Sheets worksheets
- Add new Mailchimp subscribers to Google Sheets with custom actions (beta)
- Copy new Mailchimp subscribers to Google Sheets worksheets instantly
- Create spreadsheets in Google Sheets for new campaigns in Mailchimp
- Create Mailchimp tags from new or updated rows in Google Sheets
- Add subscribers to Mailchimp verified by EmailListVerify to new Google Sheets (Team Drive) rows
- Update Google Sheets rows when new unsubscribers emerge in Mailchimp
- Create new Mailchimp campaigns from new Google Sheets worksheets
- Update Mailchimp with api requests whenever new rows are added in Google Sheets
- Archive Mailchimp subscribers from new or updated rows in Google Sheets
- Send new Google Sheets worksheets to Mailchimp for campaign creation
- Add new Mailchimp subscriber segments or tags to Google Sheets immediately
Related Zap Templates
- Add subscribers to Mailchimp for new Google Sheets rows
- Create Mailchimp subscribers from a new or updated Google Sheets rows
- Add subscribers to tags on Mailchimp tags when rows are updated in Google Sheets
- Copy contacts from new Google Sheets rows to Mailchimp and tag them
- Tag subscribers on Mailchimp when new rows appear on Google Sheets spreadsheets
- Create Google Sheets rows for new Mailchimp subscribers with a tag
- Add new Mailchimp subscribers to Google Sheets
- Unsubscribe Mailchimp users added to new rows on Google Sheets
- Create or update new Mailchimp subscribers from new or updated rows in Google Sheets in Team Drive
- Use Dropcontact to add enriched and verified data from Google Sheets to Mailchimp
- Create Google Sheets rows from new clicked links in Mailchimp
- Send Mailchimp campaigns for new Google Sheets rows
- Create columns in Google Sheets for new Mailchimp audiences
- Add new Mailchimp customers to a Google Sheets spreadsheet for efficient organization
- Add new Mailchimp audiences to Google Sheets as rows
- Update Google Sheets rows for new or updated Mailchimp subscribers
- Update Google Sheets rows when new Mailchimp emails are opened
- Add notes to Mailchimp subscribers from new or updated Google Sheets rows
- Track Mailchimp link clicks by creating new rows in Google Sheets
- Update Google Sheets rows for every new Mailchimp subscriber
- Create spreadsheet columns in Google Sheets for new or updated subscribers in Mailchimp
- Create spreadsheets in Google Sheets for new or updated subscribers in Mailchimp
- Manage new Mailchimp audiences by processing custom actions in Google Sheets
- Add Mailchimp subscribers to tag from new or updated rows in Google Sheets team drive
- Remove Mailchimp subscribers from tag when new or updated rows appear in Google Sheets
- Create new Mailchimp tags from new Google Sheets spreadsheets
- Copy new Mailchimp subscribers to Google Sheets worksheets instantly
- Add subscribers to Mailchimp verified by EmailListVerify to new Google Sheets (Team Drive) rows
- Update Mailchimp with api requests whenever new rows are added in Google Sheets
- Add new Mailchimp subscriber segments or tags to Google Sheets immediately
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Add new Mailchimp list subscribers to Google Sheets
- Add or update Mailchimp subscribers with new or updated Google Sheets rows in Team Drive
- Generate Google Sheets rows for new Mailchimp campaigns
- Create Mailchimp campaigns from new Google Sheets rows
- Update Google Sheets spreadsheet rows for new Mailchimp subscribers
- Add new Mailchimp subscribers to Google Sheets as rows in a spreadsheet
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
- Create Google Sheets spreadsheet rows from new Mailchimp unsubscribers
- Add new orders in Mailchimp to a Google Sheet
- Add subscribers to Mailchimp from new Google Sheets rows
- Add new Google Sheets spreadsheet rows to Mailchimp as tagged subscribers
- Update Google Sheets rows with new Mailchimp subscribers in segments or tags
- Add new Mailchimp subscribers to Google Sheets as multiple rows
- Create and send Mailchimp campaigns from new Google Sheets spreadsheets
- Create Mailchimp campaigns from new or updated Google Sheets rows
- Send Mailchimp campaigns for new or updated Google Sheets spreadsheet rows
- Send Mailchimp campaigns from new Google Sheets spreadsheet rows in team drive
- Track opened Mailchimp emails by creating new rows in Google Sheets
- Create new Google Sheets spreadsheets from opened Mailchimp emails
- Create new Google Sheets columns for each new Mailchimp campaign
- "create new Google Sheets worksheets from new Mailchimp audiences"
- Copy worksheets in Google Sheets for new or updated subscribers in Mailchimp
- Create multiple rows in Google Sheets when new links are clicked in Mailchimp
- Handle new or updated Google Sheets rows with custom actions in Mailchimp
- Create new Mailchimp tags from new Google Sheets worksheets
- Create spreadsheets in Google Sheets for new campaigns in Mailchimp
- Update Google Sheets rows when new unsubscribers emerge in Mailchimp
- Archive Mailchimp subscribers from new or updated rows in Google Sheets
- Add new Google Sheet updates to a Mailchimp list
- Add Updated Mailchimp Subscribers as New Rows of Data in Google Sheets
- Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it to Google Sheets
- Create Google Sheets rows when new Mailchimp emails are opened
- Add rows to Google Sheets spreadsheets with new Mailchimp customers
- Create Mailchimp tags from new Google Sheets spreadsheet rows (team drive)
- Create multiple rows in Google Sheets for new Mailchimp campaigns
- Add or update Mailchimp subscribers with new Google Sheets rows in Team Drive
- Add rows in Google Sheets with new Mailchimp subscribers
- Create rows in Google Sheets spreadsheets for new Mailchimp orders
- Create multiple spreadsheet rows in Google Sheets for new or updated Mailchimp subscribers
- Create Mailchimp custom events from new Google Sheets rows
- Create spreadsheets in Google Sheets for new Mailchimp audiences
- Update Google Sheets rows with new Mailchimp audiences for seamless tracking
- Create and update Mailchimp subscribers from new Google Sheets spreadsheets
- Remove Mailchimp subscribers from a tag when new Google Sheets rows are added
- Create multiple spreadsheet rows in Google Sheets for new Mailchimp customers
- "copy Google Sheets worksheets when new Mailchimp links are clicked"
- Update Google Sheets rows for new or updated Mailchimp subscribers
- Create Google Sheets spreadsheets for new Mailchimp subscribers in segment or tag
- Delete Google Sheets rows when new unsubscribers are identified in Mailchimp
- Create custom events in Mailchimp from new or updated rows in Google Sheets team drive
- Track new Mailchimp unsubscribers by creating multiple rows in Google Sheets
- Update Google Sheets rows with new Mailchimp campaigns details
- Create new Mailchimp tags from new Google Sheets rows
- Add new Mailchimp subscribers to Google Sheets with custom actions (beta)
- Create Mailchimp tags from new or updated rows in Google Sheets
- Create new Mailchimp campaigns from new Google Sheets worksheets
- Send new Google Sheets worksheets to Mailchimp for campaign creation