AI Agents
Automate Google Sheets
11 nodes
228
147
Webhook
Workflow Description
An advanced automation template combining an intelligent agent powered by Anthropic and OpenAI models to process data, store it vectorially, and automatically update Google Sheets when webhook requests arrive.
How it works
- 1.Receive webhook request and route it to the intelligent agent
- 2.Split long texts using Text Splitter and generate embeddings via OpenAI
- 3.Store vectors in Redis and maintain conversation context in buffer memory
- 4.Process queries using Anthropic model and vector-based search
- 5.Write results and intelligent responses to Google Sheets tables
Use cases
- Automate smart inquiry handling and save results directly to Sheets
- Build an intelligent document archive system with vector search capabilities
- Aggregate answers from multiple sources and organize them in spreadsheets
Requirements
- Valid API keys from OpenAI and Anthropic
- Active Redis connection for vector storage
- Google Sheets authentication configured in n8n
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Text Splitter
OpenAI
Vector Store
Memory
Anthropic
AI Agent
Google Sheets
Details
Trigger
Webhook
Nodes
11
Apps
7
Views
228
Downloads
147
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
OpenAI
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