Monitor Google Maps, Yelp and Tripadvisor reviews with Apify and Google Sheets
UnknownWhat this workflow does
This workflow has 9 nodes and runs on a schedule (every 4 days at 07:00). Along the way it connects Google Sheets, Gmail and Apify (community).
How it runs
Trigger: On a schedule (every 4 days at 07:00).
- Fetch Google Maps Reviews (Apify): run actor and get dataset
- Fetch Yelp Reviews (Apify): run actor and get dataset
- Fetch Tripadvisor Reviews (Apify): run actor and get dataset
- Update Google Maps in Sheets (Google Sheets): append or update
- Update Yelp in Sheets (Google Sheets): append or update
- Update Tripadvisor in Sheets (Google Sheets): append or update
- Merge: merges the data from its input branches
- Send Email Notification (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Fetch Google Maps Reviews, Fetch Yelp Reviews, Fetch Tripadvisor Reviews).
Nodes used (5)
- Apify
@apify/n8n-nodes-apify.apify - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow runs every four days to scrape Google Maps, Yelp, and Tripadvisor reviews via Apify, stores them in dedicated Google Sheets tabs, and then sends a Gmail notification when the collection run finishes. How it works 1. Runs on a…