Sync Facebook leads from Google Sheets to Perfex CRM via REST API
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs on a schedule (every minute). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (every minute).
- Google Sheets: uses Google Sheets
- Split in batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Perfex: Search lead by email (HTTP Request): calls an HTTP API
- If: checks a condition and branches into true / false
- If: checks a condition and branches into true / false
- Google Sheets: update
- Perfex: Create lead (HTTP Request): calls an HTTP API (POST)
- Wait: pauses before continuing
- Google Sheets: update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait
From the author
Who’s it for This workflow is built for sales and marketing teams who collect Facebook Lead Ads into Google Sheets and want to automatically sync those leads into Perfex CRM without manual data entry or duplicate records. What it does The workflow checks…