{"product_id":"n8n-workflow-log-facebook-lead-ads-to-google-sheets-slack-alerts","title":"n8n Workflow: Log Facebook Lead Ads to Google Sheets + Slack Alerts","description":"\u003ch3\u003eInstantly log every Facebook \u0026amp; Instagram lead to Google Sheets—then alert Slack for fresh leads\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on Meta Lead Ads submissions:\u003c\/strong\u003e The Facebook Lead Ads trigger fires when someone submits your form.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes lead details:\u003c\/strong\u003e The workflow reads the answers (whether Simplify Output is on or off), joins first and last names into \u003cem\u003efull_name\u003c\/em\u003e, lowercases the email, and converts the phone into \u003cem\u003einternational format\u003c\/em\u003e for consistent dialing and matching.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMarks testing leads:\u003c\/strong\u003e Leads coming from Meta’s Lead Ads Testing Tool are marked \u003ccode\u003etest\u003c\/code\u003e and won’t trigger Slack alerts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicates:\u003c\/strong\u003e A lead \u003ccode\u003elead_id\u003c\/code\u003e already logged is treated as a webhook redelivery and is dropped. If the same \u003cem\u003eemail\u003c\/em\u003e or \u003cem\u003ephone\u003c\/em\u003e appears within your comparison window, the lead is marked \u003ccode\u003erepeat\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e One row per lead is added, including received timestamps, status, ad\/form info, answers, and \u003ccode\u003eprevious_lead_at\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts via Slack:\u003c\/strong\u003e Slack gets an alert for each \u003cem\u003enew\u003c\/em\u003e lead, with the phone number near the top.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSpeed up lead response for SaaS demo requests generated by Facebook Lead Ads.\u003c\/li\u003e\n  \u003cli\u003eCatch duplicate submissions by email\/phone and keep your pipeline clean.\u003c\/li\u003e\n  \u003cli\u003eUse Meta’s Lead Ads Testing Tool without spamming sales channels (no Slack pings for \u003ccode\u003etest\u003c\/code\u003e leads).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n trigger:\u003c\/strong\u003e Facebook Lead Ads trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e (for formatting, joining names, phone formatting, dedupe decisions)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutputs:\u003c\/strong\u003e Google Sheets (append rows to a \u003ccode\u003eLeads\u003c\/code\u003e tab) and Slack (per-new-lead alerts)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional reference:\u003c\/strong\u003e Sticky note used for setup clarity\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cem\u003eSetup tip:\u003c\/em\u003e Ensure your Google Sheet has a \u003ccode\u003eLeads\u003c\/code\u003e tab with headers: received_at, created_time, status, full_name, email, phone, form, ad, answers, lead_id, previous_lead_at.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248932081843,"sku":"N8N-21185","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RSxQN3RxuR46XG0E6T9B0_tAMkqcH7.png?v=1792487639","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-log-facebook-lead-ads-to-google-sheets-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}