AI Agents
Connect Google Sheets with Slack
12 nodes
211
159
Webhook
Workflow Description
An advanced n8n automation that links Google Sheets with Slack through an AI-powered agent backed by OpenAI. It processes spreadsheet data using Cohere embeddings and Pinecone vector storage, delivering intelligent responses directly to Slack.
How it works
- 1.Receive trigger via webhook and initialize workflow execution
- 2.Extract and parse data from Google Sheets using text splitting
- 3.Convert extracted content to embeddings and store in Pinecone vector database
- 4.Process user queries through OpenAI agent with conversation memory
- 5.Route intelligent responses to designated Slack channels
Use cases
- Enable teams to query business data stored in Google Sheets through Slack conversations
- Automate data summarization and analysis delivery to team channels for real-time insights
Requirements
- Active OpenAI API account with sufficient credits
- Pinecone vector database instance configured
- Google Sheets access permissions and Slack bot token
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
211
Downloads
159
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
OpenAI
RAG Agent
Agent
Append Sheet
Google Sheets
Slack Alert
Slack