AK
← All projects

AI Automation

Google Maps Lead Finder with AI Email Drafts

Scrapes restaurants in Praia, Cape Verde from Google Maps, keeps only the ones that have an email but no website, and lets AI write a personalised pitch for a website-building service.

n8nApifyGoogle MapsOpenAIJavaScriptGoogle Sheets
n8n workflow — Apify Google Maps actor, Clean & Filter Leads code node, OpenAI message, format output, append to Google Sheets

How it flows

  1. 1Apify scrapes restaurants in Praia from Google Maps
  2. 2Code node keeps only "has email, no website" businesses
  3. 3OpenAI drafts a custom email offering a website
  4. 4Format the final columns
  5. 5Append everything to Google Sheets

The idea

If a restaurant is on Google Maps with an email address but no website, it is a natural prospect for a web-design service. This workflow finds those businesses and writes the first email for you.

Steps

  1. Run an Actor and get dataset — the Apify Google Maps scraper collects restaurants in Praia, the capital of Cape Verde — name, address, phone, email, website, rating, and category. About 100 places came back.
  2. Clean & Filter Leads — a JavaScript Code node keeps only rows where an email exists and the website field is empty or points to a social-media page instead of a dedicated site. Six restaurants remained.
  3. Message a model — OpenAI receives each restaurant’s details and writes a short, friendly email offering a website-building service, referring to the restaurant by name.
  4. Format Final Output — a Code node arranges the business details and the email draft into clean columns.
  5. Append row in sheet — the six prospects, with their drafts, are saved to Google Sheets.

Result

A short, targeted list where every row is a business that can be contacted and has a real reason to say yes — produced in one click instead of an afternoon of searching.

More AI Automation projects