AI Agents
Extract data from Google Sheets and send intelligent insights to Slack
12 nodes
317
167
Webhook
Workflow Description
Automation receives data via webhook, processes it through natural language techniques (text splitting and embeddings), stores vectors in a database, then deploys an AI agent powered by OpenAI to query Google Sheets, generate insights, and deliver them directly to Slack channels.
How it works
- 1.Receive data through webhook and temporarily buffer it
- 2.Split texts and compute embeddings using Cohere, then store them in Weaviate
- 3.Activate an AI agent that queries the vector store and connects to Google Sheets
- 4.Process intelligent queries and generate responses via OpenAI
- 5.Send results and insights to specified Slack channels
Use cases
- Automatically send sheet data reports to Slack channels
- Answer employee questions about sheet data directly in Slack
- Monitor Google Sheets updates and notify the team instantly
Requirements
- Active Google Workspace account with Sheets access permissions
- Slack workspace with Bot permissions for messaging
- API keys from OpenAI and Cohere
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Text Splitter
Embeddings
Vector Store
Memory
OpenAI
AI Agent
Google Sheets
Slack
Details
Trigger
Webhook
Nodes
12
Apps
8
Views
317
Downloads
167
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
Embeddings Cohere
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