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.
TriggerPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planAudienceRequired
Segment or TagRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.CampaignRequired
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
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
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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 ZapPollingZapier 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 ZapPollingZapier 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.CampaignRequired
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.Api Docs Info
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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 ZapPollingZapier 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.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
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
- Create Mailchimp subscribers from a new or updated Google Sheets rows
- Add new Mailchimp list subscribers to Google Sheets
- Add new Google Sheet updates to a Mailchimp list
- 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
- Generate Google Sheets rows for new Mailchimp campaigns
- Update Google Sheets rows with new Mailchimp subscribers in segments or tags
- Create Mailchimp campaigns from new Google Sheets rows
- Tag subscribers on Mailchimp when new rows appear on Google Sheets spreadsheets
- Track new Mailchimp unsubscribers by creating multiple rows in Google Sheets
- Create Google Sheets rows for new Mailchimp subscribers with a tag
- Create and send Mailchimp campaigns from new Google Sheets spreadsheets
- Create Mailchimp tags from new Google Sheets spreadsheet rows (team drive)
- Add new Mailchimp subscribers to Google Sheets as rows in a spreadsheet
- Update Google Sheets spreadsheet rows for new Mailchimp subscribers
- Unsubscribe Mailchimp users added to new rows on Google Sheets
- Create Google Sheets rows when new Mailchimp emails are opened
- Track Mailchimp link clicks by creating new rows in Google Sheets
- Add rows to Google Sheets spreadsheets with new Mailchimp customers
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
- Add new Mailchimp subscribers to 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
- Copy contacts from new Google Sheets rows to Mailchimp and tag them
- 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
- 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 update Mailchimp subscribers from new Google Sheets spreadsheets
- Update Google Sheets rows for new or updated Mailchimp subscribers
- Create multiple rows in Google Sheets for new Mailchimp campaigns
- 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 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
- 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
- Create multiple rows in Google Sheets when new audiences are added in Mailchimp
- Add new Mailchimp subscribers to a Google Sheets spreadsheet row instantly
- Create multiple rows in Google Sheets for every new campaign in Mailchimp
- Update Google Sheets rows when new subscribers join a segment or tag in Mailchimp
- Track new Mailchimp audiences by creating rows in Google Sheets
- Add notes to Mailchimp subscribers from new Google Sheets rows
- Add new Google Sheets rows to Mailchimp as tagged subscribers
- Add new Google Sheets rows to Mailchimp as tagged subscribers
- Create multiple Google Sheets rows for new Mailchimp subscribers in segment or tag
- Add new or updated Google Sheets rows to tag Mailchimp subscribers
- Create Google Sheets rows at top for new or updated Mailchimp subscribers
Related Zap Templates
- Add subscribers to Mailchimp for new Google Sheets rows
- Add new Mailchimp list subscribers to Google Sheets
- Add subscribers to tags on Mailchimp tags when rows are updated in Google Sheets
- Generate Google Sheets rows for new Mailchimp campaigns
- Tag subscribers on Mailchimp when new rows appear on Google Sheets spreadsheets
- Create and send Mailchimp campaigns from new Google Sheets spreadsheets
- Update Google Sheets spreadsheet rows for new Mailchimp subscribers
- Track Mailchimp link clicks by creating new rows in Google Sheets
- Add new Mailchimp subscribers to Google Sheets
- Create Google Sheets spreadsheet rows from new Mailchimp unsubscribers
- 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 subscribers to Google Sheets as multiple rows
- Create and update Mailchimp subscribers 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
- 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
- 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
- Create multiple rows in Google Sheets for every new campaign in Mailchimp
- Add notes to Mailchimp subscribers from new Google Sheets rows
- Create multiple Google Sheets rows for new Mailchimp subscribers in segment or tag
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Add new Google Sheet updates to a Mailchimp list
- Add or update Mailchimp subscribers with new or updated Google Sheets rows in Team Drive
- Update Google Sheets rows with new Mailchimp subscribers in segments or tags
- Track new Mailchimp unsubscribers by creating multiple rows in Google Sheets
- Create Mailchimp tags from new Google Sheets spreadsheet rows (team drive)
- Unsubscribe Mailchimp users added to new rows on Google Sheets
- Add rows to Google Sheets spreadsheets with new Mailchimp customers
- Add or update Mailchimp subscribers with new Google Sheets rows in Team Drive
- Copy contacts from new Google Sheets rows to Mailchimp and tag them
- 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
- Create spreadsheets in Google Sheets for new Mailchimp audiences
- Update Google Sheets rows with new Mailchimp audiences for seamless tracking
- Update Google Sheets rows for new or updated Mailchimp subscribers
- 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 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
- 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
- Create multiple rows in Google Sheets when new audiences are added in Mailchimp
- Update Google Sheets rows when new subscribers join a segment or tag in Mailchimp
- Add new Google Sheets rows to Mailchimp as tagged subscribers
- Add new or updated Google Sheets rows to tag Mailchimp subscribers
- Create Mailchimp subscribers from a new or updated Google Sheets rows
- 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 Mailchimp campaigns from new Google Sheets rows
- Create Google Sheets rows for new Mailchimp subscribers with a tag
- Add new Mailchimp subscribers to Google Sheets as rows in a spreadsheet
- Create Google Sheets rows when new Mailchimp emails are opened
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
- Create or update new Mailchimp subscribers from new or updated rows in Google Sheets 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
- Add new Mailchimp customers to a Google Sheets spreadsheet for efficient organization
- Add new Mailchimp audiences to Google Sheets as rows
- Create multiple rows in Google Sheets for new Mailchimp campaigns
- Update Google Sheets rows when new Mailchimp emails are opened
- Add notes to Mailchimp subscribers from new or updated Google Sheets rows
- 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
- 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
- Add new Mailchimp subscribers to a Google Sheets spreadsheet row instantly
- Track new Mailchimp audiences by creating rows in Google Sheets
- Add new Google Sheets rows to Mailchimp as tagged subscribers
- Create Google Sheets rows at top for new or updated Mailchimp subscribers