See llms.txt for all machine-readable content.

Back to Templates

Send weekly multi-platform review reports from Apify to Gmail

Created by

Created by: Joseph Fadero || josephfadero
Joseph Fadero

Last update

Last update a day ago

Categories

Share

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

  1. Runs every Friday at 8am on a schedule.
  2. Starts the Apify Multi-Platform Review Scraper Actor with your configured business profile URLs and waits for the run to finish.
  3. Fetches the scraped review items from the Apify dataset for the last 7 days.
  4. 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.
  5. Combines all business cards into a single weekly HTML report with a summary header.
  6. Sends the HTML report email to the configured recipient using Gmail.

Setup

  1. Add your Apify API token and replace YOUR_APIFY_API_TOKEN in both Apify HTTP requests.
  2. Replace the profileUrls list with the actual Google Maps, Yelp, and TripAdvisor business page URLs for each client you want to track.
  3. 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).