Automated Lead Sync from Facebook to Salesforce & Google Sheets

This n8n workflow automates the process of capturing Facebook Lead Ads and seamlessly synchronizing the lead data to Google Sheets and Salesforce CRM. It starts with a Facebook Lead Ad trigger that activates whenever a new lead is generated. The lead details are then logged into a specified Google Sheet, capturing essential information like timestamp, full name, email, and phone number. Meanwhile, the workflow prepares the lead data by splitting the full name into first and last names. It then creates a new lead in Salesforce with complete details, including lead source and company info. After successfully adding the lead to Salesforce, it updates the Google Sheet to mark the lead as ‘Synced to Salesforce’. This automated process is useful for marketing teams and sales departments aiming for real-time lead management, reducing manual entry, and improving workflow efficiency.