{
  "name": "Automate Google My Business responses with Gemini AI and Google Sheets tracking",
  "nodes": [
    {
      "id": "2ed803fa-b2f0-472c-b5f3-3f666675c29d",
      "name": "Every 30 Minutes",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -5024,
        -304
      ]
    },
    {
      "id": "280f4e1e-0336-4ce6-b3ea-616ada9d668e",
      "name": "Log to Business Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2992,
        -848
      ]
    },
    {
      "id": "89e911ec-d218-4e7d-8b02-146343b6d2b7",
      "name": "Post Reply (GMB)",
      "type": "n8n-nodes-base.googleBusinessProfile",
      "position": [
        -1392,
        -832
      ]
    },
    {
      "id": "a6682823-ad59-4bd1-9a75-8cbbc52ef675",
      "name": "Update Sheet (Success)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -944,
        -832
      ]
    },
    {
      "id": "5a735971-c0be-40d3-bc22-3ed64da2ab4c",
      "name": "Get Business Configs1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -4816,
        -304
      ]
    },
    {
      "id": "05281b6a-bf22-4707-a39f-52b89615d7ca",
      "name": "Prepare Reply",
      "type": "n8n-nodes-base.code",
      "position": [
        -2032,
        -848
      ]
    },
    {
      "id": "bda8aee3-f165-4456-ac37-faa4030c0473",
      "name": "Log Success",
      "type": "n8n-nodes-base.code",
      "position": [
        -1152,
        -832
      ]
    },
    {
      "id": "ea850788-72d2-4cac-8ebd-e3efc08cfc94",
      "name": "Filter Unreplied Reviews1",
      "type": "n8n-nodes-base.code",
      "position": [
        -3840,
        -736
      ]
    },
    {
      "id": "f19e144d-be09-4ace-8633-6f03d206a36e",
      "name": "No New Reviews1",
      "type": "n8n-nodes-base.code",
      "position": [
        -3200,
        -528
      ]
    },
    {
      "id": "ba30b2b8-f844-4522-9831-7c67495ed806",
      "name": "Get Reviews (Digital Scalers)",
      "type": "n8n-nodes-base.googleBusinessProfile",
      "position": [
        -4048,
        -736
      ]
    },
    {
      "id": "6ede4b3f-eb55-473e-adbd-feaac6edbc5a",
      "name": "Message a model",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        -2384,
        -848
      ]
    },
    {
      "id": "680f7d9c-32fb-47b3-965a-6e5763dc580e",
      "name": "Split Reviews1",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -3200,
        -848
      ]
    },
    {
      "id": "d9b00029-1730-4326-a0b6-7eb9a3fe0ce8",
      "name": "Has Unreplied Reviews?1",
      "type": "n8n-nodes-base.if",
      "position": [
        -3632,
        -736
      ]
    },
    {
      "id": "61ceb33c-f11b-4879-9cc8-5373e5ea98c7",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1632,
        -848
      ]
    },
    {
      "id": "751d2335-d6dc-4196-beb7-a64213cc5685",
      "name": "Prepare Reply1",
      "type": "n8n-nodes-base.code",
      "position": [
        -2032,
        -96
      ]
    },
    {
      "id": "37a22928-3e96-4b86-8a9a-9e07e3d91fc5",
      "name": "Log Success1",
      "type": "n8n-nodes-base.code",
      "position": [
        -1216,
        -80
      ]
    },
    {
      "id": "8a736585-51a2-414a-8534-94608f4dd7ac",
      "name": "Filter Unreplied Reviews2",
      "type": "n8n-nodes-base.code",
      "position": [
        -3856,
        -16
      ]
    },
    {
      "id": "e104828a-4a73-4967-a842-b4adb7f2b064",
      "name": "No New Reviews2",
      "type": "n8n-nodes-base.code",
      "position": [
        -3136,
        240
      ]
    },
    {
      "id": "86fc2598-ec31-4b9c-9f65-2dfca7c058fd",
      "name": "Split Reviews",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -3136,
        -96
      ]
    },
    {
      "id": "a3f1b769-afc4-43f3-a83d-43d2c252fc02",
      "name": "Has Unreplied Reviews?2",
      "type": "n8n-nodes-base.if",
      "position": [
        -3632,
        -16
      ]
    },
    {
      "id": "9ed5b69b-d1c6-41bf-b759-0c198967ff9f",
      "name": "Loop Over Items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -1632,
        -96
      ]
    },
    {
      "id": "5658d5f2-75ed-4d58-aee2-cf0bfadb9ba2",
      "name": "Get Reviews (Acuyu)",
      "type": "n8n-nodes-base.googleBusinessProfile",
      "position": [
        -4064,
        -16
      ]
    },
    {
      "id": "8bda61d0-ea2d-4d8d-a13c-6e0ae849b881",
      "name": "Route Locations",
      "type": "n8n-nodes-base.switch",
      "position": [
        -4416,
        -304
      ]
    },
    {
      "id": "2152467a-6f61-4dd0-8c8f-b7c40c1b1624",
      "name": "Prepare Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -2752,
        -848
      ]
    },
    {
      "id": "c8921793-3db1-48cd-839b-d8d9c5d0a5ba",
      "name": "Update Business Config Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -704,
        -928
      ]
    },
    {
      "id": "1c2042da-68a0-4d53-a7cc-7af702e3d7fa",
      "name": "Log to Business Sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -2928,
        -96
      ]
    },
    {
      "id": "62219b42-4ff1-4948-9ab9-3bc19cfd7deb",
      "name": "Prepare Data1",
      "type": "n8n-nodes-base.set",
      "position": [
        -2736,
        -96
      ]
    },
    {
      "id": "bff7462e-fed1-446a-a44d-4fc98ae5db5b",
      "name": "Message a model2",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        -2400,
        -96
      ]
    },
    {
      "id": "c2d62d71-8410-45a2-abbe-a4fdddf49921",
      "name": "Post Reply (GMB)1",
      "type": "n8n-nodes-base.googleBusinessProfile",
      "position": [
        -1376,
        -80
      ]
    },
    {
      "id": "32994c39-b989-4980-8b0a-bd5206dbfe68",
      "name": "Update Sheet (Success)1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1024,
        -80
      ]
    },
    {
      "id": "d943e7ca-55ea-43fd-8b02-01fabc6ca04b",
      "name": "Update Business Config Sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -800,
        -160
      ]
    },
    {
      "id": "5b5b0244-3511-4961-b8fc-2ceb84e3adc2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -5120,
        -448
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "f46ea9fe-75df-46b8-84cf-422deff4bb3d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4512,
        -448
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9d405d77-710d-4b21-a404-cc421a2fc0ec",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4112,
        -848
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "6aba1da9-d658-4791-b1f2-936922968cec",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3280,
        -960
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "149eb0fd-5223-40a8-98c9-8abd25defea5",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2528,
        -960
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "7550f11b-68ea-4fa4-9754-80bf28b7a9de",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1728,
        -960
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "43e12ad3-7508-44b0-842f-1933ec88b1eb",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4128,
        -144
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "cf56c598-fc9f-40c1-a445-cb207e2debe6",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3248,
        -208
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "1f5a6237-03ad-473b-a033-cc25c20bdec3",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2512,
        -208
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9631428f-5025-4db7-ac72-384f75120af2",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1696,
        -208
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "cd14a2bc-e373-459d-9c56-29e3ece9b411",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -5120,
        -1024
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "Log Success": {
      "main": [
        [
          {
            "node": "Update Sheet (Success)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Success1": {
      "main": [
        [
          {
            "node": "Update Sheet (Success)1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Data": {
      "main": [
        [
          {
            "node": "Message a model",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Data1": {
      "main": [
        [
          {
            "node": "Message a model2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Reply": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Reviews": {
      "main": [
        [
          {
            "node": "Log to Business Sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Reply1": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Reviews1": {
      "main": [
        [
          {
            "node": "Log to Business Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Update Business Config Sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Post Reply (GMB)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model": {
      "main": [
        [
          {
            "node": "Prepare Reply",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route Locations": {
      "main": [
        [
          {
            "node": "Get Reviews (Digital Scalers)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Get Reviews (Acuyu)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every 30 Minutes": {
      "main": [
        [
          {
            "node": "Get Business Configs1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [
          {
            "node": "Update Business Config Sheet1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Post Reply (GMB)1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message a model2": {
      "main": [
        [
          {
            "node": "Prepare Reply1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post Reply (GMB)": {
      "main": [
        [
          {
            "node": "Log Success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post Reply (GMB)1": {
      "main": [
        [
          {
            "node": "Log Success1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Reviews (Acuyu)": {
      "main": [
        [
          {
            "node": "Filter Unreplied Reviews2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Business Configs1": {
      "main": [
        [
          {
            "node": "Route Locations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Business Sheet": {
      "main": [
        [
          {
            "node": "Prepare Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Business Sheet1": {
      "main": [
        [
          {
            "node": "Prepare Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Sheet (Success)": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has Unreplied Reviews?1": {
      "main": [
        [
          {
            "node": "Split Reviews1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No New Reviews1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has Unreplied Reviews?2": {
      "main": [
        [
          {
            "node": "Split Reviews",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No New Reviews2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Sheet (Success)1": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unreplied Reviews1": {
      "main": [
        [
          {
            "node": "Has Unreplied Reviews?1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unreplied Reviews2": {
      "main": [
        [
          {
            "node": "Has Unreplied Reviews?2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Reviews (Digital Scalers)": {
      "main": [
        [
          {
            "node": "Filter Unreplied Reviews1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}