Log to Google Sheets for Every New Mailchimp Subscriber
The moment someone subscribes on Mailchimp, this log to google sheets automatically — so new subscribers get an instant, consistent welcome and you never track signups by hand.
- 1
Step 1 — Trigger on new subscriber
Add the
Mailchimptrigger. Confirm the payload includes the email and any name fields. - 2
Step 2 — Clean the data
Add a
Setnode to standardiseemailandnameso the next step is reliable regardless of how Mailchimp formats them. - 3
Step 3 — Log to Google Sheets
Add a
Google Sheetsnode to append a row with email, name and the signup timestamp.
Frequently asked questions
Can I do more than one action?
Absolutely — chain extra nodes after Step 3. A common combo is welcome email + log to a sheet + Slack ping, all from the single Mailchimp trigger.
Will it fire for imported contacts?
Depends on Mailchimp's event. Most fire only on genuine new opt-ins; check the trigger's settings if you bulk-import so you don't email an old list.