Templates / Automate lead intake & deduplication with Google Forms, Sheets and GoHighLevel CRM

Automate lead intake & deduplication with Google Forms, Sheets and GoHighLevel CRM

Ready for 3.0

by Rahul Joshi ✓ · 508 views · created 2025-09-08 · Lead Generation

Ready 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.

  1. Lookup Lead (Google Sheets): uses Google Sheets
  2. Check from the data base? (If): checks a condition and branches into true / false
  3. Check the duplication (Filter): keeps only the items that match a condition
  4. Update Contact (GHL) (HTTP Request): calls an HTTP API
  5. Create Contact (GHL) (HTTP Request): calls rest.gohighlevel.com
  6. Field extraction (Code): runs custom JavaScript code
  7. Log New Lead (Google Sheets): append
  8. Log Duplicate Lead (Google Sheets): update

Services it uses

Google Sheets

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)

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…

Excerpt from Rahul Joshi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.