Latenode
Google Business Profile
Slack
Google sheets

Automate your Google Business review workflow with AI

This automation solution helps businesses and reputation management teams efficiently monitor and respond to Google Business Profile reviews. It automatically captures new reviews, uses AI to generate personalized response suggestions, sends differentiated Slack notifications (urgent alerts for negative reviews, celebration messages for positive ones), and logs the data into a Google Sheets spreadsheet for tracking and analysis.

The workflow is triggered by the Google Business Profile API, requiring the business's account and location IDs. It then formats the review details, processes the responses through an AI/NLP service, and sends notifications via Slack before storing the information in a Google Sheet. This end-to-end automation helps local businesses, restaurants, retailers, and service providers stay on top of customer feedback and respond promptly with thoughtful, AI-generated responses.

Updated Apr 2, 2026Est. run: 14sEst. cost: $0.0009
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Data, spreadsheets & databases

Workflow preview

What this template does

  • Automatically captures new Google Business reviews
  • Generates personalized response suggestions using AI/NLP
  • Sends Slack notifications for urgent alerts and positive reviews
  • Logs review details and responses in a Google Sheets spreadsheet
  • Requires Google Business Profile API account and location IDs

How it works

1
Trigger

Capture New Google Reviews

This step is triggered by the Google Business Profile API whenever a new review is posted. It retrieves the review details, including the source, rating, text, reviewer, date, and unique ID.

2
Logic

Format Review Details

This step extracts the relevant review data (source, rating, text, reviewer, date, ID) from the API response and formats it for further processing.

3
AI

Generate AI Response

This step analyzes the review text using natural language processing and generates a personalized response suggestion based on the review sentiment and content.

4
Logic

Negative Review?

This step checks if the review rating is 3 or below, indicating a negative sentiment. It determines whether to send an urgent Slack notification or a celebratory one.

5
Action

Alert Team - Negative

If the review is negative, this step sends an urgent Slack notification to the team, highlighting the issue and providing the AI-generated response suggestion.

6
Action

Notify Team - Positive

If the review is positive, this step sends a celebratory Slack notification to the team, sharing the good news and the AI-generated response suggestion.

7
Action

Log to Google Sheets

This final step appends the review details and the AI-generated response to a Google Sheets spreadsheet for tracking and analysis.

Setup guide

1

Configure Google Business Profile API

1. Add a Google Business Profile API credential in the Latenode Credentials panel. 2. In the credential settings, configure the following: - Service account JSON key - Google Business Account ID - Google Business Location ID These details can be obtained from your Google Cloud Console.

2

Set up Google Sheets Integration

1. Add a Google Sheets credential in the Latenode Credentials panel. 2. In the credential settings, configure the service account JSON key. 3. Create a new Google Sheet and a "Reviews" tab with the following column headers: Date, Source, Rating, Reviewer, Review, AI Response, Review ID. 4. Copy the Google Sheet ID and set it as a Latenode workspace secret.

3

Configure Slack Notifications

1. Add a Slack Incoming Webhook credential in the Latenode Credentials panel. 2. In the credential settings, configure the Slack Webhook URL. 3. Set the Slack Webhook URL as a Latenode workspace secret.

4

Set Business Configuration

1. In the Business Configuration node, set the following: - Business Name - AI Response Tone (professional, friendly, casual) 2. Set the Notification Email as a Latenode workspace secret.

5

Connect the Workflow

1. In the Google Business Profile Trigger node, map the required fields (Business Account ID, Location ID) using the Latenode Secrets panel. 2. Map the review details, AI-generated response, and other relevant fields to the corresponding columns in the Google Sheets Log node. 3. Customize the Slack notification messages in the HTTP Request nodes as needed.

Requirements

Google Business Profile API access with required account and location IDs
Google Sheets API access to create and update a spreadsheet for review data logging
Slack workspace and app with permissions to send notifications
Latenode workspace with access to 'headless-browser', 'code', and other required nodes

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Data, spreadsheets & databases

Automatically sync new Notion items to Google Docs documents

This Latenode automation template allows you to automatically create a new Google Docs document whenever a new item is added to a Notion database. This streamlines your workflow, ensuring that your important information is easily accessible across both platforms. The integration works by detecting new items in your Notion database and then creating a corresponding document in a specified Google Docs folder, with the content from the Notion item copied over. This saves time and keeps your documentation organized, allowing you to focus on more strategic priorities.

8s$0.0005
Data, spreadsheets & databases

Automatically create Google Docs from new Google Forms submissions

This Latenode automation template creates a Google Doc based on a pre-defined template, using data from new submissions in a linked Google Forms spreadsheet. Whenever a new response is added or an existing one is updated in the spreadsheet, the integration automatically generates a corresponding Google Doc, eliminating the need for manual copy-pasting. This saves time and ensures that all form responses are captured in a document format for further processing. The key integrations involved are Google Forms and Google Docs, with the Google Forms spreadsheet serving as the data source and the generated Google Docs as the output.

7s$0.0004
Data, spreadsheets & databases

Automatically notify via Burst SMS when new rows added to Google Sheets

This Latenode automation allows users to stay focused on their primary workflows by automatically sending SMS messages through the Burst SMS platform whenever a new row is added to a specified Google Sheets spreadsheet. It connects the Google Sheets data source to the Burst SMS service, streamlining the notification process. Users can configure the specific spreadsheet and mobile number to receive the SMS updates, helping them stay informed without getting distracted from their main tasks.

7s$0.0004