📊 Review Google Maps business contact evidence with Apify and Google Sheets
⚡ 2 views · 📊 Market Research & Insights
Description
Quick overview
Give a local agency a reviewable list of businesses from a Google Maps search. Keep public phone numbers, website links and source evidence together, with clear reasons for manual review.
How it works
- One bounded Apify run supplies source records, coverage and billing evidence.
- The workflow checks the complete dataset before Google Sheets delivery.
- Stable source keys update existing rows on repeat. Unobserved earlier rows remain, so the Sheet is a current review register, not a complete history.
- COMPLETE describes the declared source window; CAPPED remains a labelled sample.
- Source failures stop delivery. Verified empty results create no data rows.
- Listing contact evidence and website fetch results remain separate. An uncertain or failed website check becomes MANUALLY_VERIFY_WEBSITE, never proof that a business needs a new site. NO_SUPPORTED_WEBSITE_PITCH means the source does not support that offer. Public phone availability does not establish permission to contact someone.
Setup
- Import the workflow into an empty n8n canvas. Use your own Apify account and a Header Auth credential on all five HTTP nodes.
- Connect Google Sheets OAuth2 on Upsert review register.
- Create the supplied tab and import the exact CSV header.
- Enter its spreadsheet ID in Review settings and run manually.
Requirements
- The template is free; Apify usage is paid. The default $1 cap is a maximum, not a quoted price. Repeated results can incur charges again. Only Sheet delivery retries automatically.
Customization
- Change the search, location and country. Up to 20 businesses are supported. The maximum is an upper limit, not a guaranteed result count. Keep settings stable and run sequentially to update the same scope. Setup details.
Additional info
🔗 Nodes Used
Google Sheets, HTTP Request
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File