Google Business Profile and Slack integration

⭐ Google Review Sentiment Analysis & Slack Notification Workflow This workflow automates the process of collecting Google Business Profile reviews 🏪, analyzing customer sentiment with Google Gemini 🤖✨, and sending structured reports to Slack 💬. 🔑 Key Advantages 📥 Fetches Google Business Profile reviews for a given business and time period 🧠 Runs sentiment analysis using Gemini AI 📊 Consolidates comments, ratings, and trends into a JSON-based summary 🧩 Restructures results into Slack Block Kit format for easy readability 🚀 Sends automated sentiment reports directly to a Slack channel ⚙️ Set Up Essentials You’ll Need 🔑 Google Business Profile API access with project approval ✅ Enabled Google Business Profile API service 🔐 Gemini API credentials 💬 Slack workspace & channel for receiving reports 🚀 How to Get Started 🔧 Configure your Google Business Profile API and enable access 👤 Set the owner name and 📍 location to fetch reviews ⏳ Define the review time period using the Set Time Period node 🔗 Connect your Slack account and select a channel for notifications 🕒 Deploy and let the workflow run on schedule for automated insights

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 — right inside n8n. This workflow pulls Google Business data, compares weekly and 12-week trends, runs it through an LLM for insight summaries, and sends out Slack updates and weekly email reports — automatically. 🔥 Name: Google Pulse Pro Your AI marketing analyst that runs 24/7 — no subscription, no fluff. 🧩 Categories Business Intelligence Marketing Automation AI Summarization Multichannel Reporting 💬 Overview Google Pulse Pro automates weekly Google Business reporting for multiple companies or locations. It combines data collection, trend analysis, and AI commentary into a fully automated system — delivering updates through Slack and email. Perfect for agencies or businesses that want client-ready, insight-driven updates without paying for SaaS dashboards. ⚙️ Good to Know Uses OpenAI Chat Models for summarization and insights Integrates Google Business API, Google Sheets, Slack, and Email (Gmail or SMTP) Compares this week vs last week and 12-week averages Outputs LLM-generated summaries formatted for Slack Blocks and email templates 100% no-code friendly — ready to deploy instantly 🧠 How It Works Read Companies (Google Sheets) Loads company info, Google Business IDs, Slack channels, and recipient emails. Pull Google Business Data Queries the Google Business API for impressions, actions, CTR, and reviews across: This week Last week 12-week average Summarize & Compare Code nodes calculate trends and append results back to Google Sheets. AI Summaries (OpenAI) Three separate LLMs generate insight lines: Impressions one-liner → Visibility & engagement shifts Reviews one-liner → Sentiment & reputation trends Overall one-liner → Combined marketing summary Format & Distribute All one-liners merge per company. Recipients are attached, and messages are formatted for output. Send Reports Slack: Beautifully formatted updates via Slack Blocks Email: Branded Weekly Google Business Pulse summaries 📈 Example Output Slack Message: Weekly Google Reviews & Impressions Number 1 Auto Repair Sept 22–28, 2025 • Impressions down 41% vs last week • CTR 3pp lower than 12-week avg • 2 new reviews, 100% positive sentiment Email Pulse: 🧾 Requirements Google Business API credential** (OAuth2) Google Sheets credential** (OAuth2) Slack credential** (OAuth2) — chat:write, users:read, channels:read Gmail or SMTP credential** (for email pulse delivery) OpenAI credential** (for summaries) ✏️ Customizing Add other KPIs (Google Ads, GA4, POS data) Adjust scheduling cadence (daily, bi-weekly, monthly) Send reports to Notion, Airtable, or HubSpot Update Slack + email branding for your agency 💡 Use Cases Agencies automating client reporting Multi-location businesses monitoring reputation Service centers tracking performance trends Anyone tired of paying for “Google Business Pulse” dashboards 🎯 Why It Matters Most marketing firms hide behind “AI dashboards” to sell visibility reports. Google Pulse Pro gives you that same power — automated, AI-enhanced, and free. Unchain your reporting. Impress clients. And keep your marketing dollars where they belong — in your business.

How it works This workflow automatically handles new Google reviews by generating AI-powered replies and deciding how to respond based on rating. Positive reviews are replied to instantly, while lower ratings are routed for manual approval via Slack. It ensures fast engagement without losing control over sensitive responses. The process runs continuously using a real-time trigger. Step-by-step Capture new reviews** Fetch New Reviews – Triggers when a new review is posted in Google Business Profile. Edit Fields – Extracts and formats reviewer name, rating, and review text. Generate AI response** AI Agent – Creates a contextual, human-like reply based on the review content. Groq Chat Model – Powers the AI Agent with a language model for response generation. Decision and response handling** If – Checks if the review rating is positive (4 or 5 stars). Reply to review – Automatically posts reply for positive reviews. Send message and wait for response – Sends review + AI reply to Slack for approval if rating is lower. If1 – Checks whether the Slack response is approved. Reply to review1 – Posts the approved reply back to Google Business Profile. Why use this? Respond instantly to positive reviews and boost customer engagement Maintain control over sensitive or negative feedback with approval flow Save time by automating repetitive review responses Ensure consistent tone using AI-generated replies Improve brand reputation with faster, structured responses