{"product_id":"find-google-maps-leads-create-gmail-drafts-apify-openai-sheets-n8n","title":"Find Google Maps Leads \u0026 Create Gmail Drafts (Apify, OpenAI, Sheets) – n8n","description":"\u003ch3\u003eTurn Google Maps results into ready-to-review Gmail drafts (and a clean lead list) with n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls business leads from \u003cstrong\u003eApify Google Maps\u003c\/strong\u003e, filters and deduplicates them, logs the results into \u003cstrong\u003eSheets\u003c\/strong\u003e, and—when an email address is available—uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate first-email text and create a \u003cstrong\u003eGmail draft\u003c\/strong\u003e for you to review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses your Google Maps search settings\u003c\/strong\u003e (search term, location, and result limit) from the workflow’s settings node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches business details via Apify\u003c\/strong\u003e and normalizes the returned data before applying your rating and website filters.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRemoves repeated businesses within the current batch\u003c\/strong\u003e so your prospect sheet stays clean.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates outreach copy with OpenAI\u003c\/strong\u003e: for each qualifying business, it writes first-email text from the business details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves everything in Google Sheets\u003c\/strong\u003e, including the generated email draft content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Gmail draft only when a usable email exists\u003c\/strong\u003e. If no email is available, the workflow follows a \u003cem\u003eSheets-only\u003c\/em\u003e path to keep records useful for manual follow-up (instead of attempting a draft with an empty recipient).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal agencies building a repeatable \u003cstrong\u003eGoogle Maps lead generation\u003c\/strong\u003e pipeline.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators running small tests (low result limits) before scaling, with drafts reviewed before sending.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing an end-to-end workflow: \u003cstrong\u003eApify → filtering → Sheets logging → OpenAI-assisted email drafts → Gmail drafts\u003c\/strong\u003e.\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 Apify (Google Maps scraper access), OpenAI (API key), Gmail (draft creation), Google Sheets logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow logic:\u003c\/strong\u003e uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003esort\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, and \u003cstrong\u003egmail\u003c\/strong\u003e to route email-available vs. email-missing leads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e you must connect Apify, OpenAI, and Google credentials, and create a prospect sheet with the documented columns.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eNote:\u003c\/strong\u003e The workflow is designed so you can inspect results and review Gmail drafts before sending—schedule is intentionally left off until you confirm the output.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978927759539,"sku":"N8N-19327","price":19.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mUe6oXWozG9L_aofyaCbt_wllOCseZ.png?v=1788859483","url":"https:\/\/buyflowscripts.com\/products\/find-google-maps-leads-create-gmail-drafts-apify-openai-sheets-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}