AI Agents
Query Google Sheets and deliver intelligent answers to Slack
12 nodes
294
183
Webhook
Workflow Description
An automation that receives webhook requests, processes data from Google Sheets using OpenAI's AI models, and sends contextual responses to Slack channels. It combines text processing, semantic embeddings, and vector search to understand data deeply and retrieve the most relevant information before responding.
How it works
- 1.Receive incoming webhook request and store it in buffer memory
- 2.Split and process text into searchable segments using Cohere embeddings
- 3.Query Pinecone vector database to find relevant Google Sheets data
- 4.Execute AI agent to analyze the query and generate an informed response
- 5.Send the final result to the designated Slack channel
Use cases
- Enable instant answers to employee questions about project data stored in Google Sheets
- Automatically summarize weekly sales reports and push key insights to management via Slack
- Search large databases intelligently and reply to inquiries without manual intervention
Requirements
- Active OpenAI account with valid API key configured
- Authorized connection between n8n and Google Workspace account
- Pinecone vector database pre-populated with Cohere embeddings
- Slack app with write permissions on target channels
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
294
Downloads
183
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