AI Agents
Connect Google Sheets with Slack
12 nodes
249
153
Webhook
Workflow Description
An intelligent automation workflow that connects Google Sheets with Slack through an AI agent powered by OpenAI. The webhook receives data, processes it using text splitting and vector embeddings, stores knowledge in Supabase, and sends automated updates to Slack channels with contextual summaries.
How it works
- 1.Receive incoming data via Webhook and buffer it temporarily
- 2.Split and vectorize text content using OpenAI Embeddings service
- 3.Search the vector database (Supabase) and retrieve relevant records
- 4.Process queries with an intelligent agent backed by persistent memory
- 5.Update Google Sheets with new data or query results
- 6.Send summaries and responses to designated Slack channels instantly
Use cases
- Automatic alerts when critical data changes in shared spreadsheets
- Intelligent assistant answering team questions based on indexed sheet data
- Scheduled smart reports pushed daily to Slack project channels
Requirements
- Valid OpenAI API key with embeddings model access
- Authorized connections to Google Sheets and Slack workspaces
- Supabase vector database configured and indexed
- Pre-created Slack channels designated for automated messages
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
249
Downloads
153
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
Supabase Insert
Vector Store Supabase
Supabase Query
Vector Store Supabase
Vector Tool
Tool Vector Store
Window Memory
Memory Buffer Window
Chat Model
OpenAI
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack