What This Workflow Does
This automation solves the common problem of Facebook leads getting stuck in spreadsheets or requiring manual transfer to your CRM. Marketing teams running Facebook Lead Ads often collect responses in Google Sheets, but sales teams need that data in Perfex CRM to properly track and follow up.
The workflow automatically detects new Facebook lead entries in your Google Sheet, formats the data for Perfex CRM's API requirements, and creates complete contact records with all lead details. It maintains data integrity by handling field mappings, error cases, and duplicate prevention.
How It Works
1. Monitoring Google Sheets for New Leads
The workflow checks your specified Google Sheet at regular intervals (typically every 15-60 minutes) for new rows added since the last sync. It identifies new leads by timestamp or a dedicated "Synced" status column.
2. Formatting Lead Data for Perfex CRM
Facebook lead data gets transformed to match Perfex CRM's contact field structure. The workflow handles common challenges like splitting full names, standardizing phone formats, and mapping custom form questions to CRM fields.
3. Creating CRM Records via API
Using Perfex CRM's REST API, the workflow creates new contact records with all lead details. It can optionally assign leads to specific sales reps or teams based on your business rules.
Pro tip: Add a workflow step to send Slack notifications when high-value leads come in, so your sales team can respond immediately.
Who This Is For
This automation is ideal for:
- Marketing agencies managing Facebook ads for clients using Perfex CRM
- B2B companies running lead generation campaigns on Facebook
- Sales teams who need real-time access to new leads in their CRM
- Businesses that want to maintain a backup of all leads in Google Sheets
What You'll Need
- A Google Sheet containing Facebook Lead Ads data
- Perfex CRM installed with API access enabled
- n8n instance (cloud or self-hosted)
- Facebook Lead Ads connected to Google Sheets (via Zapier or native integration)
Quick Setup Guide
- Download the template JSON file
- Import into your n8n instance
- Connect your Google Sheets and Perfex CRM accounts
- Map your Facebook lead fields to Perfex CRM fields
- Set your preferred sync frequency
- Test with sample data
- Activate the workflow
Key Benefits
Eliminate manual data entry: Save 5-10 hours per week by automating lead transfers between systems.
Improve lead response times: Sales teams get new leads in their CRM immediately rather than waiting for manual imports.
Reduce human error: Automated field mapping ensures data consistency compared to manual copying.
Maintain data backup: All leads remain in Google Sheets even after CRM import for auditing.
Customizable workflow: Easily add steps for lead scoring, notifications, or data enrichment.