{"product_id":"qualify-google-maps-leads-in-n8n-scrapehero-openai-sheets","title":"Qualify Google Maps Leads in n8n: ScrapeHero + OpenAI + Sheets","description":"\u003ch3\u003eTurn Google Maps searches into qualified leads—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scrapes Google Maps business listings with \u003cstrong\u003eScrapeHero\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate lead-qualification scores from each listing, and appends the enriched results into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—one qualified business per row.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on demand\u003c\/strong\u003e: start the workflow manually in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapes Google Maps listings via ScrapeHero\u003c\/strong\u003e: sends your configured Google Maps search query to ScrapeHero.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePaginates through results\u003c\/strong\u003e: repeatedly follows the returned \u003cem\u003enext-page URL\u003c\/em\u003e until pagination ends or your configured \u003cstrong\u003emax page limit\u003c\/strong\u003e is reached.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and deduplicates\u003c\/strong\u003e: combines results from all pages, splits them into individual businesses, normalizes key Google Maps fields, and removes duplicate listings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies each lead with OpenAI\u003c\/strong\u003e: for every unique listing, sends the listing details plus your \u003cstrong\u003etargetService\u003c\/strong\u003e description to OpenAI (Chat Model: \u003cstrong\u003egpt4o-mini\u003c\/strong\u003e by default or another model you have access to).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens structured output\u003c\/strong\u003e: merges original Google Maps data with the AI response and parses it into a single flattened record (including a structured lead-qualification result such as score, quality\/fit, and recommended action).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets\u003c\/strong\u003e: writes one enriched business lead per row to your specified worksheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate a \u003cstrong\u003equalified Google Maps lead list\u003c\/strong\u003e for local services (e.g., agencies, contractors, vendors) without manual research.\u003c\/li\u003e\n  \u003cli\u003eFeed sales or outreach tools indirectly by maintaining a continuously updated \u003cstrong\u003eGoogle Sheets pipeline\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eTest and iterate lead-fit criteria using different \u003cstrong\u003etargetService\u003c\/strong\u003e descriptions and AI scoring prompts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapeHero\u003c\/strong\u003e: Google Maps Search API with pagination support.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: Chat Model (default \u003cstrong\u003egpt4o-mini\u003c\/strong\u003e) to produce structured lead qualification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends enriched rows to your spreadsheet using provided document URL\/ID and sheet tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e referenced in the workflow: \u003cem\u003eif, code, merge, split out\u003c\/em\u003e plus supporting nodes like \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup requirements\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eScrapeHero\u003c\/strong\u003e credentials and ensure the Google Maps Search API is enabled.\u003c\/li\u003e\n  \u003cli\u003eAdd an \u003cstrong\u003eOpenAI\u003c\/strong\u003e credential for the Chat Model (or change the model).\u003c\/li\u003e\n  \u003cli\u003eAdd \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e credentials and set spreadsheet\/worksheet details.\u003c\/li\u003e\n  \u003cli\u003eUpdate \u003cstrong\u003esearch-config\u003c\/strong\u003e values: Google Maps search text, \u003cstrong\u003etargetService\u003c\/strong\u003e, and \u003cstrong\u003emaxPages\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978916716723,"sku":"N8N-19359","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/HGdncfwVy_CcRfzqJI7Ql_jskm5j4a.png?v=1788858637","url":"https:\/\/buyflowscripts.com\/products\/qualify-google-maps-leads-in-n8n-scrapehero-openai-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}