{"product_id":"n8n-weekly-multi-platform-review-report-via-apify-gmail","title":"n8n Weekly Multi-Platform Review Report via Apify + Gmail","description":"\u003ch3\u003eGet a branded weekly reputation report—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every Friday at 8am to scrape the past week’s reviews from \u003cstrong\u003eGoogle Maps, Yelp, and TripAdvisor\u003c\/strong\u003e via \u003cstrong\u003eApify\u003c\/strong\u003e, aggregates them by business, and emails a polished \u003cstrong\u003eHTML reputation report\u003c\/strong\u003e through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled execution:\u003c\/strong\u003e Uses an n8n schedule trigger to run every Friday at 8am.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRun Apify Multi-Platform Review Scraper:\u003c\/strong\u003e Starts the \u003cstrong\u003eApify Multi-Platform Review Scraper Actor\u003c\/strong\u003e with your configured business profile URLs and waits for the run to complete.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePull last 7 days of reviews:\u003c\/strong\u003e Fetches review items from the Apify dataset for the \u003cstrong\u003epast 7 days\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAggregate by business:\u003c\/strong\u003e Groups reviews per business, calculates weekly totals, \u003cstrong\u003eaverage rating\u003c\/strong\u003e, and counts of \u003cstrong\u003epositive vs. negative\u003c\/strong\u003e reviews.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerate HTML report cards:\u003c\/strong\u003e Formats each business into an HTML “card” including weekly metrics and recent review snippets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail the report:\u003c\/strong\u003e Combines all cards into a single weekly HTML report and sends it to your recipient via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMulti-location operators:\u003c\/strong\u003e Track brand reputation weekly across Google Maps, Yelp, and TripAdvisor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReputation managers:\u003c\/strong\u003e Keep stakeholders updated with quantified sentiment and recent snippets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS and agency workflows:\u003c\/strong\u003e Provide automated weekly review reporting to clients (extend to loop through multiple clients if needed).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e for Friday 8am runs\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to call Apify (includes \u003ccode\u003eYOUR_APIFY_API_TOKEN\u003c\/code\u003e)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify dataset retrieval\u003c\/strong\u003e for the last 7 days\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode\u003c\/strong\u003e node to group reviews and compute weekly aggregates\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eItem Lists\u003c\/strong\u003e for structured processing\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e node (OAuth2) to send the HTML report to the configured email address\u003c\/li\u003e\n  \u003cli\u003eIncludes workflow organization via a \u003cstrong\u003eSticky Note\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet your Apify token, add the profile URLs for each business, and connect Gmail OAuth2—then your weekly n8n reputation reporting is ready to run.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45916232188083,"sku":"N8N-18822","price":38.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Ler8fx2-OBtsAHjuhXk0Z_gFBNWqMU.png?v=1788012925","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-multi-platform-review-report-via-apify-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}