AutomationMart
Home/Browse/Automate Google Business Profile posts with GPT-4 & Google Sheets
n8n

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

n8nn8n6 modulesv1.0
SlackGoogle SheetsOpenAI

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 edit

At a glance

Automate Google Business Profile posts with GPT-4 & Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Google Sheets, OpenAI
Modules
6
Price
Free
Version
v1.0
Automate Google Business Profile posts with GPT-4 & Google Sheets workflow diagram

About this workflow

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: 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 --- 🧪 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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Create a Zoho Recruit job opening and send a Slack message from an updated Airtable record

Use this template to automatically create a Zoho Recruit job opening and send a Slack message when an Airtable record is updated. The template works with the following [Airtable base](https://airtable.com/shr1MWSUm3TaFzhuU). The scenario is triggered when the 'Status' field is updated. To achieve that, we created the 'Last modified' field of type 'Last modified time' and chose to watch updates in the 'Status' field only.

Free

Create a new Google Doc for every new response in Tally using ChatGPT

Instantly receive Tally for submissions and create new Google Docs with using ChatGPT responses, streamlining document creation and organization.

Free

Filter and add new rows in Google Sheets based on incoming data actions

Automatically filter Google Sheets rows and add new data based on incoming actions. Streamline data management with Google Sheets and HTTP integration.

Free

Invoice data extraction with LlamaParse and OpenAI

This n8n workflow automates the process of parsing and extracting data from PDF invoices. With this workflow, accounts and finance people can realise huge time and cost savings in their busy schedules. Read the Blog: How it works This workflow will watch an email inbox for incoming invoices from suppliers It will download the attached PDFs and processing them through a third party service called LlamaParse. LlamaParse is specifically designed to handle and convert complex PDF data structures

Free

Send Slack messages for new Flow XO first time interactions

When a person interacts with your Flow XO bot for the first time, Make will automatically send a message in Slack.

Free

Send messages to Slack using a ChatGPT assistant response from a custom webhook

Keep up to date by sending a ChatGPT assistant generated responses to Slack from information received from a custom webhook, streamlining communication and enhancing team collaboration with AI-driven insights.

Free

Conversational Razorpay Analytics with Google Gemini & Telegram Bot

Description Access your Razorpay insights instantly from Telegram—no dashboard, filters, or manual queries needed. Simply send messages like “show my payments”, “list recent orders”, or “check refunds”, and the bot retrieves the latest information from your Razorpay merchant account in seconds. Powered by AI, the workflow understands your message, fetches the relevant Razorpay data, and transforms it into a clear, easy-to-read summary. Everything is delivered back to you within the same T

Free

Self update Docker-based n8n with email approval and SSH

n8n Self-Updater Workflow > An automated n8n workflow originally built for DigitalOcean-based n8n deployments, but fully compatible with any VPS or cloud hosting (e.g., AWS, Google Cloud, Hetzner, Linode, etc.) where n8n runs via Docker. This workflow checks for the latest Docker image of n8n, notifies you via email for approval, and securely updates your n8n instance via SSH once approved. --- How It Works 1. Trigger: The workflow runs automatically every 3 days at 4 PM UTC (or manually if t

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free