AI Agents
Analyze Google Sheets data and send intelligent insights to Slack
12 nodes
348
177
Webhook
Workflow Description
An automation that receives requests via webhook, processes Google Sheets data using OpenAI models, stores data in Pinecone vector database, and delivers intelligent analysis and summaries to Slack automatically with memory persistence.
How it works
- 1.Receive incoming webhook request
- 2.Split and embed text data using Cohere embeddings
- 3.Search vector store for relevant information
- 4.Process query with AI Agent using OpenAI
- 5.Retrieve rows from Google Sheets
- 6.Send analyzed results to Slack channel
Use cases
- Daily automated reports from spreadsheet data delivered to Slack with AI-generated insights
- Real-time answers to team questions about company data stored in Google Sheets
Requirements
- Google Workspace account with Sheets editing permissions
- Active OpenAI API key with sufficient credits
- Pinecone account with configured vector database
- Slack workspace with bot app installed and message permissions
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
348
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
Pinecone Insert
Vector Store Pinecone
Pinecone Query
Vector Store Pinecone
Vector Tool
Tool Vector Store
Window Memory
Memory Buffer Window
Chat Model
OpenAI
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack