Restaurant lead generation from Google Maps with Apify, Airtable & AI newsletter

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

🚀 Automating Google Maps Lead Generation with n8n + Apify

Finding quality leads can be time-consuming. What if you could scrape restaurant data from Google Maps, filter the best ones, and email a Morning Brew–style newsletter automatically?

That’s exactly what this n8n workflow does.

🔎 What This Workflow Does

Takes a location input (Bangkok or Bareilly in this case) Runs a Google Maps scraper via [Apify Actor](https://apify.com/) Extracts restaurant essentials (name, category, rating, reviews, address, phone, Google Maps link) Sorts & filters results (only high-review, highly-rated places) Saves data to Airtable for lead management Uses AI to generate a newsletter in a Morning Brew–style HTML email Emails the newsletter automatically to your chosen recipients

🛠️ Workflow Breakdown

1. Form Trigger User selects location from a dropdown (Bangkok or Bareilly) Submits form to kickstart the process