AI Agents
Analyze Google Sheets data and answer questions via Slack AI agent
12 nodes
311
174
Webhook
Workflow Description
Intelligent automation connecting Google Sheets with Slack using an AI agent that understands queries, extracts and analyzes data automatically, storing context for accurate responses across conversations.
How it works
- 1.Receive queries from Slack through a webhook trigger
- 2.Split and process text into indexed, understandable segments
- 3.Generate embeddings to understand query meaning using OpenAI
- 4.Search stored Google Sheets data in the vector database
- 5.Analyze information using an AI agent powered by Anthropic
- 6.Send results and insights back to the Slack channel
Use cases
- Answer sales reports and KPI questions directly from Slack without opening spreadsheets
- Track performance metrics and alert when thresholds are exceeded
- Analyze historical data and trends through natural conversation
Requirements
- Google Workspace account with spreadsheet editing permissions
- Slack workspace with bot app authorization
- API keys for OpenAI and Anthropic services
- Well-organized data in Google Sheets
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
Slack
Details
Trigger
Webhook
Nodes
12
Apps
8
Views
311
Downloads
174
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
Lm Chat Anthropic
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack