Connect Facebook Lead Ads to Google Sheets with Make.com (2026 Step-by-Step)
Small business owners, marketers, and freelancers running Facebook Lead Ad campaigns who want to auto-capture leads into Google Sheets without manual CSV exports or coding skills.
How to set up the Facebook Lead Ads module in Make.com, including page permissions, form selection, and webhook configuration to instantly trigger on new leads
How to map Facebook Lead Ad form fields (name, email, phone, custom questions) to the correct Google Sheets columns using Make.com's data mapping interface
How to test the full scenario end-to-end by submitting a test lead through Facebook's Lead Ads testing tool and confirming the row appears in Google Sheets in real time
How to handle edge cases like duplicate leads, missing field values, and error notifications so the automation stays reliable without manual monitoring
Recommended Make.com plan tier for this use case and how to extend the workflow to also send a welcome email or Slack notification when a new lead is captured
— LINKS —
🔗 n8n (free): https://n8n.io?ref=cogsworth
🔗 Make.com: https://make.com?ref=cogsworth
🔗 Zapier: https://zapier.com?ref=cogsworth