Google Sheets and Mailchimp, ready to switch on
A row you add joins the Mailchimp audience with the tags from your tag column, changing that cell changes the subscriber's tags, and every signup, unsubscribe and bounce shows on its own row, so a list kept in a spreadsheet stays true in both places. You paste two keys in your account and it runs, in about ten minutes.
No setup fee, cancel any month, and a person on live chat if a key doesn't work.
More with these apps: all Google Sheets integrations · all Mailchimp integrations
What moves, and when
The details you would normally get after a sales call. Here they are up front.
| What | Direction | When | Rule |
|---|---|---|---|
| Row joins the audience | Google Sheets to Mailchimp | Every few minutes | Email, first and last name, and the tags from the columns you map, into the audience you choose |
| Tag cells are live | Google Sheets to Mailchimp | When a cell changes | Add a word to the tag column and the subscriber gets it; delete it and the tag is removed |
| Signups land as rows | Mailchimp to Google Sheets | Within seconds | New subscribers appear at the bottom with source and date, so the sheet is the whole audience |
| Left or bounced | Mailchimp to Google Sheets | Within seconds | The status cell on that row changes, so the sheet never shows someone as subscribed who left |
| Consent column | In the sheet | Always | A yes or no column you name gates who joins; blank means no |
| Email is the key | Both ways | Every change | One address, one row, one subscriber |
How to set up Google Sheets and Mailchimp
Ten minutes of your time, then it's ours.
- Choose Google Sheets and MailchimpPress Connect. This pair is already selected on the checkout page at $39 a month, and there's nothing else to pick.
- Pay and open your accountCard or invoice, about two minutes. The account opens with this integration waiting for its two keys.
- Paste the Google Sheets link and the Mailchimp API key
- Google Sheets link: create or open the spreadsheet, share it with the address our engineer sends you or with anyone who has the link, and paste the link from the address bar. Full Google Sheets guide
- Mailchimp API key: in Mailchimp open your profile icon, then Profile, then Extras, then API keys. Full Mailchimp guide
Each screen carries the full guide with the exact menu names, about four minutes for both. - We check both keysEach key is checked against Google Sheets's and Mailchimp's own API the moment you paste it. If one doesn't pass, the screen says what to fix, and a person joins the chat if that isn't enough.
- Add one test subscriber, then it's RunningA minute or two. Add a subscriber in Mailchimp and watch the row appear, then change a tag and watch the same row update.
When Google Sheets or Mailchimp changes its API, we fix it within a working day. You don't get a ticket to solve.
- Everything in the table above, with monitoring on.
- Fixes when either app changes its API.
- A person on live chat, replies within a working hour.
- Custom logic beyond the table is priced separately.
No setup fee, cancel any month
Ways to connect Google Sheets and Mailchimp
Two ways people connect these two, and what each one asks of you.
Before you decide
Isn't there an add-on for this?
There are several in the Workspace Marketplace, and connector tools that sync a sheet with an audience. They need somebody to install and, often, to press sync. This pair runs on its own, both directions, with a person fixing it when either side changes. If an add-on does the job, use the add-on.
What about consent?
The sheet is your list, so consent is your responsibility, and we'd rather say that plainly. Adding addresses that never agreed to hear from you is how an audience gets flagged. The consent column gates who joins.
What if mine is a bit different?
Tell us what should go where in plain words. Small changes to the rules above are usually free; bigger ones we price the same day and build into the same account.
