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 e-mail 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
Trigger on every click from a subscriber?
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.AudienceRequired
Subscriber EmailRequired
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
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
Bottom-Up
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
Bottom-Up
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 on every open from a subscriber?
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
Template
Email Content (HTML)
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
Delete Member
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
Template
Email Content (HTML)
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
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 To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
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
Bottom-Up
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?
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
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout 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
Similar apps
AWeber
Email Newsletters
Campaign Monitor
Email Newsletters
Emma
Email NewslettersRelated 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 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
- Create Google Sheets rows when new Mailchimp emails are opened
- Copy contacts from new Google Sheets rows to Mailchimp and tag them
- Add subscribers to tags on Mailchimp tags when rows are updated in Google Sheets
- Unsubscribe Mailchimp users added to new rows on Google Sheets
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
- Generate Google Sheets rows for new Mailchimp campaigns
- Add new Mailchimp subscribers to Google Sheets
- Create Google Sheets rows for new Mailchimp subscribers with a tag
- Create Google Sheets spreadsheet rows from new Mailchimp unsubscribers
- Tag subscribers on Mailchimp when new rows appear on Google Sheets spreadsheets
- Add rows to Google Sheets spreadsheets with new Mailchimp customers
- Update Google Sheets spreadsheet rows for new Mailchimp subscribers
- Create multiple rows in Google Sheets for new Mailchimp campaigns
- Write Mailchimp newsletters with ChatGPT from Google Sheets rows
- Add notes to Mailchimp subscribers from new or updated Google Sheets rows
- 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
- 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 Mailchimp campaigns 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
- Create Mailchimp tags from new Google Sheets spreadsheet rows (team drive)
- 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 Mailchimp campaigns from new Google Sheets team drive 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
- Add new Mailchimp subscribers to Google Sheets as rows in a spreadsheet
- Send Mailchimp campaigns for new or updated Google Sheets spreadsheet rows
- Create multiple spreadsheet rows in Google Sheets for new Mailchimp customers
- 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
- Write Mailchimp newsletters with Google Vertex AI from Google Sheets rows
- Write Mailchimp newsletters with Google AI Studio (Gemini) from Google Sheets rows
Related Zap Templates
- Add subscribers to Mailchimp for new Google Sheets rows
- Create Mailchimp subscribers from a new or updated Google Sheets rows
- Add or update Mailchimp subscribers with new or updated Google Sheets rows in Team Drive
- Copy contacts from new Google Sheets rows to Mailchimp and tag them
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
- Create Google Sheets rows for new Mailchimp subscribers with a tag
- Add rows to Google Sheets spreadsheets with new Mailchimp customers
- Write Mailchimp newsletters with ChatGPT from Google Sheets rows
- Create or update new Mailchimp subscribers from new or updated rows in Google Sheets in Team Drive
- Add new orders in Mailchimp to a Google Sheet
- Add subscribers to Mailchimp from new Google Sheets rows
- Send Mailchimp campaigns for new Google Sheets rows
- Create columns in Google Sheets for new Mailchimp audiences
- Create Mailchimp tags from new Google Sheets spreadsheet rows (team drive)
- Update Google Sheets rows with new Mailchimp audiences for seamless tracking
- Create and send Mailchimp campaigns from new Google Sheets spreadsheets
- Create Mailchimp campaigns from new or updated Google Sheets rows
- Add new Mailchimp subscribers to Google Sheets as rows in a spreadsheet
- 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
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Add new Mailchimp list subscribers to Google Sheets
- Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it 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
- Create Google Sheets spreadsheet rows from new Mailchimp unsubscribers
- Update Google Sheets spreadsheet rows for new Mailchimp subscribers
- Add notes to Mailchimp subscribers from new or updated Google Sheets rows
- Add rows in Google Sheets with new Mailchimp subscribers
- Create rows in Google Sheets spreadsheets for new Mailchimp orders
- Create Mailchimp campaigns 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 customers to a Google Sheets spreadsheet for efficient organization
- Add new Mailchimp audiences to Google Sheets as rows
- Create and update Mailchimp subscribers from new Google Sheets spreadsheets
- Remove Mailchimp subscribers from a tag when new Google Sheets rows are added
- Send Mailchimp campaigns for new or updated Google Sheets spreadsheet rows
- "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)
- Write Mailchimp newsletters with Google Vertex AI from Google Sheets rows
- Add new Google Sheet updates to a Mailchimp list
- Add Updated Mailchimp Subscribers as New Rows of Data in Google Sheets
- Create Google Sheets rows when new Mailchimp emails are opened
- Unsubscribe Mailchimp users added to new rows on Google Sheets
- Add new Mailchimp subscribers to Google Sheets
- Tag subscribers on Mailchimp when new rows appear on Google Sheets spreadsheets
- Create multiple rows in Google Sheets for new Mailchimp campaigns
- Add or update Mailchimp subscribers with new Google Sheets rows 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
- 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
- Add new Mailchimp subscribers to Google Sheets as multiple rows
- Create Mailchimp campaigns from new Google Sheets team drive rows
- Update Google Sheets rows for new or updated Mailchimp subscribers
- Update Google Sheets rows when new Mailchimp emails are opened
- Create multiple spreadsheet rows in Google Sheets for new Mailchimp customers
- 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
- Write Mailchimp newsletters with Google AI Studio (Gemini) from Google Sheets rows