Automatically Add Google Form Respondents as Mailchimp Subscribers
When someone fills out your Google Form, this workflow instantly adds them as a subscriber to your Mailchimp audience. No more manual CSV exports or copy-pasting email addresses.
- 1
Connect your Google Sheet as the trigger
Add a
Google Sheets Triggernode. InAuthentication, connect your Google account. SetTrigger OntoRow Added. Enter theDocument IDof the Google Sheet linked to your form (found in the sheet URL). Set theSheet Nameto the tab where form responses are stored, typically calledForm Responses 1. SetPolling Timesto every minute or your preferred interval. This node fires whenever someone submits your form. - 2
Extract and map the subscriber fields
Add a
Setnode connected after the trigger. Create three fields: setemailto the expression pointing to the email column from your form (e.g.{{ $json['Email Address'] }}), setfirstNameto{{ $json['First Name'] }}, and setlastNameto{{ $json['Last Name'] }}. Adjust the field names to match the exact column headers in your Google Sheet. This cleans up the data before sending it to Mailchimp. - 3
Check that an email address exists
Add an
Ifnode connected after the Set node. SetValue 1to{{ $json.email }}and the condition toIs Not Empty. Connect theTrueoutput to the next Mailchimp node. This prevents errors from blank rows or form submissions missing an email field. - 4
Add the subscriber to Mailchimp
Add a
Mailchimpnode connected to theTruebranch of the If node. InAuthentication, connect your Mailchimp account using your API key (found in Mailchimp under Account > Extras > API Keys). SetOperationtoSubscribeandResourcetoMember. Enter yourList ID(found in Mailchimp under Audience > Settings > Audience name and defaults). MapEmailto{{ $json.email }},First Nameto{{ $json.firstName }}, andLast Nameto{{ $json.lastName }}. SetStatustosubscribed.
Frequently asked questions
Do I need to link my Google Form to a Google Sheet first?
Yes. Open your Google Form, click the Responses tab, then click the green Google Sheets icon to link it to a spreadsheet. n8n watches that sheet for new rows, which appear each time someone submits your form.
What happens if someone submits the form twice with the same email?
Mailchimp handles duplicate emails gracefully. If the email already exists in your audience, Mailchimp will update the subscriber record rather than creating a duplicate, so your list stays clean automatically.
Can I add subscribers to a specific Mailchimp tag or group instead of the whole audience?
Yes. In the Mailchimp node, expand the additional fields and set `Tags` to any tag name you want applied to new subscribers. This is useful for segmenting leads by which form they came from.