Reply to Google reviews and send weekly insights with OpenAI and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on Google Business Profile events (plus 1 other trigger). Along the way it connects Google Business Profile, OpenAI, Google Sheets and Slack and 1 more.
How it runs
Trigger: On Google Business Profile events (plus 1 other trigger).
- Normalize Review Data (Code): runs custom JavaScript code
- Read Review Log (Google Sheets): uses Google Sheets
- Draft Reply & Tag Root Cause (OpenAI): uses OpenAI
- Calculate Stars Lost by Cause (Code): runs custom JavaScript code
- Parse AI Output (Code): runs custom JavaScript code
- Write Weekly Owner Insight (OpenAI): uses OpenAI
- Log Review to Sheet (Google Sheets): append
- Email Weekly Report to Owner (Gmail): uses Gmail
- Needs Owner Approval? (If): checks a condition and branches into true / false
- Ask Owner to Approve Reply (Slack): send and wait for a reply
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Google Business Profile Trigger
n8n-nodes-base.googleBusinessProfileTrigger - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Google Business Profile
n8n-nodes-base.googleBusinessProfile - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow monitors new Google Business Profile reviews, uses OpenAI to draft replies and tag a single root-cause category, routes complaint replies to Slack for approval, logs every review to Google Sheets, and emails a weekly Gmail report…