Automate Google Business Profile Posts with GPT-4 & Google Sheets

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

1. 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:

2. 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

3. 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