{"product_id":"n8n-workflow-google-maps-leads-scrape-dedup-in-sheets","title":"n8n Workflow: Google Maps Leads Scrape + Dedup in Sheets","description":"\u003ch3\u003eScrape Google Maps leads with n8n—and automatically deduplicate them in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes a category and location from an n8n form, scrapes matching local business results from Google Maps using \u003cstrong\u003eFigranium\u003c\/strong\u003e, and then \u003cstrong\u003ededuplicates\u003c\/strong\u003e by business name before appending only new leads to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives your search input\u003c\/strong\u003e via an n8n form submission (business \u003cem\u003ecategory\u003c\/em\u003e and \u003cem\u003elocation\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads existing leads\u003c\/strong\u003e from a Google Sheets worksheet and aggregates them into a single list for comparison.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes Google Maps with Figranium\u003c\/strong\u003e using the submitted category and location to fetch matching business results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits results into individual lead items\u003c\/strong\u003e and captures fields such as \u003cem\u003ename, rating, address, phone, and website\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates\u003c\/strong\u003e each scraped lead against the cached Google Sheets list (checks by \u003cstrong\u003ebusiness name\u003c\/strong\u003e) and filters out leads already present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends new leads\u003c\/strong\u003e to the same Google Sheets spreadsheet and ignores duplicates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate fresh lead lists for local SEO, sales prospecting, or partner outreach by running repeatable Google Maps searches.\u003c\/li\u003e\n  \u003cli\u003eMaintain a single “source of truth” Google Sheets database without manual cleanup using automated deduping.\u003c\/li\u003e\n  \u003cli\u003eBuild an internal lead pipeline where SaaS operators trigger Google Maps scraping from an n8n form and keep results organized.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eFigranium\u003c\/strong\u003e (Google Maps scraping) + \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (read\/write).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e if, no op, split out, aggregate, sticky note, form trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplication logic:\u003c\/strong\u003e compares scraped leads to existing sheet entries by \u003cstrong\u003ebusiness name\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e a running Figranium instance, an imported Google Maps scraping preset\/task, and a configured n8n Figranium credential (instance URL + API key).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets setup:\u003c\/strong\u003e ensure your worksheet has columns for \u003cem\u003eName, Rating, Address, Phone, Website\u003c\/em\u003e so appends map correctly.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916248473779,"sku":"N8N-18789","price":34.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QkLlyjCmdgDkAlNO6edCT_5cbOmXjY.png?v=1788013718","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-maps-leads-scrape-dedup-in-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}