AI Agents
Connect Google Sheets with Slack
12 nodes
230
155
Webhook
Workflow Description
An intelligent automation that connects Google Sheets and Slack using an OpenAI-powered agent. It processes data through embeddings and vector storage for advanced semantic search, delivering contextual answers directly in Slack channels.
How it works
- 1.Receive incoming webhook requests and transform them into actionable tasks
- 2.Split data content using text processing and generate embeddings for semantic understanding
- 3.Query Vector Store to locate relevant data from Google Sheets
- 4.Invoke OpenAI agent to formulate responses with preserved conversation context
- 5.Deliver final results to designated Slack channels
Use cases
- Answer employee questions about company data stored in spreadsheets instantly
- Perform semantic searches on large datasets to retrieve specific information on demand
Requirements
- Active OpenAI API key and Google Sheets account with read access
- Slack workspace with message posting permissions and Supabase account for vector 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
230
Downloads
155
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
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