Collect and deduplicate local business leads from Google Maps with Figranium and Google Sheets
UnknownWhat this workflow does
This workflow has 8 nodes and runs when someone submits an n8n form (“Leads Finder”). Along the way it connects Google Sheets and Figranium (community).
How it runs
Trigger: When someone submits an n8n form (“Leads Finder”).
- Read Leads from Sheets (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Retrieve Google Maps Leads (Figranium): uses Figranium
- Split Business Data (Split Out): splits a list into separate items
- If: checks a condition and branches into true / false
- Append Lead to Sheets (Google Sheets): append
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-figranium is verified or supports 3.0 (used in Retrieve Google Maps Leads).
Nodes used (7)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Figranium
n8n-nodes-figranium.figranium - No Operation, do nothing
n8n-nodes-base.noOp - If
n8n-nodes-base.if - Aggregate
n8n-nodes-base.aggregate
From the author
Quick overview This workflow collects local business leads from Google Maps using Figranium based on a category and location submitted via an n8n form, then deduplicates results against an existing Google Sheets list and appends only new leads to the same…