SheetCrew for Mailchimp: user guide

1. Open a Google Sheet and install SheetCrew for Mailchimp from Extensions → Add-ons → Get add-ons. During early access we install it for you.
2. Open Extensions → SheetCrew for Mailchimp and choose Connect. The first time, Google asks you to allow it to edit the current spreadsheet. It can only see the spreadsheet you are in.
3. Create your free SheetCrew account when asked. If you already use another SheetCrew add-on, you are signed in already.
4. Paste your API key (ends in something like -us15). You find it in Mailchimp under Profile → Extras → API keys → Create A Key.

Find and archive contacts you're paying for

1. Choose Load contacts…. Pick one audience by number, or leave it empty to load all audiences into the Mailchimp contacts sheet.
2. Tick what to archive, using any of these:
   • Check unsubscribed and cleaned: contacts who unsubscribed or bounced.
   • Find inactive contacts…: subscribed contacts who joined more than the months you enter (6 by default) and have never opened or clicked.
   • Find duplicates across audiences: the same email in more than one audience. One copy is kept (subscribed first, then the earliest sign-up) and the others are ticked. Needs all audiences loaded.
   • Find risky addresses: malformed addresses, likely typos such as gmial.com or .con, throwaway inboxes, and shared role inboxes such as info@ or sales@. Role inboxes can be real customers, so review them.
3. The Flag column says why each row was ticked. Untick anything you want to keep.
4. Choose Archive checked and type ARCHIVE. Archived contacts stop counting toward your bill and keep their history.