AI Agents
Connect Google Sheets with Slack
12 nodes
215
158
Webhook
Workflow Description
An automation template connecting Google Sheets with Slack through an intelligent agent powered by Anthropic. Receives data via webhook, processes it using advanced AI embeddings and vector search, maintains conversation history, and delivers results directly to Slack channels.
How it works
- 1.Receive incoming data through webhook trigger and initialize workflow
- 2.Split text content into manageable chunks for processing
- 3.Generate embeddings and perform semantic search in Pinecone vector database
- 4.Execute AI agent logic using Anthropic model with memory context
- 5.Retrieve and process data from specified Google Sheets
- 6.Send formatted results and agent responses to designated Slack channels
Use cases
- Analyze spreadsheet data automatically and notify teams of insights via Slack
- Build intelligent Q&A system for employees querying spreadsheet information in Slack
- Generate smart reports from Google Sheets and distribute them across team channels
Requirements
- Google Workspace account with Google Sheets API access and permissions
- Slack workspace account with permissions to post messages to channels and users
- Anthropic API key and active Pinecone vector database instance
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
215
Downloads
158
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