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

Description

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