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)
- Import the JSON below.
- HTTP Request node → Header Auth credential:
Authorization=Bearer YOUR_APIFY_TOKEN(free Apify account). - Google Sheets node → your sheet URL. Columns are created automatically.
- 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.