AI Agents
Intelligent Google Sheets Analysis and Slack Reporting
12 nodes
284
171
Webhook
Workflow Description
An automation that receives queries via webhook, processes Google Sheets data using AI agents, and delivers insights directly to Slack. Combines vector search and conversation memory for contextual, accurate responses about your sheet data.
How it works
- 1.Receive query request via webhook and split content into processable chunks
- 2.Convert data to vector embeddings and store in Weaviate vector database
- 3.Send query to AI agent with conversation history and memory context
- 4.Retrieve relevant data from Google Sheets and analyze with OpenAI GPT model
- 5.Send formatted analysis results to Slack channel or user thread
Use cases
- Answer team questions about project status and budget data stored in sheets in real time
- Automatically analyze sales and performance reports and send daily summaries to Slack
- Search employee databases and company resources intelligently via natural language questions
Requirements
- Active OpenAI account with valid API key and sufficient credits
- Organized Google Sheets with clear structure and proper sharing permissions
- Slack workspace with app installation rights and channel write permissions
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
284
Downloads
171
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