What This Workflow Does
This workflow automatically takes email addresses from a Google Sheet and adds them to a Mailchimp mailing list. It solves the problem of spending time copying emails by hand, which can cause mistakes and delays. After running, new emails from the sheet appear in Mailchimp without any manual work.
Who Should Use This Workflow
This workflow is good for people who keep subscriber emails in Google Sheets and want to send newsletters or marketing emails through Mailchimp. It helps avoid manual updates and errors for small businesses or teams growing their email list.
Tools and Services Used
- n8n: An automation tool to run workflows.
- Google Sheets API: Reads email data from a spreadsheet.
- Mailchimp API: Adds emails to the chosen mailing list.
Inputs, Processing Steps, and Outputs
Inputs
- Google Sheet with subscriber emails in columns A-C from sheet named “sheetone”.
- Mailchimp mailing list ID where emails will be added.
Processing Steps
- Interval node triggers workflow every 2 minutes to check for new emails.
- Google Sheets node reads emails from the specified sheet range.
- Mailchimp node subscribes each email to the chosen Mailchimp list.
- Manual Trigger node can start the workflow immediately when needed.
Output
New subscribers are added to the Mailchimp mailing list without manual copying.
Beginner Step-by-Step: How to Use This Workflow in n8n
Step 1: Import the Workflow
- Click the Download button on this page to get the workflow file.
- Open the n8n editor where the workflow runs.
- Use the option Import from File to upload the downloaded workflow.
Step 2: Configure Credentials and IDs
- Set up Google API credentials for the Google Sheets node so it can read the spreadsheet.
- Enter the Mailchimp API Key in the Mailchimp node to allow subscription actions.
- Update the Google Sheet ID in the Google Sheets node to match your spreadsheet.
- Set the correct Mailchimp list ID in the Mailchimp node.
- Make sure email columns match the exact field names expected (usually “email” in the sheet).
Step 3: Test the Workflow
- Use the Manual Trigger node to run the workflow immediately.
- Check if subscriber emails from the sheet are properly added to Mailchimp.
Step 4: Activate for Production
- Save the workflow.
- Click Activate to enable the Interval node running every 2 minutes.
- Monitor logs in n8n for errors or successful runs.
If running on your own server, consider self-host n8n for control and privacy.
Common Edge Cases and Errors
- Invalid Credentials: Happens if API keys for Google Sheets or Mailchimp are incorrect. Fix by rechecking and reauthorizing in n8n credentials.
- Email Field Missing or Incorrect: Occurs if the sheet column name does not match the mapping expression in Mailchimp node. Correct the expression or sheet header.
- Duplicate Subscribers: Without additional logic, duplicates may be processed repeatedly. Not handled here explicitly.
Customization Ideas
- Change the Interval node to run less often, like every 5 or 10 minutes.
- Add more profile fields from Google Sheets (like first name) into Mailchimp for richer contacts.
- Use a Code node to filter only new or unique emails to reduce redundant API calls.
- Set notifications via email or Slack if an error occurs by adding more nodes.
Summary
✓ Automatically reads email addresses from Google Sheets
✓ Adds new subscribers to Mailchimp list every 2 minutes
✓ Removes manual copy-paste errors and delays
✓ Saves about 2 hours of manual work weekly
→ Keeps email marketing lists fresh and accurate
→ Enables easy testing and manual runs with trigger node
→ Supports easy customizations to suit different needs