n8n Workflow: Apify Google Maps Leads to Airtable + Gmail

Turn Google Maps leads into Airtable records and AI-personalized Gmail outreach

This n8n workflow pulls business leads from Google Maps via Apify, enriches and stores them in Airtable, optionally scrapes missing website content with Firecrawl, and sends personalized cold emails through Gmail using an OpenRouter chat model.

What this workflow does

• Scrape Google Maps leads with Apify: 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).
• Normalize and upsert into Airtable: After scraping finishes, it normalizes key lead fields and upserts businesses into Airtable using Google Place ID as the match key.
• Store individual contact records: It splits Apify enrichment results into contacts and upserts each contact into Airtable matched by PersonID.
• Optional website enrichment with Firecrawl: For each saved business, it checks whether a website exists and whether scraped content is missing, then scrapes the site and updates Airtable with markdown content and metadata.
• Generate and send outreach emails: On a weekday 9AM schedule, it fetches unsent contact records from Airtable, merges business + contact details using Place ID, generates an AI-personalized cold email with an OpenRouter model, converts it to HTML, sends via Gmail with a 90-second throttle, and marks the Airtable contact as “sent.”

Use cases

• Lead generation for local services (collect businesses from specific cities and categories).
• SaaS or agencies running repeatable outreach campaigns with enriched Google Maps data.
• Teams building an “enrich → store → personalize → email” pipeline in n8n.

Technical details

• Integrations/credentials: Apify, Airtable (Personal Access Token), Firecrawl, OpenRouter, Gmail OAuth2.
• Workflow nodes/actions: if, set, wait, gmail, limit, merge, plus the Apify/Airtable/Firecrawl/OpenRouter steps described above.