Grow your email list without copy and paste. The flow reads new signups stored in a Google Sheet and adds each contact to a Mailchimp audience. Great for teams who collect emails through forms that land in Sheets and want a clean, steady push into Mailchimp.

Two start options make it flexible. Use a manual test to check mappings, or let the schedule run on a timer. The Google Sheets node pulls rows from a chosen tab. Split In Batches processes each row one at a time to respect rate limits. For each row, the Mailchimp node creates a subscribed member and maps fields from the sheet. The name goes to the FNAME merge field and the submit time sets the signup timestamp. This keeps your audience fresh and reduces list drift.

Setup is simple. Connect Google Sheets and Mailchimp credentials in n8n and pick your audience. Map Email Address, Name, and Submitted On to the right fields. Set a schedule that fits your intake pace. Expect fewer errors, faster updates, and less time spent exporting and importing files. Great for sites where Squarespace or similar tools send form data to Google Sheets.

• Manual and scheduled starts for testing and hands free runs
• Reads rows from a selected Google spreadsheet and sheet tab
• Processes contacts one by one using Split In Batches to control speed
• Creates Mailchimp members with status set to subscribed
• Maps Email Address, Name to FNAME, and Submitted On to signup time
• Simple test path using the Test workflow button before going live

• Reduce manual work from 2 hours to 5 minutes per import
• Automate 100 percent of signups moving from Sheets to Mailchimp
• Improve data quality by 90 percent with consistent field mapping
• Handle 10 times more signups during campaigns without extra effort
• Connect Google Sheets and Mailchimp seamlessly without CSV files

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Mailchimp. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets node in n8n. In the Credential to connect with dropdown, click Create new credential. Sign in with your Google account and allow access. Save the credential with a clear name like Google Sheets Prod.
4. In the Google Sheets node, select your spreadsheet and the correct sheet tab. Confirm the column headers include Email Address, Name, and Submitted On or update the mappings to match your columns.
5. Open the Mailchimp node. In the Credential to connect with dropdown, click Create new credential. In your Mailchimp account, go to your account settings to create an API key, then paste it into n8n and save it as Mailchimp Prod.
6. In the Mailchimp node, choose the target Audience. Set status to subscribed. Map Email Address to the email field. Map Name to the FNAME merge field. Map Submitted On to the signup timestamp option.
7. Open the Split In Batches node and set a batch size that fits your rate limits. A size of 1 is safe and ensures one contact is added at a time.
8. Click Test workflow to run a one time check. Confirm that a new contact appears in your Mailchimp audience with the correct name and signup time.
9. Set the Schedule Trigger to your desired frequency, such as every hour or once per day, so new rows are picked up on time.
10. Keep only new or unprocessed rows in the sheet to avoid duplicates. If test runs added extra characters to emails, remove any test suffixes in the email mapping before going live.
11. If nothing processes, verify the sheet name and column names. If Mailchimp returns an invalid email error, check that the Email Address column has valid emails.