An n8n workflow automation that syncs new and updated Airtable leads to Mailchimp, respecting marketing opt-in preferences via IF-based consent validation. Opted-in contacts are added or updated as Mailchimp subscribers with mapped custom fields, and the marketing team receives a Slack notification. All sync operations — both successful and skipped — are logged to Google Sheets.

完整 FlowZap 代码

source { # Source
n1: rectangle label:"Airtable - New/Updated Lead" system:"Airtable"
n2: rectangle label:"Code - Map fields + opt-in logic" system:"n8n"
n1.handle(right) -> n2.handle(left) [label="Lead record"]
}

decision { # Decision
n3: diamond label:"IF: Marketing opt-in = true?" system:"n8n"
source.n2.handle(right) -> decision.n3.handle(left) [label="Eligibility"]
}

sync { # Sync
n4: rectangle label:"Mailchimp - Add/Update Subscriber" system:"Mailchimp"
n5: rectangle label:"Slack - Notify #marketing" system:"Slack"
decision.n3.handle(right) -> sync.n4.handle(left) [label="Yes"]
sync.n4.handle(right) -> sync.n5.handle(left) [label="Synced"]
}

audit { # Audit
n6: rectangle label:"Google Sheets - Append Row (Sync log)" system:"Google Sheets"
sync.n4.handle(bottom) -> audit.n6.handle(top) [label="Log success"]
decision.n3.handle(bottom) -> audit.n6.handle(top) [label="No → Log skip"]
}

相关模板