AI Agents
Analyze Google Sheets data and send intelligent summaries to Slack
12 nodes
338
145
Webhook
Workflow Description
Webhook-triggered automation that processes Google Sheets data through an AI Agent, transforms information into vector embeddings for semantic search, maintains conversation memory, and delivers actionable summaries directly to Slack channels in real time.
How it works
- 1.Receive webhook request and split incoming text into manageable chunks
- 2.Generate embeddings using OpenAI and store vectors in Weaviate database
- 3.Initialize AI Agent with memory context and vector search capabilities
- 4.Query sheets data and use AI to extract relevant insights and patterns
- 5.Process responses with language model for natural message formatting
- 6.Send analyzed results and summaries to Slack automatically
Use cases
- Alert sales team of new opportunities from spreadsheets in designated Slack channels
- Generate and send AI-powered financial reports from tracked metrics directly to stakeholders
Requirements
- Active API keys for OpenAI, Google Sheets integration, and Slack workspace access
- Structured Google Sheets with source data properly organized and formatted
- Webhook endpoint configured and Slack channel permissions established
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
AI Agent
Google Sheets
Slack
Details
Trigger
Webhook
Nodes
12
Apps
7
Views
338
Downloads
145
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 (12)
/
Sticky Note
Sticky Note
Webhook Trigger
Webhook
Text Splitter
Text Splitter Character Text Splitter
Embeddings
OpenAI
Weaviate Insert
Vector Store Weaviate
Weaviate Query
Vector Store Weaviate
Vector Tool
Tool Vector Store
Window Memory
Memory Buffer Window
Chat Model
OpenAI
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack