AI Agents
Connect Google Sheets with Slack
12 nodes
228
179
Webhook
Workflow Description
An intelligent automation template connecting Google Sheets with Slack through an AI agent powered by OpenAI. It receives requests via webhook, processes data using embeddings and vector storage, maintains conversation memory, and automatically sends results to Slack channels for team collaboration and data-driven decision-making.
How it works
- 1.Trigger workflow via webhook and initialize the request pipeline
- 2.Split and embed text content using OpenAI models
- 3.Store and retrieve data vectors in Weaviate database
- 4.Process queries through intelligent agent with contextual memory
- 5.Read and update data in Google Sheets dynamically
- 6.Send results and notifications directly to Slack channels
Use cases
- Monitor spreadsheet changes and send instant alerts to team Slack channels
- Search sheet content intelligently and answer queries automatically
- Automate data extraction from sheets and share insights across teams
- Build a smart support system combining company data with conversational AI
Requirements
- Valid OpenAI API key for language models and embedding generation
- Authenticated Google Sheets connection with read and write permissions
- Slack workspace token with message posting authorization for target channels
- Running Weaviate instance for stable vector storage and retrieval
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
228
Downloads
179
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