n8n Weekly Multi-Platform Review Report via Apify + Gmail

Get a branded weekly reputation report—automatically

This n8n workflow runs every Friday at 8am to scrape the past week’s reviews from Google Maps, Yelp, and TripAdvisor via Apify, aggregates them by business, and emails a polished HTML reputation report through Gmail.

What this workflow does

• Scheduled execution: Uses an n8n schedule trigger to run every Friday at 8am.
• Run Apify Multi-Platform Review Scraper: Starts the Apify Multi-Platform Review Scraper Actor with your configured business profile URLs and waits for the run to complete.
• Pull last 7 days of reviews: Fetches review items from the Apify dataset for the past 7 days.
• Aggregate by business: Groups reviews per business, calculates weekly totals, average rating, and counts of positive vs. negative reviews.
• Generate HTML report cards: Formats each business into an HTML “card” including weekly metrics and recent review snippets.
• Email the report: Combines all cards into a single weekly HTML report and sends it to your recipient via Gmail.

Use cases

• Multi-location operators: Track brand reputation weekly across Google Maps, Yelp, and TripAdvisor.
• Reputation managers: Keep stakeholders updated with quantified sentiment and recent snippets.
• SaaS and agency workflows: Provide automated weekly review reporting to clients (extend to loop through multiple clients if needed).

Technical details

• Schedule Trigger for Friday 8am runs
• HTTP Request to call Apify (includes YOUR_APIFY_API_TOKEN)
• Apify dataset retrieval for the last 7 days
• Code node to group reviews and compute weekly aggregates
• Item Lists for structured processing
• Gmail node (OAuth2) to send the HTML report to the configured email address
• Includes workflow organization via a Sticky Note

Set your Apify token, add the profile URLs for each business, and connect Gmail OAuth2—then your weekly n8n reputation reporting is ready to run.