{"product_id":"serper-maps-lead-finder-n8n-to-google-sheets-scoring","title":"Serper Maps Lead Finder: n8n to Google Sheets Scoring","description":"\u003ch3\u003eTurn Serper Maps results into scored local business leads—automatically push to Google Sheets\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eSerper Maps Lead Finder: n8n to Google Sheets Scoring\u003c\/strong\u003e is an on-demand n8n workflow that pulls local business listings from the \u003cstrong\u003eSerper Maps API\u003c\/strong\u003e, filters and \u003cstrong\u003ededuplicates\u003c\/strong\u003e them, computes a \u003cstrong\u003elead score\u003c\/strong\u003e from available signals, and then \u003cstrong\u003eappends qualified leads\u003c\/strong\u003e into the \u003cstrong\u003eLeads\u003c\/strong\u003e tab of \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\u003eManual trigger:\u003c\/strong\u003e Runs when you manually start the workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your search settings:\u003c\/strong\u003e Loads the Serper API key, query, location coordinates, and page\/result limits from configuration steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePaginates and searches:\u003c\/strong\u003e Creates paged Serper Maps searches and calls the \u003cstrong\u003eSerper Maps API\u003c\/strong\u003e for each page.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts and filters listings:\u003c\/strong\u003e Pulls business listings and filters out blocked company types\/domains. Optionally requires a \u003cstrong\u003ewebsite\u003c\/strong\u003e and\/or a \u003cstrong\u003ephone number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates and scores:\u003c\/strong\u003e Removes duplicate results, calculates a \u003cstrong\u003elead score\u003c\/strong\u003e using available listing signals, and keeps only leads that meet your minimum score and maximum result count.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends standardized rows:\u003c\/strong\u003e Writes leads to the \u003cstrong\u003eLeads\u003c\/strong\u003e tab with columns for \u003cstrong\u003ename, phone, website, address, score\u003c\/strong\u003e, and source details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate a targeted list of local service businesses for outreach campaigns.\u003c\/li\u003e\n  \u003cli\u003eContinuously expand a lead database by re-running the workflow with new Serper Maps queries.\u003c\/li\u003e\n  \u003cli\u003ePre-qualify leads by filtering out missing contact info and using scoring thresholds to reduce junk entries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSerper Maps API\u003c\/strong\u003e via \u003cstrong\u003eHTTP Request\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003eWorkflow configuration using \u003cstrong\u003eSet\u003c\/strong\u003e and \u003cstrong\u003eCode\u003c\/strong\u003e nodes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration to append results into the \u003cstrong\u003eLeads\u003c\/strong\u003e tab\u003c\/li\u003e\n  \u003cli\u003eIncludes deduplication, lead scoring, and quality filters before writing to Sheets\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup in minutes\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003ePaste your \u003cstrong\u003eSerper API key\u003c\/strong\u003e in the “Lead Search Configuration” step.\u003c\/li\u003e\n  \u003cli\u003eConnect your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e credential in n8n.\u003c\/li\u003e\n  \u003cli\u003eCreate a sheet tab named \u003cstrong\u003eLeads\u003c\/strong\u003e with the columns used by the append step and set the Google Sheet document ID.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950160896179,"sku":"N8N-19145","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XvuOU7GNYNpsQjfZBFssk_S17g9FPS.png?v=1788513695","url":"https:\/\/buyflowscripts.com\/products\/serper-maps-lead-finder-n8n-to-google-sheets-scoring","provider":"N8N Commerce","version":"1.0","type":"link"}