Automate Google Business Profile Posts with Gpt-4 & Google Sheets

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "nodes": [
    {
      "id": "7644d705-cec5-430b-a56f-fbb48741ba4f",
      "name": "Get Unpublished Row",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -592,
        288
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "eb1dd6f8-84b5-458f-b5b1-2274944ac36a",
      "name": "Post to GMB",
      "type": "n8n-nodes-base.googleBusinessProfile",
      "position": [
        528,
        288
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5e625f49-fe4f-4f90-8955-4194868eb733",
      "name": "Mark as Published",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        288
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "02390dd6-0eaa-4852-b489-dc2f18cc462d",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "notes": "Set Trigger (Day or Hour). ",
      "position": [
        -944,
        288
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "e80a9c4b-c375-40cb-b819-99e4900dadf3",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -176,
        16
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "24cf1fb1-5e13-4d41-ab5a-8adea8be6fd7",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -176,
        176
      ],
      "parameters": {},
      "typeVersion": 1.2
    }
  ],
  "connections": {
    "AI Agent": {
      "main": [
        [
          {
            "node": "Post to GMB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post to GMB": {
      "main": [
        [
          {
            "node": "Mark as Published",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Get Unpublished Row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Unpublished Row": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

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…

Source: https://n8n.io/workflows/6165/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.