AI Agents
Connect Google Sheets with Slack
12 nodes
207
147
Webhook
Workflow Description
An automation template that integrates Google Sheets with Slack using an AI agent powered by advanced language models. It receives requests via webhook, processes them through text splitting and embeddings, stores them in a vector database, and automatically answers user inquiries on Slack.
How it works
- 1.Receive incoming requests through webhook and route them to the AI agent
- 2.Split long texts and convert them into numerical embeddings via OpenAI
- 3.Store embeddings in Supabase vector database and retrieve relevant information
- 4.Process user queries using Anthropic model with conversation memory
- 5.Fetch corresponding data from Google Sheets based on query results
- 6.Send responses back to the designated Slack channel
Use cases
- Automatically answer employee questions about company data stored in Google Sheets
- Create a smart Slack assistant that responds to questions based on spreadsheet content
Requirements
- Active Google Sheets account with data-rich spreadsheets for reference
- API keys for OpenAI, Anthropic, 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
OpenAI
Vector Store
Memory
Anthropic
AI Agent
Google Sheets
Slack
Details
Trigger
Webhook
Nodes
12
Apps
8
Views
207
Downloads
147
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
Lm Chat Anthropic
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack