Deduplicate lead data with Google Sheets: automated email alerts & log management
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 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
- 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: Keep your databases clean and reliable with this intelligent n8n workflow template! Effortlessly detect duplicate records, generate structured logs, and receive instant email updates—no manual review needed. This automation retrieves records from…