Easily compare using OpenAI and Google Sheets
Workflow Description
An advanced automation template that combines an AI agent with Google Sheets to automatically compare and analyze data. It receives inquiries through a chat interface, processes them in batches, maintains context in memory, and records comparison results in spreadsheets with full audit trails.
How it works
- 1.Receive comparison requests via chat trigger interface
- 2.Partition incoming data into batches for parallel processing
- 3.Retrieve and load prior conversation context from memory buffer
- 4.Execute AI agent to perform data comparison and analysis
- 5.Aggregate results and generate summaries of comparisons
- 6.Write validated comparison results to Google Sheets
Use cases
- Compare products, prices, and specifications across multiple sources with automatic spreadsheet updates
- Analyze historical data and customer feedback while maintaining conversation context across multiple sessions
Requirements
- Valid API key for OpenAI or compatible language model provider via Open Router
- Google account with read and write access to target Google Sheets
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