AI Agents

Intelligent Data Analysis from Sheets to Slack

12 nodes 282 139 Webhook
Download

Workflow Description

Automate data extraction from Google Sheets with AI-powered analysis and direct Slack delivery. This workflow processes spreadsheet data through embeddings and vector search, enabling your team to receive actionable insights instantly without manual oversight.

How it works

  1. 1.Receive Google Sheets data through webhook trigger
  2. 2.Split and vectorize content using OpenAI embeddings
  3. 3.Query relevant information from Supabase vector store
  4. 4.Process queries with intelligent agent using contextual memory
  5. 5.Send analyzed results and recommendations to Slack channels

Use cases

  • Monitor daily KPIs and alert teams about critical deviations automatically
  • Analyze sales reports in real-time and extract key trends for stakeholders
  • Answer team queries about spreadsheet data with instant intelligent responses
  • Aggregate multi-sheet data and deliver comprehensive periodic reports

Requirements

  • Google Workspace account with Google Sheets access
  • Slack workspace with app installation permissions
  • OpenAI API keys configured
  • Supabase database connection credentials

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Text Splitter OpenAI Vector Store Memory AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 7
Views 282
Downloads 139

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

OpenAI

#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