Google Maps No-Website Lead List Automation with Apify + Sheets

Automate Google Maps lead sourcing for businesses with no website—weekly, sorted, and delivered to Google Sheets

This n8n workflow automatically finds Google Maps places in your chosen categories and location, filters out any listings that already have a website, and appends the best prospects to Google Sheets every Monday morning—prioritized by review count.

What this workflow does

• Runs on a schedule: set to execute every Monday morning.
• Searches Google Maps using your inputs: you define the search terms (categories), the location (area), and a maximum results-per-term (with a minimum of 20).
• Fetches places from Apify: it uses Apify’s Google Maps Places API actor (the workflow is configured to run the johnvc~google-maps-places-api actor).
• Filters to “no-website” leads: it keeps only businesses where the Google Maps listing has an empty website field.
• Formats clean call-sheet rows: it outputs key lead fields such as rating, review count, address, phone/no-phone flag, and a Google Maps place link.
• Ranks and prioritizes: it sorts leads by review count (descending) so the most established prospects appear first.
• Appends to Google Sheets: it writes the sorted leads into your selected spreadsheet and sheet as a call sheet.

Use cases

• Local service outbound: generate leads for plumbers, contractors, clinics, or other categories in a specific city/area.
• Automation engineers: build repeatable lead pipelines using n8n + Apify + Google Sheets.
• SaaS operators: maintain weekly prospect lists without manual scraping or spreadsheet cleanup.

Technical details

• Integrations: Apify (Google Maps Places API actor), Google Sheets.
• Setup required: add your Apify API token in n8n and connect Google Sheets credentials for the append step.
• Workflow nodes: set, code, sort, filter, sticky note, and Slack (for operational visibility).