AI Agents
Connect Google Sheets with Slack
12 nodes
208
154
Webhook
Workflow Description
An automation template connecting Google Sheets with Slack using an intelligent agent powered by Anthropic and OpenAI models. It receives data via webhook, processes it through text splitting and vector storage, and automatically sends results to Slack for team collaboration.
How it works
- 1.Receive incoming request through webhook and initiate the workflow
- 2.Split and preprocess text data using character-level text splitter
- 3.Generate vector embeddings via OpenAI with Anthropic model support
- 4.Search Weaviate vector store for semantically related information
- 5.Feed context and conversation memory to the AI agent for reasoning
- 6.Write results to Google Sheets and post summary notification to Slack
Use cases
- Monitor new entries in a spreadsheet and notify teams with AI-powered analysis via Slack
- Process customer inquiries from Slack messages and log intelligent responses in Google Sheets
- Automatically categorize messages and store critical insights in a centralized data sheet
Requirements
- Google Workspace account with edit permissions for Google Sheets
- Slack workspace with bot token for posting and reading messages
- API keys for OpenAI and Anthropic language models
- Configured Weaviate vector database or alternative vector storage solution
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
208
Downloads
154
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