Sync Facebook/Google Lead Ads to Google Sheets & Salesforce CRM

This n8n workflow eliminates manual data entry by instantly triggering on new leads from Facebook Lead Ads or Google Ads Lead Forms. It processes incoming data by splitting full names into first and last names for CRM compatibility, ensuring seamless integration.

Leads are first appended to a Google Sheet as a reliable backup with a 'Processing' status, providing an organized log. The workflow then creates a new Lead record in Salesforce (easily adaptable to HubSpot, Pipedrive, etc.), capturing all key details for immediate sales follow-up.

Finally, it updates the Google Sheet status to 'Synced' upon successful CRM creation, offering clear visibility into sync progress. Ideal for marketers, sales teams, and agencies in lead generation, this boosts conversion rates, maintains clean databases, and saves hours of manual work.

Use cases include content monetization campaigns in media/entertainment, where ad leads need quick nurturing, or any sales pipeline automation requiring multi-platform lead syncing.