n8n: Sync Facebook & Google Lead Ads to Google Sheets & Salesforce

Automatically sync Facebook & Google lead ads into Google Sheets and Salesforce

Stop copying lead details by hand. This production-ready n8n workflow automatically captures new leads from Facebook Lead Ads (and is designed to work with Google Ads Lead Forms), logs them in Google Sheets, and immediately creates a corresponding Lead in Salesforce—so your team can respond faster and keep your CRM clean.

What this workflow does

• Instant trigger on new lead: The workflow starts as soon as a new lead is submitted from your connected Facebook Lead Ad form.
• Smart data preparation: A Set node processes the incoming payload and splits the full_name field into First Name and Last Name, aligning the data with standard CRM fields.
• Reliable Google Sheets backup: Lead details are appended to a new row in a specified Google Sheet, including a `Processing` status for visibility and tracking.
• CRM lead creation in Salesforce: The formatted lead information is used to create a new Lead in Salesforce.
• Status confirmation and sync: 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).

Use cases

• Marketers who want every new Facebook Lead Ad submission logged instantly and routed to Salesforce.
• Agencies managing multiple campaigns and needing an automated backup in Google Sheets for auditability.
• SaaS teams using n8n to reduce manual CRM updates and improve lead response times.

Technical details

• n8n nodes / integrations: Facebook Lead Ads trigger, Set (field mapping), Google Sheets (append row backup), Salesforce (create Lead), plus workflow sequencing.
• CRM-ready structure: The Salesforce step can be swapped for other CRMs with an API (e.g., HubSpot, Pipedrive, Zoho, or a custom CRM).