AI Agents
Automate Google Sheets
11 nodes
222
162
Webhook
Workflow Description
An intelligent automation triggered via webhook that processes text data, stores it in a vector database, and retrieves it to automatically populate Google Sheets using an AI agent powered by Claude.
How it works
- 1.Receive webhook request and split texts into processable chunks
- 2.Convert texts to vector embeddings using Hugging Face model
- 3.Store vectors in Supabase while maintaining conversation history
- 4.Query the AI agent for relevant data from Vector Store
- 5.Process results through Claude and insert them into Google Sheets automatically
Use cases
- Manage large text databases and organize them automatically in Google Sheets
- Build an intelligent search system that retrieves relevant information and populates sheets in real-time
- Automate report generation based on stored data with immediate updates
Requirements
- Active Google Cloud account with Google Sheets modification permissions
- Valid API key for Anthropic Claude
- Supabase database configured with Vector Store tables
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
222
Downloads
162
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 Hugging Face
Insert
Vector Store Supabase
Query
Vector Store Supabase
Tool
Tool Vector Store
Memory
Memory Buffer Window
Chat
Lm Chat Anthropic
Agent
Agent
Sheet
Google Sheets