{"product_id":"serper-maps-lead-scoring-dedup-to-google-sheets-n8n","title":"Serper Maps Lead Scoring \u0026 Dedup to Google Sheets (n8n)","description":"\u003ch3\u003eFind Better Local Leads From Serper Maps—Score, Deduplicate, and Save to Google Sheets (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs a \u003cstrong\u003eSerper Maps\u003c\/strong\u003e search for local businesses, \u003cstrong\u003ededuplicates and qualifies\u003c\/strong\u003e the results, then \u003cstrong\u003ecalculates a lead score\u003c\/strong\u003e and appends only the best-fit leads to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Leads” tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned for B2B lead research and qualification, the workflow:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e when you start it in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSets Serper Maps search inputs\u003c\/strong\u003e including your API key, query, map coordinates (ll), page, and result limits—along with qualification rules.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a list of page requests\u003c\/strong\u003e and calls the Serper Maps API for each page of results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeduplicates businesses\u003c\/strong\u003e and filters out listings that don’t meet requirements (for example, \u003cstrong\u003emissing a website\u003c\/strong\u003e) or match \u003cstrong\u003eblocked company terms\/domains\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a lead score\u003c\/strong\u003e for each remaining business, keeps leads above your \u003cstrong\u003eminimum score\u003c\/strong\u003e, and caps results to your \u003cstrong\u003emaximum result count\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends qualified lead records\u003c\/strong\u003e to the Google Sheets \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab, including: \u003cstrong\u003ename, phone, website, address, score\u003c\/strong\u003e, and \u003cstrong\u003esource metadata\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate a targeted prospect list for \u003cstrong\u003elocal B2B outreach\u003c\/strong\u003e by industry keywords and location coordinates.\u003c\/li\u003e\n  \u003cli\u003eContinuously build a qualified lead pipeline in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e without manual cleanup.\u003c\/li\u003e\n  \u003cli\u003eReduce duplicate entries and exclude unwanted vendors using \u003cstrong\u003eblocked domains\/terms\u003c\/strong\u003e and qualification rules.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n nodes: \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eSticky Note\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eSerper Maps API\u003c\/strong\u003e and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (append into a tab named “Leads”).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAdd your \u003cstrong\u003eSerper API key\u003c\/strong\u003e to the Lead Search Configuration values (or use an n8n credential\/variable).\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e in n8n and create a tab named \u003cstrong\u003e“Leads”\u003c\/strong\u003e with matching columns.\u003c\/li\u003e\n  \u003cli\u003eUpdate the Google Sheets document ID and tune query, coordinates (ll), paging\/max caps, and scoring thresholds.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950167056563,"sku":"N8N-19144","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0SPstf8Mtnq0oMxsWf3ot_azFZ8IHT.png?v=1788513723","url":"https:\/\/buyflowscripts.com\/products\/serper-maps-lead-scoring-dedup-to-google-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}