AI Agents
Connect Google Sheets with Slack
12 nodes
207
153
Webhook
Workflow Description
An intelligent agent automation that integrates Google Sheets with Slack, processing sheet data through text splitting and vector embeddings, storing it in a vector database, and enabling smart querying and answering questions about spreadsheet content directly through Slack.
How it works
- 1.Receive the webhook request and route it to the intelligent agent
- 2.Split Google Sheets text content into manageable chunks using Text Splitter
- 3.Convert chunks into vector embeddings using Cohere embeddings service
- 4.Store vectors in Supabase Vector Store for efficient retrieval
- 5.Handle queries and maintain conversation context with Memory Buffer Window
- 6.Execute search logic through OpenAI Chat and deliver results to Slack
Use cases
- Enable teams to query Google Sheets data conversationally through Slack without opening files
- Build a smart bot that searches spreadsheets and presents information in natural language
- Automate data extraction and report generation from company sheets to Slack channels
Requirements
- Google Cloud account with Google Sheets API access enabled
- Slack workspace with bot creation and webhook permissions
- OpenAI API key for language model access
- Supabase account with Vector Store enabled and configured
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
207
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
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