AI Agents

Query Google Sheets and send insights to Slack with AI

12 nodes 270 176 Webhook
Download

Workflow Description

Deploy an intelligent agent that receives requests via webhook, processes Google Sheets data through embeddings and semantic search, retrieves relevant information from a vector database, and delivers AI-generated responses directly to Slack channels.

How it works

  1. 1.Receive incoming webhook request and route to the AI agent
  2. 2.Split and embed Google Sheets content into Supabase vector store
  3. 3.Query relevant data from the vector store using semantic similarity
  4. 4.Process the query through OpenAI's language model with conversation memory
  5. 5.Send formatted response to designated Slack channel

Use cases

  • Answer team questions about spreadsheet data in real-time via Slack messages
  • Automatically extract and summarize reports from Google Sheets and post to team channels

Requirements

  • Google Sheets account with read access credentials
  • OpenAI and Cohere API keys with active subscriptions
  • Supabase database with vector store enabled and Slack app with message posting permissions

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 270
Downloads 176

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (12)

/

Sticky Note

Sticky Note

#1

Webhook Trigger

Webhook

#2

Text Splitter

Text Splitter Character Text Splitter

#3

Embeddings

Embeddings Cohere

#4

Supabase Insert

Vector Store Supabase

#5

Supabase Query

Vector Store Supabase

#6

Vector Tool

Tool Vector Store

#7

Window Memory

Memory Buffer Window

#8

Chat Model

OpenAI

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12