This powerful n8n workflow automatically generates and publishes Google Business Profile (GMB) posts using topics liste…
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. An n8n automation workflow template by Muhammad Qaisar Mehmood.
Muhammad Qaisar Mehmood
web
paid
Others in the same category, ranked by how often they are opened.
