Workflow templatePush HubSpot contacts to Mailchimp and log both
Adds or updates each recently changed HubSpot contact in your Mailchimp audience, never re-subscribing anyone who left, and keeps a sheet of lifecycle stage and subscription status side by side.
Workflow illustration
01Trigger
TriggerEvery day at 06:00 AM UTC.
02Hu
HubSpotList HubSpot contacts updated in the last day with email and lifecycle stage.
03Ma
MailchimpSkip anyone the Mailchimp audience id you choose in setup lists as unsubscribed or cleaned.
04Ma
MailchimpAdd or update the rest there by email, tagged with their lifecycle stage, adding new people as pending so Mailchimp asks them to confirm.
05Ma
MailchimpWrite email, stage and Mailchimp status to the Google Sheets spreadsheet id and tab name you choose in setup, updating rows already there.
06
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every day at 06:00 AM UTC.
Then
- List HubSpot contacts updated in the last day with email and lifecycle stage.
- Skip anyone the Mailchimp audience id you choose in setup lists as unsubscribed or cleaned.
- Add or update the rest there by email, tagged with their lifecycle stage, adding new people as pending so Mailchimp asks them to confirm.
- Write email, stage and Mailchimp status to the Google Sheets spreadsheet id and tab name you choose in setup, updating rows already there.