Connect Google Sheets with Slack
Workflow Description
An intelligent automation that bridges Google Sheets with Slack by receiving requests through a webhook. The AI Agent, powered by OpenAI and Anthropic, processes data using text splitting and vector storage in Weaviate, then reads, updates, and analyzes spreadsheets before delivering results directly to Slack channels with contextual intelligence.
How it works
- 1.Receive webhook requests and route them to the AI Agent
- 2.Process and split text using OpenAI and Anthropic embeddings
- 3.Store and retrieve processed data from Weaviate vector database
- 4.Access and update Google Sheets data based on agent decisions
- 5.Send analyzed results and summaries to designated Slack channels
Use cases
- Monitor new spreadsheet updates and instantly notify teams via Slack notifications
- Automatically analyze large datasets and generate intelligent summaries before team distribution
- Answer recurring questions and document findings based on spreadsheet content automatically
Requirements
- Active Google Sheets account with API access enabled
- Slack workspace with bot permissions configured
- OpenAI and Anthropic API keys with sufficient credits
- Deployed Weaviate vector database instance
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
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