AI Agents
Intelligent Data Retrieval from Google Sheets to Slack
12 nodes
340
174
Webhook
Workflow Description
An automation that receives data via webhook, processes it through text segmentation and embeddings, stores vectors in a database, and employs an AI agent powered by Claude to understand natural queries, retrieve data from Google Sheets, and deliver responses directly to Slack channels.
How it works
- 1.Receive incoming data through webhook and buffer in memory
- 2.Split text content and convert to numerical embeddings via Cohere
- 3.Index embeddings in Pinecone vector store for semantic search
- 4.Process user queries using Claude-powered AI agent
- 5.Fetch relevant data from Google Sheets based on semantic understanding
- 6.Post results and answers to designated Slack channels
Use cases
- Enable employees to ask natural language questions about data stored in Sheets without leaving Slack
- Automate FAQ responses and expedited database searches without manual intervention
Requirements
- Active Anthropic Claude API subscription with function calling capabilities
- API keys for Cohere, Pinecone, Google Sheets, and an approved Slack bot application
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Text Splitter
Embeddings
Vector Store
Memory
Anthropic
AI Agent
Google Sheets
Slack
Details
Trigger
Webhook
Nodes
12
Apps
8
Views
340
Downloads
174
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
Lm Chat Anthropic
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack