n8n Workflow: Log Facebook Lead Ads to Google Sheets + Slack Alerts

Instantly log every Facebook & Instagram lead to Google Sheets—then alert Slack for fresh leads

This n8n workflow captures Meta (Facebook/Instagram) Lead Ads form submissions the moment they arrive, cleans up key fields (name, email, phone), writes them to your Google Sheet, and sends a Slack notification for each genuinely new lead—so your team can respond while the lead is still warm.

What this workflow does

• Triggers on Meta Lead Ads submissions: The Facebook Lead Ads trigger fires when someone submits your form.
• Normalizes lead details: The workflow reads the answers (whether Simplify Output is on or off), joins first and last names into full_name, lowercases the email, and converts the phone into international format for consistent dialing and matching.
• Marks testing leads: Leads coming from Meta’s Lead Ads Testing Tool are marked test and won’t trigger Slack alerts.
• Prevents duplicates: A lead lead_id already logged is treated as a webhook redelivery and is dropped. If the same email or phone appears within your comparison window, the lead is marked repeat.
• Appends to Google Sheets: One row per lead is added, including received timestamps, status, ad/form info, answers, and previous_lead_at.
• Alerts via Slack: Slack gets an alert for each new lead, with the phone number near the top.

Use cases

• Speed up lead response for SaaS demo requests generated by Facebook Lead Ads.
• Catch duplicate submissions by email/phone and keep your pipeline clean.
• Use Meta’s Lead Ads Testing Tool without spamming sales channels (no Slack pings for test leads).

Technical details

• n8n trigger: Facebook Lead Ads trigger
• Workflow logic: if, set, code (for formatting, joining names, phone formatting, dedupe decisions)
• Outputs: Google Sheets (append rows to a Leads tab) and Slack (per-new-lead alerts)
• Optional reference: Sticky note used for setup clarity

Setup tip: Ensure your Google Sheet has a Leads tab with headers: received_at, created_time, status, full_name, email, phone, form, ad, answers, lead_id, previous_lead_at.