AI Agents
Analyze Data with AI and Auto-Update Google Sheets
11 nodes
293
190
Webhook
Workflow Description
Intelligent automation that receives requests via webhook, processes text through splitting and embeddings, stores data in a vector database, then uses an AI agent to answer questions and automatically log results in Google Sheets. Combines semantic search with conversational AI for data-driven workflows.
How it works
- 1.Receive request via webhook and trigger the workflow
- 2.Split long texts and compute embeddings using Cohere's service
- 3.Store vectorized data in Supabase and maintain conversation history
- 4.Activate AI agent to search knowledge base and generate answers
- 5.Write results and responses directly to Google Sheets
Use cases
- Process large document collections and organize insights automatically into spreadsheets
- Auto-answer customer inquiries based on your knowledge base and log conversations
- Build intelligent search system connecting stored data with customer questions
Requirements
- Active Google Sheets account with write permissions
- Cohere API key for text embeddings
- Supabase database with vector storage enabled
- HuggingFace language model or API key for LM Chat integration
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Text Splitter
Embeddings
Vector Store
Memory
Lm Chat Hf
AI Agent
Google Sheets
Details
Trigger
Webhook
Nodes
11
Apps
7
Views
293
Downloads
190
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 (11)
/
Sticky
Sticky Note
Webhook
Webhook
Splitter
Text Splitter Character Text Splitter
Embeddings
Embeddings Cohere
Insert
Vector Store Supabase
Query
Vector Store Supabase
Tool
Tool Vector Store
Memory
Memory Buffer Window
Chat
Lm Chat Hf
Agent
Agent
Sheet
Google Sheets