Automate Google My Business responses with Gemini AI and Google Sheets tracking

by Malik Hashir ✓ · 325 views · created 2025-12-04 · Ticket Management, AI Summarization

What this workflow does

This AI workflow has 31 nodes and runs on a schedule (every day). Along the way it connects Google Sheets, Google Business Profile and Google Gemini.

How it runs

Trigger: On a schedule (every day).

1. Get Business Configs (Google Sheets): uses Google Sheets
2. Route Locations (Switch): routes items into branches
3. Get Reviews (Digital Scalers) (Google Business Profile): uses Google Business Profile
4. Get Reviews (Acuyu) (Google Business Profile): uses Google Business Profile
5. Filter Unreplied Reviews (Code): runs custom JavaScript code
6. Filter Unreplied Reviews (Code): runs custom JavaScript code
7. Has Unreplied Reviews? (If): checks a condition and branches into true / false
8. Has Unreplied Reviews? (If): checks a condition and branches into true / false
9. Split Reviews (Split Out): splits a list into separate items
10. No New Reviews (Code): runs custom JavaScript code

…plus 20 more steps. See the full node list below.

Services it uses

Google SheetsGoogle Business ProfileGoogle Gemini

Before you upgrade to n8n 3.0

Nodes used (10)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Google Business Profilen8n-nodes-base.googleBusinessProfile
• Coden8n-nodes-base.code
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Split Outn8n-nodes-base.splitOut
• Ifn8n-nodes-base.if
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Switchn8n-nodes-base.switch
• Edit Fields (Set)n8n-nodes-base.set

From the author

Purpose & Audience 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.…

View the original on n8n.io → Check your own copy