Compare AI Model Responses and Store Results in Google Sheets
Workflow Description
Automation that receives queries through a chat interface, processes them using multiple AI models via OpenRouter, and stores comparison results in Google Sheets. Batches incoming data, manages memory efficiently, and aggregates responses for easy analysis and documentation.
How it works
- 1.Receive query input through the active chat trigger interface
- 2.Process incoming data in batches and store in temporary memory buffer
- 3.Send queries to multiple AI models for parallel comparison
- 4.Summarize and aggregate results from all model responses
- 5.Save final comparisons to Google Sheets for review and analysis
Use cases
- Compare outputs from different AI models on identical prompts to evaluate quality
- Benchmark AI model performance and document results for continuous improvement
Requirements
- OpenRouter account with valid API key for multi-model access
- Active Google Sheets document with write permissions configured
- Chat interface enabled and connected to receive user inputs
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (21)
When chat message received
Chat Trigger
Loop Over Items
Split In Batches
Simple Memory
Memory Buffer Window
Chat Memory Manager
Memory Manager
Sticky Note
Sticky Note
OpenRouter Chat Model
Lm Chat Open Router
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Set model, sessionId, chatInput, sessionIdBase
Set
AI Agent
Agent
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Concatenate Chat Answers
Summarize
Sticky Note6
Sticky Note
Group Model Outputs for Evaluation
Aggregate
Add Model Results to Google Sheet
Google Sheets
Prepare Data for Chat and Google Sheets
Set
Define Models to Compare
Set
Split Models into Items
Split Out
Set Output for Chat UI
Set