Log Meta lead ads to Google Sheets with Slack alerts and repeat checks

## Log Meta lead ads to Google Sheets with Slack alerts and duplicate checks ### Who's it for Small businesses running Facebook or Instagram lead form ads who still download leads as a CSV, or check Ads Manager hours after someone filled the form in. A lead you ring in five minutes is a different lead from one you ring tomorrow. ### How it works 1. Facebook Lead Ads Trigger fires the moment someone submits your form. 2. Normalise Lead Fields reads the answers with Simplify Output on or off, joins first and last names, lowercases the email and puts phone numbers into international format so they dial from a mobile and match later. 3. It also spots leads from Meta's Lead Ads Testing Tool. Your tests land in the sheet marked test and never page anyone. 4. Check For Repeats compares each lead with your sheet. A lead id already logged is a webhook redelivery, so I drop it. The same email or phone inside your window is marked repeat. 5. Log The Lead appends one row per lead, and Slack gets an alert for each new one with the phone number near the top. ### How to set up 1. Connect your Facebook Lead Ads, Google Sheets and Slack credentials, then pick your page and form in the trigger. 2. Make a Google Sheet with a Leads tab and these headers in row 1: received_at, created_time, status, full_name, email, phone, form, ad, answers, lead_id, previous_lead_at. 3. Paste the sheet URL and your Slack channel into Settings. If you are outside the UK, change defaultCountryCode (it is 44 now). 4. Send one lead from Meta's Lead Ads Testing Tool and check it arrives as test with no Slack message. ### Requirements A Facebook page with a lead form, a Google account and a Slack workspace. ### How to customize - Set alertOnRepeats to true if a returning lead matters as much as a new one in your business. - Swap the Slack node for Telegram or Gmail if your team lives there. - If you want each lead scored by AI and the hot ones sent to HubSpot and WhatsApp, that is my paid template: https://n8n.io/workflows/19169 --- Built by Fractional HQ · https://fractionalhq.uk Want this adapted to your forms, or the whole lead flow built and handed over working? https://fractionalhq.uk/brief