Google Business Profile and Google Sheets integration

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.

This powerful n8n workflow automatically generates and publishes Google Business Profile (GMB) posts using topics listed in a Google Sheet. It uses OpenAI to write SEO-optimized post descriptions and generate AI images based on the topic — then posts them directly to your GMB profile and marks them as published in the sheet. 🎯 Use Case Perfect for: Digital marketers managing local SEO Agencies automating content for clients Businesses regularly posting to GMB Teams managing editorial calendars via Google Sheets ⚙️ Workflow Overview | 🧩 Node | 🔧 Purpose | |-------------------------------|------------| | 🕘 Schedule Trigger | Runs daily at 9AM (configurable) | | 📄 Get Unpublished Row | Reads a row from Google Sheet where Status is not marked "Published" | | ✍️ Generate Post Text | Uses OpenAI (GPT-4) to write a compelling, local-business optimized post | | 🖼 Generate Post Image | Uses DALL·E or similar to create an image matching the topic | | 📬 Post to GMB | Publishes the generated content to your Google Business Profile | | ✅ Update Sheet | Marks the status as "Published" in the Google Sheet | 📄 Google Sheet Format | Column Name | Description | |-------------|-------------| | Topic | The subject or idea for the GMB post | | Status | Should be blank or "Unpublished" to trigger the flow | | Date | (Optional) Posting schedule or note | | Notes | (Optional) Internal info — not used in the automation | 🔐 Google My Business API Setup Google Cloud Configuration Go to Google Cloud Console Enable the Google My Business API Create OAuth2 Client ID and Client Secret Add this required scope: Request for GMB Quota You need to request for GMB (Google Business Profile) API Quota from here, beacuse by deafult it sets to zero: https://support.google.com/business/contact/api_default n8n Credential Setup In n8n, go to Credentials > Google OAuth2 Use your Client ID and Client Secret Use this credential in GMB-related nodes 🧠 OpenAI Prompt Customization Modify the prompt in the OpenAI node to match your brand’s voice: Example Prompt Write a short, engaging Google Business Post about: "{{ $json.topic }}". Make it suitable for a local audience and include a subtle call to action. 🧪 Optional Enhancements Add If node to delay publishing on certain days Use Slack or Email notifications to alert before/after posting Use Multiple Businesses by adding a Router or Switch node per GMB account ✅ Benefits 🔁 Fully automated GMB posting ✍️ SEO-optimized, AI-written content 🖼 Matching images for visual engagement 📊 Maintains a content log via Google Sheets 🧠 Easily customizable prompt logic and schedule

Purpose & Audience This workflow is designed for digital marketing agencies, local business owners, and reputation management professionals who need to respond to Google My Business reviews promptly and professionally across multiple business locations. Perfect for: Agencies managing 2-50+ client locations Multi-location business owners Reputation management teams Marketing professionals seeking automation Problems it solves: Manual review monitoring is time-consuming Inconsistent response quality and tone Delayed responses hurt local SEO rankings Difficult to scale across multiple locations What It Does This automated system monitors your Google My Business locations every 30 minutes and: ✅ Fetches new reviews from multiple GMB locations automatically ✅ Generates personalized AI replies using Google Gemini, matching your brand voice and tone ✅ Posts responses directly to GMB without manual intervention ✅ Logs everything to organized Google Sheets for tracking and reporting ✅ Handles multiple businesses with separate processing pipelines ✅ Prevents duplicate replies by filtering already-responded reviews Key Features: Customizable reply tone per business (professional, friendly, casual, etc.) Business-specific context for more relevant responses Automatic execution tracking and audit logs Scalable architecture for unlimited locations No duplicate replies - smart filtering system How It Works High-Level Flow: Trigger: Workflow runs automatically every 30 minutes Configuration: Reads business settings from a Google Sheet (location IDs, tone, context) Route: Directs each business to its dedicated processing branch Fetch: Retrieves all reviews from Google My Business Filter: Identifies reviews without replies Generate: Uses AI to create personalized responses matching your brand tone Post: Publishes replies to Google My Business Track: Logs all activity to Google Sheets with timestamps Smart Features: Parallel processing for multiple businesses Context-aware AI that understands your business Automatic logging for compliance and reporting Graceful handling when no new reviews exist How to Setup Prerequisites Before setting up this workflow, you'll need: n8n Instance (Cloud or self-hosted) Google Gemini API Key (Free tier available at ai.google.dev) Google OAuth Credentials for: Google Sheets API, Google Business Profile API Setup Instructions 📘 Complete step-by-step setup tutorial included with the json file. The comprehensive setup guide covers: Creating and configuring your Google Sheets Connecting Google My Business API Setting up Google Gemini integration Configuring business-specific settings Testing and troubleshooting Adding additional business locations Customizing AI reply prompts Simply follow the included setup tutorial video for easy configuration. Average setup time: 20 minutes.

How it works This workflow automatically monitors your Google Business Profile for new reviews and uses AI to generate personalized response suggestions. When a review is detected, the system formats the review data, generates an appropriate AI response based on the rating and content, sends differentiated Slack notifications (urgent alerts for negative reviews, celebration messages for positive ones), and logs everything to Google Sheets for tracking and analysis. Who is this for Local business owners, restaurant managers, retail store operators, service providers, and reputation management teams who want to stay on top of customer feedback and respond promptly with thoughtful, AI-generated responses. Perfect for businesses that receive regular reviews and want to maintain consistent, professional customer engagement without manually monitoring multiple platforms. Requirements Google Business Profile**: Active business profile with review monitoring enabled Google API Credentials**: Service account with access to Business Profile API and Sheets API Slack Webhook**: Incoming webhook URL for team notifications Google Sheets**: Spreadsheet with "Reviews" sheet for logging review data Environment Variables**: Setup for secure credential storage Basic n8n Knowledge**: Understanding of triggers, expressions, and credential management How to set up Configure Google Business Profile API - Create Google Cloud project, enable Business Profile API, set up service account credentials, and add your Business Account ID and Location ID to environment variables Prepare Google Sheets Integration - Create Google Sheet with "Reviews" sheet, add required headers, set GOOGLE_SHEET_ID environment variable, and ensure service account has edit access Setup Slack Notifications - Create Slack webhook in your workspace and set SLACK_WEBHOOK_URL environment variable Customize Business Settings - Update Business Configuration node with your business name and adjust AI response tone preferences How to customize the workflow Modify the Business Configuration node to change your business name, adjust the AI response tone (professional, friendly, casual), customize Slack notification messages in the HTTP Request nodes, or add additional review sources by duplicating the trigger structure.