Airtable → Mailchimp sync with opt-in logic (Airtable → IF → Mailchimp)
Quick summary
Trigger
Airtable - New/Updated Lead
Steps
6
Step outline
Airtable - New/Updated Lead → Code - Map fields + opt-in logic → IF: Marketing opt-in = true? → Mailchimp - Add/Update Subscriber → Slack - Notify #marketing
Lanes
4
Integrations
Airtable, Google Sheets, Mailchimp, n8n, Slack
FlowZap Code
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"]
}