Query Google Sheets data and send AI-powered analysis to Slack
Workflow Description
An automation that receives requests via webhook, analyzes Google Sheets data using an intelligent agent powered by Anthropic and OpenAI models, and delivers insights directly to Slack channels. It combines text processing, semantic search with vector embeddings, and contextual memory to provide smart, conversational responses.
How it works
- 1.Receive webhook request and transform it into a processing task
- 2.Split Google Sheets content into manageable text chunks for analysis
- 3.Perform semantic search using Vector Store and OpenAI embeddings to locate relevant data
- 4.Run intelligent agent that reviews context and formulates response
- 5.Send analysis results to designated Slack channel
Use cases
- Answer employee questions about sales data, reports, and company metrics stored in shared spreadsheets
- Automatically summarize project updates and critical data points for team distribution on Slack
Requirements
- Active Google Sheets account with accessible data to query and analyze
- Valid API keys for OpenAI, Anthropic, and Pinecone account for vector storage and retrieval
- Slack workspace with bot token and permissions to send messages to target channels
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
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
Pinecone Insert
Vector Store Pinecone
Pinecone Query
Vector Store Pinecone
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