AI Agents
Connect Google Sheets with Slack
12 nodes
207
138
Webhook
Workflow Description
An intelligent automation that connects Google Sheets with Slack through an AI agent processing data and extracting relevant information using embeddings and contextual memory, then automatically sending summaries and alerts to designated Slack channels.
How it works
- 1.Receive data from Google Sheets via webhook trigger
- 2.Process and split text content using Text Splitter node
- 3.Generate embeddings with OpenAI and store them in Pinecone vector database
- 4.Run AI agent powered by Anthropic Claude for intelligent search and extraction
- 5.Send results and summaries to Slack channels
Use cases
- Send automatic alerts when important spreadsheet data is updated
- Extract specific information from large datasets and deliver as daily summaries
- Perform intelligent searches across historical data and answer team queries
- Monitor key performance indicators and alert when thresholds are exceeded
Requirements
- Connected Google Sheets account in n8n
- Slack workspace with channel write permissions
- API keys for OpenAI and Anthropic services
- Pinecone account for vector storage and retrieval
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
207
Downloads
138
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