AI Agents
Connect Google Sheets with Slack
12 nodes
228
151
Webhook
Workflow Description
Intelligent automation that connects Google Sheets with Slack through an AI agent understanding natural language queries and retrieving relevant data from spreadsheets while maintaining conversation context across sessions.
How it works
- 1.Receive the request via webhook and split text into processable chunks
- 2.Convert chunks into numerical embeddings and store them in Weaviate vector store
- 3.Activate OpenAI agent that queries relevant data and maintains conversation history
- 4.Fetch matching data from Google Sheets using vector search tool
- 5.Send results and answers to Slack
Use cases
- Answer employee questions about spreadsheet data directly in Slack
- Organize and document large data operations through natural conversations
- Extract specific information from complex tables without direct access
Requirements
- API keys from OpenAI, Cohere, and Weaviate
- Google Sheets spreadsheet exposed to programmatic access
- Slack channel with message posting permissions for n8n app
- Accessible webhook URL for external triggering
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Text Splitter
Embeddings
Vector Store
Memory
OpenAI
AI Agent
Google Sheets
Slack
Details
Trigger
Webhook
Nodes
12
Apps
8
Views
228
Downloads
151
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
Weaviate Insert
Vector Store Weaviate
Weaviate Query
Vector Store Weaviate
Vector Tool
Tool Vector Store
Window Memory
Memory Buffer Window
Chat Model
OpenAI
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack