{"product_id":"n8n-sync-facebook-google-lead-ads-to-google-sheets-salesforce","title":"n8n: Sync Facebook \u0026 Google Lead Ads to Google Sheets \u0026 Salesforce","description":"\u003ch3\u003eAutomatically sync Facebook \u0026amp; Google lead ads into Google Sheets and Salesforce\u003c\/h3\u003e\n\u003cp\u003eStop copying lead details by hand. This production-ready n8n workflow automatically captures new leads from \u003cstrong\u003eFacebook Lead Ads\u003c\/strong\u003e (and is designed to work with \u003cstrong\u003eGoogle Ads Lead Forms\u003c\/strong\u003e), logs them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and immediately creates a corresponding \u003cstrong\u003eLead\u003c\/strong\u003e in \u003cstrong\u003eSalesforce\u003c\/strong\u003e—so your team can respond faster and keep your CRM clean.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInstant trigger on new lead\u003c\/strong\u003e: The workflow starts as soon as a new lead is submitted from your connected Facebook Lead Ad form.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSmart data preparation\u003c\/strong\u003e: A \u003cstrong\u003eSet\u003c\/strong\u003e node processes the incoming payload and splits the \u003cstrong\u003efull_name\u003c\/strong\u003e field into \u003cstrong\u003eFirst Name\u003c\/strong\u003e and \u003cstrong\u003eLast Name\u003c\/strong\u003e, aligning the data with standard CRM fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReliable Google Sheets backup\u003c\/strong\u003e: Lead details are appended to a new row in a specified Google Sheet, including a `Processing` status for visibility and tracking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCRM lead creation in Salesforce\u003c\/strong\u003e: The formatted lead information is used to create a new \u003cstrong\u003eLead\u003c\/strong\u003e in \u003cstrong\u003eSalesforce\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStatus confirmation and sync\u003c\/strong\u003e: Once the lead is successfully created in the CRM, the workflow returns to the Google Sheet to update the lead’s status (completing the end-to-end flow).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMarketers who want every new Facebook Lead Ad submission logged instantly and routed to Salesforce.\u003c\/li\u003e\n  \u003cli\u003eAgencies managing multiple campaigns and needing an automated backup in Google Sheets for auditability.\u003c\/li\u003e\n  \u003cli\u003eSaaS teams using n8n to reduce manual CRM updates and improve lead response times.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes \/ integrations\u003c\/strong\u003e: \u003cstrong\u003eFacebook Lead Ads trigger\u003c\/strong\u003e, \u003cstrong\u003eSet\u003c\/strong\u003e (field mapping), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (append row backup), \u003cstrong\u003eSalesforce\u003c\/strong\u003e (create Lead), plus workflow sequencing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCRM-ready structure\u003c\/strong\u003e: The Salesforce step can be swapped for other CRMs with an API (e.g., HubSpot, Pipedrive, Zoho, or a custom CRM).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764401397939,"sku":"N8N-6687","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mA3mbSMjmJINzQnT9mFg__UU09nBeA.png?v=1786008494","url":"https:\/\/buyflowscripts.com\/products\/n8n-sync-facebook-google-lead-ads-to-google-sheets-salesforce","provider":"N8N Commerce","version":"1.0","type":"link"}