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 |

---