PICKED FROM N8N.IO · MARKETING & REVIEWS

Runs weekly for each business listed in a Google Sheet. It pulls Google Business Profile impressions and reviews for this week, last week and the past 12 weeks, saves the figures to the sheet, and has OpenAI write short summary lines. The results go out as a Slack message and an email per company.

Template by Peyton Leveillee · 932 views on n8n.io · listed there as “Automated Google Business reports with GPT insights to Slack & email”

THE WORKFLOW56 NODES
◆OpenAI ChatModel4▦Read Companies{}Build WeekWindow2↯Get Impressiondata{}Flatten▦Add Impressionsto Sheet{}Set Company(reviews)GGet Many Reviews{}Build Week Window(reviews)▦Add Reviews toSheet{}Summarize WeeklyReviews▦Add WeeklySummary{}Set Company(total reviews){}Build 12-WeekWindow↯12 weekimpressions{}Flatten 12-week▦Add 12 weekImpressions to S…▦Add all timeSummaryGGet all reviews⋈Merge2↯Get Impressions(last week){}Flatten (lastweek){}Join All◆OpenAI ChatModel2{}Review Parser{}Impression parser{}All-time Reviews→ KPIs (no LLM){}Map weeklyreviews◷Schedule Trigger{}Create Email{}Build last weekwindow{}Set Company lastweek reviewsGGet last weekreviews{}Set Company last12 week reviewsGGet last 12 weekreviews{}map and summarizelast 12 weeks re…{}Map + categorizereviews (last we…{}Summarize WeeklyReviews (last we…{}Summarize 12-weekreviews (totals …{}Build 12-weekwindow (reviews){}format◆OpenAI Chat Model✦Reviews one-liner✦Impressionsone-liner✦Overall one-liner{}overall parser▦Read Recipients{}Normalize Keys{}Normalizerecipients⋈Attach recipients#All-companiesSlack#Per Company Slack@Per company email⋈Merge One Liners{}Group Three LinesPer Company▦Append row insheet
DIFFICULTY
Advanced
NODES
56
USES AI
Yes
PUBLISHED
October 2025

001 / WHAT HAPPENS

  1. 01

    A schedule trigger reads the list of companies, Google Business IDs and recipients from a Google Sheet.

  2. 02

    The workflow pulls impressions and reviews from Google Business Profile for this week, last week and the past 12 weeks.

  3. 03

    Code steps compare the periods and write the figures back to the Google Sheet.

  4. 04

    Three OpenAI agents write one-line summaries on impressions, reviews and the overall picture.

  5. 05

    Slack messages and Gmail emails with those summaries are sent to each company's recipients.

WHO IT SUITS

Suits marketing agencies or multi-location businesses that report on Google Business Profile results to clients or branch managers each week.

CONNECTS

  • Google Business Profile
  • Google Sheets
  • OpenAI
  • Slack
  • Gmail

002 / BEFORE YOU USE IT HERE

  • !It sends to clients and staff automatically, so test with your own address and Slack channel first before adding real recipients.
  • !Review and performance summaries go to an overseas AI provider. Reviewer names, if included, are personal information, so cover this under APP 8 in your privacy policy.
  • !Google Business Profile API access must be approved by Google and this takes time. The sheet needs the exact columns the template expects.
  • !Set the workflow timezone to Australia/Sydney (or your city) so the weekly windows start on the right day.

LOCAL SWAP

Swap the Slack nodes for the Microsoft Teams nodes if your team uses Teams.

Need n8n and the AI hosted in Australia? →

004 / QUESTIONS

Anything else is quicker to answer on a call. Thirty minutes, free, with the people who would build it.

Yes. Every template on this list is free on n8n.io. You need an n8n account (n8n Cloud or self-hosted) and accounts for the apps it connects to, some of which charge for API use.

We adapt templates to your systems, add approval steps where customers are involved, host n8n in Australia when the data calls for it and hand it over documented.

Book a free call→