Malik Hashir This workflow corresponds to n8n.io template #11503 — we link there as the canonical source.
This workflow follows the Googlegemini → Google Sheets recipe pattern — see all workflows that pair these two integrations.
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 →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "2ed803fa-b2f0-472c-b5f3-3f666675c29d",
"name": "Every 30 Minutes",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-5024,
-304
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "280f4e1e-0336-4ce6-b3ea-616ada9d668e",
"name": "Log to Business Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2992,
-848
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "89e911ec-d218-4e7d-8b02-146343b6d2b7",
"name": "Post Reply (GMB)",
"type": "n8n-nodes-base.googleBusinessProfile",
"position": [
-1392,
-832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a6682823-ad59-4bd1-9a75-8cbbc52ef675",
"name": "Update Sheet (Success)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
-832
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "5a735971-c0be-40d3-bc22-3ed64da2ab4c",
"name": "Get Business Configs1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-4816,
-304
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "05281b6a-bf22-4707-a39f-52b89615d7ca",
"name": "Prepare Reply",
"type": "n8n-nodes-base.code",
"position": [
-2032,
-848
],
"parameters": {},
"typeVersion": 2
},
{
"id": "bda8aee3-f165-4456-ac37-faa4030c0473",
"name": "Log Success",
"type": "n8n-nodes-base.code",
"position": [
-1152,
-832
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ea850788-72d2-4cac-8ebd-e3efc08cfc94",
"name": "Filter Unreplied Reviews1",
"type": "n8n-nodes-base.code",
"position": [
-3840,
-736
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f19e144d-be09-4ace-8633-6f03d206a36e",
"name": "No New Reviews1",
"type": "n8n-nodes-base.code",
"position": [
-3200,
-528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ba30b2b8-f844-4522-9831-7c67495ed806",
"name": "Get Reviews (Digital Scalers)",
"type": "n8n-nodes-base.googleBusinessProfile",
"position": [
-4048,
-736
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6ede4b3f-eb55-473e-adbd-feaac6edbc5a",
"name": "Message a model",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
-2384,
-848
],
"parameters": {},
"typeVersion": 1
},
{
"id": "680f7d9c-32fb-47b3-965a-6e5763dc580e",
"name": "Split Reviews1",
"type": "n8n-nodes-base.splitOut",
"position": [
-3200,
-848
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d9b00029-1730-4326-a0b6-7eb9a3fe0ce8",
"name": "Has Unreplied Reviews?1",
"type": "n8n-nodes-base.if",
"position": [
-3632,
-736
],
"parameters": {},
"typeVersion": 2
},
{
"id": "61ceb33c-f11b-4879-9cc8-5373e5ea98c7",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1632,
-848
],
"parameters": {},
"typeVersion": 3
},
{
"id": "751d2335-d6dc-4196-beb7-a64213cc5685",
"name": "Prepare Reply1",
"type": "n8n-nodes-base.code",
"position": [
-2032,
-96
],
"parameters": {},
"typeVersion": 2
},
{
"id": "37a22928-3e96-4b86-8a9a-9e07e3d91fc5",
"name": "Log Success1",
"type": "n8n-nodes-base.code",
"position": [
-1216,
-80
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8a736585-51a2-414a-8534-94608f4dd7ac",
"name": "Filter Unreplied Reviews2",
"type": "n8n-nodes-base.code",
"position": [
-3856,
-16
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e104828a-4a73-4967-a842-b4adb7f2b064",
"name": "No New Reviews2",
"type": "n8n-nodes-base.code",
"position": [
-3136,
240
],
"parameters": {},
"typeVersion": 2
},
{
"id": "86fc2598-ec31-4b9c-9f65-2dfca7c058fd",
"name": "Split Reviews",
"type": "n8n-nodes-base.splitOut",
"position": [
-3136,
-96
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a3f1b769-afc4-43f3-a83d-43d2c252fc02",
"name": "Has Unreplied Reviews?2",
"type": "n8n-nodes-base.if",
"position": [
-3632,
-16
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9ed5b69b-d1c6-41bf-b759-0c198967ff9f",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1632,
-96
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5658d5f2-75ed-4d58-aee2-cf0bfadb9ba2",
"name": "Get Reviews (Acuyu)",
"type": "n8n-nodes-base.googleBusinessProfile",
"position": [
-4064,
-16
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8bda61d0-ea2d-4d8d-a13c-6e0ae849b881",
"name": "Route Locations",
"type": "n8n-nodes-base.switch",
"position": [
-4416,
-304
],
"parameters": {},
"typeVersion": 3.3
},
{
"id": "2152467a-6f61-4dd0-8c8f-b7c40c1b1624",
"name": "Prepare Data",
"type": "n8n-nodes-base.set",
"position": [
-2752,
-848
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c8921793-3db1-48cd-839b-d8d9c5d0a5ba",
"name": "Update Business Config Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-704,
-928
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "1c2042da-68a0-4d53-a7cc-7af702e3d7fa",
"name": "Log to Business Sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2928,
-96
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "62219b42-4ff1-4948-9ab9-3bc19cfd7deb",
"name": "Prepare Data1",
"type": "n8n-nodes-base.set",
"position": [
-2736,
-96
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "bff7462e-fed1-446a-a44d-4fc98ae5db5b",
"name": "Message a model2",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
-2400,
-96
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c2d62d71-8410-45a2-abbe-a4fdddf49921",
"name": "Post Reply (GMB)1",
"type": "n8n-nodes-base.googleBusinessProfile",
"position": [
-1376,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "32994c39-b989-4980-8b0a-bd5206dbfe68",
"name": "Update Sheet (Success)1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1024,
-80
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "d943e7ca-55ea-43fd-8b02-01fabc6ca04b",
"name": "Update Business Config Sheet1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-800,
-160
],
"parameters": {},
"typeVersion": 4.4
},
{
"id": "5b5b0244-3511-4961-b8fc-2ceb84e3adc2",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5120,
-448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f46ea9fe-75df-46b8-84cf-422deff4bb3d",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4512,
-448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9d405d77-710d-4b21-a404-cc421a2fc0ec",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4112,
-848
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6aba1da9-d658-4791-b1f2-936922968cec",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3280,
-960
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "149eb0fd-5223-40a8-98c9-8abd25defea5",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2528,
-960
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7550f11b-68ea-4fa4-9754-80bf28b7a9de",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1728,
-960
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "43e12ad3-7508-44b0-842f-1933ec88b1eb",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4128,
-144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cf56c598-fc9f-40c1-a445-cb207e2debe6",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3248,
-208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1f5a6237-03ad-473b-a033-cc25c20bdec3",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2512,
-208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9631428f-5025-4db7-ac72-384f75120af2",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1696,
-208
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cd14a2bc-e373-459d-9c56-29e3ece9b411",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5120,
-1024
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"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
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow is designed for digital marketing agencies, local business owners, and reputation management professionals who need to respond to Google My Business reviews promptly and professionally across multiple business locations.
Source: https://n8n.io/workflows/11503/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
AI Institutional Stock Valuation Engine with Risk Scoring & Scenario Targets
Google Sheets, XML, HTTP Request +3
Overview This is a production-grade, fully automated stock analysis system built entirely in n8n. It combines institutional-level financial analysis, dual AI model consensus, and a self-improving back
Google Sheets, XML, HTTP Request +3
This workflow is a complete outbound automation system that discovers local businesses, extracts contact emails, generates personalized cold emails using AI, and runs a multi-step follow-up sequence —
Stop And Error, Google Sheets, HTTP Request +2
A professional AI equity analysis automation built on n8n that transforms structured financial data and real-time news into disciplined, risk-adjusted price targets and actionable BUY/HOLD/SELL signal
Google Sheets, OpenAI, XML +3
This workflow automatically fetches the latest business news, analyzes its impact on clients using AI and sends alerts for high-impact articles while logging all processed data in Google Sheets. It en
HTTP Request, Google Gemini, Gmail +1