Automated Google Business reports with GPT insights to Slack & email

by Peyton Leveillee · 928 views · created 2025-10-06 · Market Research, AI Summarization

What this workflow does

This AI workflow has 56 nodes and runs on a schedule (every week at 18:00). Along the way it connects OpenAI Chat Model, Google Sheets, Google Business Profile and Slack and 1 more.

How it runs

Trigger: On a schedule (every week at 18:00).

1. Read Companies (Google Sheets): uses Google Sheets
2. Build Week Window (Code): runs custom JavaScript code
3. Build Week Window (reviews) (Code): runs custom JavaScript code
4. Build 12-Week Window (Code): runs custom JavaScript code
5. Set Company (total reviews) (Code): runs custom JavaScript code
6. Build last week window (Code): runs custom JavaScript code
7. Build 12-week window (reviews) (Code): runs custom JavaScript code
8. Get Impression data (HTTP Request): calls an HTTP API
9. Get Impressions (last week) (HTTP Request): calls an HTTP API
10. Set Company (reviews) (Code): runs custom JavaScript code

…plus 39 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelGoogle SheetsGoogle Business ProfileSlackGmail

Before you upgrade to n8n 3.0

Nodes used (11)

• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Google Business Profilen8n-nodes-base.googleBusinessProfile
• Mergen8n-nodes-base.merge
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Schedule Triggern8n-nodes-base.scheduleTrigger
• AI Agent@n8n/n8n-nodes-langchain.agent
• Slackn8n-nodes-base.slack
• Gmailn8n-nodes-base.gmail

From the author

Created by: Peyton Leveillee Last updated: October 2025 --- 🧠 TL;DR Marketing companies charge hundreds or even thousands per month for automated “Google Business Pulse” reports that show visibility, reviews, and engagement trends. Now you can do it for free…

View the original on n8n.io → Check your own copy