[Free template] New local businesses from Google Maps → Google Sheets every week (lead gen)

Agencies, web designers and local SEO folks all chase the same leads: businesses that just opened. They have no website yet, no reviews, and nobody has pitched them.

This 3-node workflow finds them every Monday and appends them to a Google Sheet:

Schedule (Monday 8:00) → HTTP Request (Apify Actor) → Google Sheets (append, auto-map columns)

What lands in the sheet: business name, category, address, phone, website, rating, review count, Google Maps URL. Only businesses that were not there last week (the first run stores a baseline).

Setup (3 min)

  1. Import the JSON below.
  2. HTTP Request node → Header Auth credential: Authorization = Bearer YOUR_APIFY_TOKEN (free Apify account).
  3. Google Sheets node → your sheet URL. Columns are created automatically.
  4. Change the searches in the JSON body, e.g. "dentists in Miami, FL", "restaurants in Lyon".

Cost / disclosure: I built the Apify Actor it calls (New Business Leads). It’s pay per result ($0.01 per new business), and maxTotalChargeUsd in the body is a hard cap per run. No token is stored in the file.

The other templates (YouTube transcripts → Sheets, new ATS jobs → Slack, Kalshi/Polymarket odds → Slack, Google Trends → Sheets) are here: Free n8n workflow templates for Apify Actors (Google Sheets, Slack) | om_kh Apify Actor Catalogue

Happy to adapt it (Airtable, HubSpot, a Slack alert instead of Sheets) if anyone needs it.