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”
- DIFFICULTY
- Advanced
- NODES
- 56
- USES AI
- Yes
- PUBLISHED
- October 2025
001 / WHAT HAPPENS
- 01
A schedule trigger reads the list of companies, Google Business IDs and recipients from a Google Sheet.
- 02
The workflow pulls impressions and reviews from Google Business Profile for this week, last week and the past 12 weeks.
- 03
Code steps compare the periods and write the figures back to the Google Sheet.
- 04
Three OpenAI agents write one-line summaries on impressions, reviews and the overall picture.
- 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? →003 / MORE FOR MARKETING & REVIEWS
- 13 NODESAI
MARKETING & REVIEWS
Draft LinkedIn posts from a Google Sheet with email approval
Google SheetsOpenAIGmailLinkedInIntermediateby Aryan Shinde46.7k views - 12 NODESAI
MARKETING & REVIEWS
Write blog drafts from a Google Sheets topic list with approval
Google SheetsOpenAIGmailIntermediateby Billy Christi25.4k views - 6 NODESAI
MARKETING & REVIEWS
Post to Instagram from Google Drive with AI-written captions
Google DriveGoogle SheetsOpenAIInstagramIntermediateby Sagar11.2k views
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→