{"product_id":"apify-google-sheets-find-local-business-email-leads","title":"Apify + Google Sheets: Find Local Business Email Leads","description":"\u003ch3\u003eTurn Google Maps leads into a deduplicated Google Sheets prospect list (Apify + n8n)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow uses \u003cstrong\u003eApify’s Google Places crawler\u003c\/strong\u003e to find local business email leads from Google Maps for a chosen niche and location, then filters out duplicates and appends only new prospects to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e \u003cem\u003eprospects\u003c\/em\u003e tab.\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 Start the workflow whenever you want to run a new lead search.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSet search parameters:\u003c\/strong\u003e Define the target business type (niche), location, and a requested maximum number of results. The workflow also clamps the result count to a safe capped limit.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearch Google Maps via Apify:\u003c\/strong\u003e Calls the \u003cstrong\u003eApify Google Places\u003c\/strong\u003e crawler to return businesses with contact details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRead existing leads from Google Sheets:\u003c\/strong\u003e Fetches existing rows from the \u003cstrong\u003eprospects\u003c\/strong\u003e sheet to build a list of already-saved emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize, filter, and deduplicate:\u003c\/strong\u003e Converts Apify output into a prospect schema, removes entries without a usable contact email, and deduplicates against both:\n    \u003cul\u003e\n      \u003cli\u003eemails already present in the sheet\u003c\/li\u003e\n      \u003cli\u003eemails found within the same batch\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend new prospects:\u003c\/strong\u003e Writes the remaining new prospects to your Google Sheets \u003cstrong\u003eprospects\u003c\/strong\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCold email sourcing for local services:\u003c\/strong\u003e Quickly generate outreach lists for a specific industry in a city\/region.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLead enrichment pipelines:\u003c\/strong\u003e Keep your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e CRM-like table updated without re-adding old contacts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales ops testing:\u003c\/strong\u003e Run repeatable Google Maps lead pulls for different niches and compare growth over time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e set, code, sticky note, HTTP Request, Google Sheets, manual trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Uses an HTTP Request with \u003cstrong\u003eAuthorization: Bearer \u0026lt;token\u0026gt;\u003c\/strong\u003e to call the Apify Google Places crawler\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration:\u003c\/strong\u003e OAuth2-authenticated steps reading and appending to the \u003cem\u003eprospects\u003c\/em\u003e tab\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup required:\u003c\/strong\u003e Create\/copy a sheet with a \u003cstrong\u003eprospects\u003c\/strong\u003e tab and matching columns (e.g., company, email, industry, linkedin_url, notes), and replace \u003cstrong\u003eYOUR_SPREADSHEET_ID\u003c\/strong\u003e in both Google Sheets steps\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45761004011699,"sku":"N8N-17833","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/onnae2uSUux9qCVlFLoL_ZSDBij91.png?v=1785920887","url":"https:\/\/buyflowscripts.com\/products\/apify-google-sheets-find-local-business-email-leads","provider":"N8N Commerce","version":"1.0","type":"link"}