AI Agents
Connect Google Sheets with Slack
12 nodes
232
149
Webhook
Workflow Description
An intelligent automation that connects Google Sheets with Slack using an AI agent to understand content, extract relevant data from spreadsheets, and deliver targeted messages to Slack channels based on natural language queries.
How it works
- 1.Receive webhook request and pass it to the AI agent
- 2.Process and split text using Character Text Splitter algorithm
- 3.Generate embeddings and compare against Weaviate Vector Store
- 4.Execute semantic search for relevant rows and columns in Google Sheets
- 5.Invoke Slack API and dispatch results to designated channels
- 6.Maintain conversation context via Memory Buffer Window
Use cases
- Automatically send summarized reports from spreadsheets to sales team
- Answer employee queries about updated spreadsheet data directly in Slack
- Trigger smart alerts when specific metrics exceed predefined thresholds
Requirements
- OpenAI API key for running the AI agent
- Google Sheets and Slack OAuth credentials
- Connected Weaviate database instance for embeddings storage
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
232
Downloads
149
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