How to connect Google Sheets + Mailchimp
Zapier lets you send info between Google Sheets and Mailchimp automatically—no code required.
Popular Google Sheets + Mailchimp workflows
- Add subscribers to Mailchimp for new Google Sheets rows
Add subscribers to Mailchimp for new Google Sheets rows
- Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
Save new Mailchimp subscribers to rows in Google Sheets spreadsheets
- Add new Mailchimp list subscribers to Google Sheets
Add new Mailchimp list subscribers to Google Sheets
- Create Mailchimp subscribers from a new or updated Google Sheets rows
Create Mailchimp subscribers from a new or updated Google Sheets rows
- Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it to Google Sheets
Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it to Google Sheets
- Add Updated Mailchimp Subscribers as New Rows of Data in Google Sheets
Add Updated Mailchimp Subscribers as New Rows of Data in Google Sheets
- Remove subscribers from Mailchimp when a row is updated on Google Sheets
Remove subscribers from Mailchimp when a row is updated on Google Sheets
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.


Do Even More with Google Sheets + Mailchimp
With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Google Sheets + Mailchimp workflows do more for them.
Zapier users love adding Lead Score by Zapier to their workflows
Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it to Google Sheets
Get more info about your new Mailchimp subscribers with Lead Score by Zapier and add it to Google SheetsPremiumZapier users love adding Dropcontact to their workflows
Use Dropcontact to add enriched and verified data from Google Sheets to Mailchimp
Use Dropcontact to add enriched and verified data from Google Sheets to MailchimpPremium
- New Spreadsheet Row (Team Drive)Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.Trigger
- New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.Trigger
- New SpreadsheetTriggered when you create a new spreadsheet.Trigger
- New or Updated Spreadsheet Row (Team Drive)Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.Trigger
- New or Updated Spreadsheet RowTriggered when a new row is added or modified in a spreadsheet.Trigger
- New WorksheetTriggered when you create a new worksheet in a spreadsheet.Trigger
- Create Spreadsheet ColumnCreate a new column in a specific spreadsheet.Action
- Create Spreadsheet RowCreate a new row in a specific spreadsheet.Action
- Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
- Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
- Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
- Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
- Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
- Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
- Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
- Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
- Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
- Mailchimp
Triggers when a new campaign is created or sent.
Scheduled
Trigger
- Mailchimp
Triggers when a recipient opens an e-mail in a specific campaign.
Scheduled
Trigger
- Mailchimp
Triggers when a recipient clicks a pre-specified link in your campaign.
Scheduled
Trigger
- Mailchimp
Triggers when a new audience is added to your MailChimp accounts.
Scheduled
Trigger
- Mailchimp
Triggers when a new customer is added to a selected store.
Scheduled
Trigger
- Mailchimp
Triggers when a new subscriber is added to an audience.
Instant
Trigger
- Mailchimp
Triggers when a new order is created.
Scheduled
Trigger
- Mailchimp
Triggers when any current subscriber unsubscribes from an audience.
Instant
Trigger
- Mailchimp
Triggers when a subscriber is added to a segment or tag within an audience.
Scheduled
Trigger
- Mailchimp
Triggers when a subscriber is added or updated in an audience.
Instant
Trigger
- Mailchimp
Creates a campaign draft.
Scheduled
Action
- Mailchimp
Creates a custom event for an existing subscriber.
Scheduled
Action
- Mailchimp
Add a new subscriber to an audience of your choosing. Can be used to update an existing subscriber too.
Scheduled
Action
- Mailchimp
Unsubscribe an email address from an audience of your choosing.
Scheduled
Action
- Mailchimp
Removes an existing subscriber by email address from a tag within an audience. Note: the email address
Scheduled
Action
- Mailchimp
Sends a campaign draft. PLEASE NOTE: This action sends an email to
Scheduled
Action
- Mailchimp
Adds a new note to an existing subscriber.
Scheduled
Action
- Mailchimp
Add an email address to a tag within an audience. Note: the email address
Scheduled
Action
- Mailchimp
Finds an existing campaign.
Scheduled
Action
- Mailchimp
Finds a customer by an email address.
Scheduled
Action
- Mailchimp
Searches for a new subscriber on your MailChimp audience.
Scheduled
Action
- Mailchimp
Finds an existing campaign.
Scheduled
Action
- Mailchimp
Searches for a new subscriber on your MailChimp audience.
Scheduled
Action
How Google Sheets + Mailchimp Integrations Work
- Step 1: Authenticate Google Sheets and Mailchimp.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
Google Sheets Tutorials
Mailchimp Tutorials
Related categories
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.