AI Agents
Intelligent analysis of Google Sheets data with automatic Slack reporting
12 nodes
286
177
Webhook
Workflow Description
An automation that receives webhook requests, processes Google Sheets data using text embedding and vectorization, stores information in a vector database, and employs an AI agent powered by OpenAI to analyze queries intelligently and send insights to Slack channels in real time.
How it works
- 1.Receive webhook request and initialize conversation memory
- 2.Convert spreadsheet data into numeric vectors using Cohere embeddings and store in Supabase
- 3.Process user queries with an AI agent using OpenAI's language model
- 4.Search the vector database and retrieve relevant information
- 5.Format and send automated responses to designated Slack channels
Use cases
- Answer team questions about centralized spreadsheet data instantly
- Generate automated summaries and reports delivered to Slack channels daily
Requirements
- OpenAI API key and Cohere account credentials
- Google Workspace account with spreadsheet editing permissions
- Slack workspace with message posting and channel creation rights
- Supabase database instance 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
286
Downloads
177
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