{"product_id":"n8n-workflow-apify-google-maps-leads-to-verified-emails-in-sheets","title":"n8n Workflow: Apify Google Maps Leads to Verified Emails in Sheets","description":"\u003ch3\u003eInstantly build a Google Maps lead list with verified emails—directly in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n automation workflow\u003c\/strong\u003e runs an \u003cstrong\u003eApify Google Maps scraper\u003c\/strong\u003e to find businesses by location and category, keeps only leads with \u003cstrong\u003everified (ACTIVE) emails\u003c\/strong\u003e, and \u003cstrong\u003eappends the cleaned results to a chosen Google Sheets worksheet\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 in n8n:\u003c\/strong\u003e Start the workflow whenever you need a fresh batch of leads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSet lead search criteria:\u003c\/strong\u003e Provide \u003cem\u003esearch location\u003c\/em\u003e, \u003cem\u003ebusiness category (search term)\u003c\/em\u003e, and \u003cem\u003emaximum Google Maps results\u003c\/em\u003e to retrieve.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun Apify’s Google Maps actor via HTTP:\u003c\/strong\u003e The workflow calls the \u003cstrong\u003eApify Business Monster Google Maps Scraper\u003c\/strong\u003e to fetch matching businesses and waits for the dataset to be ready.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcess one lead per business:\u003c\/strong\u003e Splits the dataset into individual items, then filters entries by \u003cstrong\u003eemail verification status\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKeep only ACTIVE emails:\u003c\/strong\u003e Results are filtered to include only businesses whose email verification status is marked \u003cstrong\u003eACTIVE\u003c\/strong\u003e (ensuring verified emails for your outreach list).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlatten and format rows:\u003c\/strong\u003e Each lead is converted into a single row containing key fields (e.g., business name, category, contact details, socials, tracking flags, and the \u003cstrong\u003eGoogle Maps URL\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppend to Google Sheets:\u003c\/strong\u003e The workflow adds the rows to your selected spreadsheet and worksheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS sales \u0026amp; lead generation:\u003c\/strong\u003e Generate verified-email prospect lists for specific niches by city\/region.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLocal agency outreach:\u003c\/strong\u003e Target businesses in defined categories (e.g., “plumbing”, “dentist”) and store results in Sheets for campaigns.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperations teams:\u003c\/strong\u003e Rebuild prospect datasets on demand with consistent formatting and verified emails only.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e Requires an \u003cstrong\u003eApify account\u003c\/strong\u003e and \u003cstrong\u003eAPI token\u003c\/strong\u003e via \u003ccode\u003eAPIFY_TOKEN\u003c\/code\u003e (or update the token placeholder in the HTTP request).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Connect Google Sheets credentials and configure the target document + worksheet for appending.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esplit out\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003ccode\u003ehttp request\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eTip:\u003c\/strong\u003e The workflow’s setup supports disabling the email-status filter if you ever need results without verified emails.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837420200115,"sku":"N8N-18283","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/m-E4dPS9st4mvSXPy4cz9_9EbzRchT.png?v=1786794042","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-apify-google-maps-leads-to-verified-emails-in-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}