AI Agents
Analyze Google Sheets data and send intelligent summaries to Slack
12 nodes
242
161
Webhook
Workflow Description
This automation receives requests via webhook, analyzes Google Sheets content using an AI agent powered by OpenAI, stores information in a Supabase vector database for intelligent retrieval, and sends summaries and responses directly to Slack channels. The system maintains conversation memory for contextual understanding.
How it works
- 1.Receive webhook request and split long texts from Google Sheets data
- 2.Embed data with OpenAI and store in Vector Store for semantic search
- 3.Execute an AI agent that uses contextual memory to answer questions
- 4.Send generated results and summaries to Slack automatically
Use cases
- Answer team questions about large spreadsheet data without manual searching
- Automate daily reports from Google Sheets and distribute to relevant Slack channels
- Create an intelligent assistant that understands context and learns from conversation history
Requirements
- Google Workspace account with permissions to access and modify Google Sheets
- OpenAI API keys and Supabase configuration for vector storage and retrieval
- Slack workspace with configured n8n app or webhook integration
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
242
Downloads
161
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