Connect Google Sheets with Slack
Workflow Description
An advanced automation template that integrates an intelligent agent with Google Sheets and Slack. It processes incoming data through text segmentation and semantic embeddings, retrieves relevant information from a Supabase vector store, maintains conversational memory for context, and automatically shares results in Slack while updating spreadsheet records.
How it works
- 1.Receive incoming request via webhook and trigger the workflow
- 2.Split incoming text into manageable chunks for efficient processing
- 3.Convert text segments into semantic embeddings using OpenAI
- 4.Search and retrieve relevant information from the vector database
- 5.Process the query using an AI agent powered by Anthropic's language model
- 6.Send results and responses directly to the designated Slack channel
Use cases
- Answer team questions posted in Slack using intelligent analysis of spreadsheet data
- Automate periodic reports by reading Sheets and sending AI-generated summaries to Slack
- Enable intelligent data search with immediate Slack responses to team inquiries
Requirements
- Google Cloud account with active Google Sheets API and write/read permissions
- Slack workspace with application development access and webhook capabilities
- OpenAI API key for embeddings generation and Anthropic API key for language model
- Supabase database instance with vector storage enabled for semantic search
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
Supabase Insert
Vector Store Supabase
Supabase Query
Vector Store Supabase
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