AI Agents
Automate Google Sheets
11 nodes
225
159
Webhook
Workflow Description
An intelligent automation template combining AI Agent with Google Sheets, receiving data via webhook, processing text splitting and embeddings, storing in Redis vector store, and writing results directly to spreadsheets.
How it works
- 1.Receive webhook request and route to AI Agent
- 2.Split incoming texts and compute embeddings using Cohere
- 3.Store embedded data in Redis vector store for fast retrieval
- 4.Process queries and maintain context using Anthropic model
- 5.Write results and responses to Google Sheets automatically
Use cases
- Analyze lengthy documents and insert summaries into work spreadsheets
- Search stored data intelligently and retrieve relevant information
- Automate form and survey processing with results saved to Sheets
Requirements
- API keys for Anthropic and Cohere services
- Active Redis database connection
- Sufficient write permissions to Google Sheets
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Text Splitter
Embeddings
Vector Store
Memory
Anthropic
AI Agent
Google Sheets
Details
Trigger
Webhook
Nodes
11
Apps
7
Views
225
Downloads
159
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 Redis
Query
Vector Store Redis
Tool
Tool Vector Store
Memory
Memory Buffer Window
Chat
Lm Chat Anthropic
Agent
Agent
Sheet
Google Sheets