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/apidefault 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 text 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