AI Agents
Analyze Google Sheets data and send intelligent summaries to Slack
12 nodes
291
155
Webhook
Workflow Description
Automation that receives data from Google Sheets via webhook, processes it through an AI agent powered by Anthropic and OpenAI models, stores embeddings in Weaviate, and sends analyzed results and alerts to Slack channels automatically.
How it works
- 1.Receive incoming data from Google Sheets through webhook trigger
- 2.Split and process text content using Character Text Splitter
- 3.Generate embeddings with OpenAI and store in Weaviate vector database
- 4.Retrieve relevant information from vector store using similarity search
- 5.Analyze data using AI agent with Anthropic and OpenAI language models
- 6.Send analysis results and insights to designated Slack channels
Use cases
- Analyze sales data stored in spreadsheets and deliver AI-powered summaries to sales teams
- Process customer feedback and support tickets from sheets with automated Slack notifications
- Monitor KPIs and performance metrics with intelligent alerts sent to team channels
Requirements
- Google Workspace account with Google Sheets API access enabled
- Slack workspace with configured channels for message delivery
- OpenAI and Anthropic API keys configured
- Weaviate vector database instance set up and accessible
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
291
Downloads
155
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
Weaviate Insert
Vector Store Weaviate
Weaviate Query
Vector Store Weaviate
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