{"product_id":"capture-score-local-leads-serper-hunter-io-sheets","title":"Capture \u0026 Score Local Leads: Serper + Hunter.io + Sheets","description":"\u003ch3\u003eCapture, enrich, and score local leads automatically with Serper + Hunter.io + Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow finds local businesses in Google Places, extracts contact emails from each website (and enriches via Hunter.io when needed), then scores every lead and appends it to Google Sheets—with an optional HMAC-signed webhook sync back to your CRM.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts manually or via webhook:\u003c\/strong\u003e You can run it on demand, or trigger it with an optional webhook request that passes a \u003cem\u003erun ID\u003c\/em\u003e and a \u003cem\u003emaximum number of leads\u003c\/em\u003e to capture.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Google Places by area using Serper.dev:\u003c\/strong\u003e It builds area-based Google Places queries, calls \u003cstrong\u003eSerper.dev\u003c\/strong\u003e, then filters results using your name rules and \u003cstrong\u003ededuplicates overlapping matches\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoids reprocessing:\u003c\/strong\u003e It caps the leads to your requested maximum and removes businesses whose \u003cstrong\u003ePlace ID already exists\u003c\/strong\u003e in your Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts emails from each business website:\u003c\/strong\u003e For each remaining lead, it fetches the homepage and contact page and extracts a contact email restricted to the business’s own domain.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches with Hunter.io if no email is found:\u003c\/strong\u003e When extraction fails, it uses \u003cstrong\u003eHunter.io domain search\u003c\/strong\u003e to find an email and records contact name and position when available.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores and tiers leads:\u003c\/strong\u003e It scores based on available details (email\/phone\/website\/named contact) and assigns a \u003cstrong\u003eHot\/Warm\/Cold\u003c\/strong\u003e tier.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves to Google Sheets + optional CRM sync:\u003c\/strong\u003e Appends results to Google Sheets and can batch qualified leads to your CRM using an \u003cstrong\u003eHMAC-SHA256\u003c\/strong\u003e signature.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal SEO and outbound teams generating fresh lead lists by city\/region.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators keeping CRM data current without manual research.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a repeatable lead capture pipeline using n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/nodes:\u003c\/strong\u003e Serper.dev, Hunter.io, Webhook, HTTP Request, Code, Crypto (HMAC-SHA256), Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup highlights:\u003c\/strong\u003e Configure Serper credentials as HTTP Header Auth with header name \u003cstrong\u003eX-API-KEY\u003c\/strong\u003e, and Hunter.io as HTTP Query Auth with parameter \u003cstrong\u003eapi_key\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e Lead rows appended to Google Sheets; optional signed webhook batching to your CRM.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46132930904243,"sku":"N8N-20143","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/aViuMwy2mgOUyV-c-E44s_g5jA71mB.png?v=1790760227","url":"https:\/\/buyflowscripts.com\/products\/capture-score-local-leads-serper-hunter-io-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}