Automate lead intake & deduplication with Google Forms, Sheets and GoHighLevel CRM
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs on Google Sheets events. Along the way it connects Google Sheets. It also calls rest.gohighlevel.com over HTTP.
How it runs
Trigger: On Google Sheets events.
- Lookup Lead (Google Sheets): uses Google Sheets
- Check from the data base? (If): checks a condition and branches into true / false
- Check the duplication (Filter): keeps only the items that match a condition
- Update Contact (GHL) (HTTP Request): calls an HTTP API
- Create Contact (GHL) (HTTP Request): calls rest.gohighlevel.com
- Field extraction (Code): runs custom JavaScript code
- Log New Lead (Google Sheets): append
- Log Duplicate Lead (Google Sheets): update
Services it uses
HTTP calls to: rest.gohighlevel.com
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)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Filter
n8n-nodes-base.filter - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
Description: Eliminate duplicate entries and streamline your lead management process with this n8n workflow template! Automatically capture new form submissions, check against existing records, update duplicates, and sync leads seamlessly into GoHighLevel…