{"product_id":"n8n-workflow-apify-google-maps-leads-to-airtable-gmail","title":"n8n Workflow: Apify Google Maps Leads to Airtable + Gmail","description":"\u003ch3\u003eTurn Google Maps leads into Airtable records and AI-personalized Gmail outreach\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls business leads from Google Maps via \u003cstrong\u003eApify\u003c\/strong\u003e, enriches and stores them in \u003cstrong\u003eAirtable\u003c\/strong\u003e, optionally scrapes missing website content with \u003cstrong\u003eFirecrawl\u003c\/strong\u003e, and sends \u003cstrong\u003epersonalized cold emails\u003c\/strong\u003e through \u003cstrong\u003eGmail\u003c\/strong\u003e using an \u003cstrong\u003eOpenRouter\u003c\/strong\u003e chat model.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrape Google Maps leads with Apify:\u003c\/strong\u003e When triggered by another workflow, it starts an Apify Google Maps Scraper actor to collect businesses by the specified location and categories (including contact enrichment).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize and upsert into Airtable:\u003c\/strong\u003e After scraping finishes, it normalizes key lead fields and upserts businesses into Airtable using \u003cstrong\u003eGoogle Place ID\u003c\/strong\u003e as the match key.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStore individual contact records:\u003c\/strong\u003e It splits Apify enrichment results into contacts and upserts each contact into Airtable matched by \u003cstrong\u003ePersonID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional website enrichment with Firecrawl:\u003c\/strong\u003e For each saved business, it checks whether a website exists and whether scraped content is missing, then scrapes the site and updates Airtable with \u003cstrong\u003emarkdown content\u003c\/strong\u003e and metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate and send outreach emails:\u003c\/strong\u003e On a \u003cstrong\u003eweekday 9AM\u003c\/strong\u003e schedule, it fetches unsent contact records from Airtable, merges business + contact details using Place ID, generates an AI-personalized cold email with an \u003cstrong\u003eOpenRouter\u003c\/strong\u003e model, converts it to \u003cstrong\u003eHTML\u003c\/strong\u003e, sends via \u003cstrong\u003eGmail\u003c\/strong\u003e with a \u003cstrong\u003e90-second throttle\u003c\/strong\u003e, and marks the Airtable contact as “sent.”\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLead generation for local services (collect businesses from specific cities and categories).\u003c\/li\u003e\n  \u003cli\u003eSaaS or agencies running repeatable outreach campaigns with enriched Google Maps data.\u003c\/li\u003e\n  \u003cli\u003eTeams building an “enrich → store → personalize → email” pipeline in n8n.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/credentials: \u003cstrong\u003eApify\u003c\/strong\u003e, \u003cstrong\u003eAirtable\u003c\/strong\u003e (Personal Access Token), \u003cstrong\u003eFirecrawl\u003c\/strong\u003e, \u003cstrong\u003eOpenRouter\u003c\/strong\u003e, \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWorkflow nodes\/actions: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003elimit\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, plus the Apify\/Airtable\/Firecrawl\/OpenRouter steps described above.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45764326457523,"sku":"N8N-17850","price":24.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RQd11UqM4KFk_zq7ebHXF_V4czEaJ0.png?v=1786007424","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-apify-google-maps-leads-to-airtable-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}