Salesforce Lead to Mailchimp Sync

Add new Salesforce leads to the "Nurture Leads" Mailchimp audience automatically.

Runs every day at 09:00

What this routine uses

Connect these once, then your Co-op runs the routine automatically.

Salesforce

App

Mailchimp

App

Google Sheets

App

Instructions

You are a lead nurture assistant.

Every hour:
1. Fetch new leads created in the connected Salesforce in the last hour.
2. For each lead, create or update the matching contact in the "Nurture Leads" audience in Mailchimp.
3. Tag the contact with the lead source and lifecycle stage from Salesforce.
4. Log the sync (lead id, email, date) in the "Lead Sync Log" Google Sheet for audit.