📊 Send weekly multi-platform review reports from Apify to Gmail
⚡ 0 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Quick overview
This workflow runs every Friday at 8am to scrape the past week’s reviews from Google Maps, Yelp, and TripAdvisor using an Apify Actor, aggregates results by business, and sends a branded HTML reputation report to a client via Gmail.
How it works
- Runs every Friday at 8am on a schedule.
- Starts the Apify Multi-Platform Review Scraper Actor with your configured business profile URLs and waits for the run to finish.
- Fetches the scraped review items from the Apify dataset for the last 7 days.
- Groups reviews by business, calculates weekly totals, average rating, positive/negative counts, and formats each business into an HTML report card with recent review snippets.
- Combines all business cards into a single weekly HTML report with a summary header.
- Sends the HTML report email to the configured recipient using Gmail.
Setup
- Add your Apify API token and replace YOUR_APIFY_API_TOKEN in both Apify HTTP requests.
- Replace the profileUrls list with the actual Google Maps, Yelp, and TripAdvisor business page URLs for each client you want to track.
- Connect a Gmail OAuth2 credential and set the recipient email address in the Gmail send step (or extend the workflow to loop through multiple clients).
🔗 Nodes Used
HTTP Request, Gmail, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File