Natural language Google Sheets data analysis with Gemini AI

by Robert Breen ✓ · 1,906 views · created 2025-08-15 · Document Extraction, Multimodal AI

What this workflow does

This AI workflow has 18 nodes and runs when another workflow calls it. Along the way it connects Google Gemini Chat Model and Google Sheets.

How it runs

Trigger: When another workflow calls it.

1. Get Data (Google Sheets): uses Google Sheets
2. Type of Aggregation (Switch): routes items into 6 branches
3. Count Unique (Summarize): summarizes / groups the items
4. Sum (Summarize): summarizes / groups the items
5. Average (Summarize): summarizes / groups the items
6. Min (Summarize): summarizes / groups the items
7. Max (Summarize): summarizes / groups the items
8. Count (Summarize): summarizes / groups the items
9. Bring All Data together (Aggregate): combines items into one
10. Write into Table Output (AI Agent): runs an AI agent, with model: Google Gemini Chat Model

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

Services it uses

Google Gemini Chat ModelGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (11)

• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Google Sheets Tooln8n-nodes-base.googleSheetsTool
• Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
• AI Agent@n8n/n8n-nodes-langchain.agent
• Execute Sub-workflown8n-nodes-base.executeWorkflow
• Google Sheetsn8n-nodes-base.googleSheets
• Switchn8n-nodes-base.switch
• Aggregaten8n-nodes-base.aggregate
• Summarizen8n-nodes-base.summarize

From the author

This n8n workflow template creates an efficient data analysis system that uses Google Gemini AI to interpret user questions about spreadsheet data and processes them through a specialized sub-workflow for optimized token usage and faster responses. What This…

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