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.
Perfect for:
| 🧩 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 |
| 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 |
Modify the prompt in the OpenAI node to match your brand’s voice:
Write a short, engaging Google Business Post about: "{{ $json.topic }}".
Make it suitable for a local audience and include a subtle call to action.
