AI Agents

Analyze Google Sheets data and send insights to Slack via AI

12 nodes 318 170 Webhook
Download

Workflow Description

Webhook-triggered automation that ingests Google Sheets data, processes it through text splitting and AI embeddings, stores vectors in Supabase, and uses an intelligent agent to extract insights and deliver them to Slack automatically.

How it works

  1. 1.Receive data from Google Sheets via webhook trigger
  2. 2.Split and process text content using Text Splitter
  3. 3.Generate embeddings with OpenAI for semantic understanding
  4. 4.Store vectors in Supabase Vector Store for retrieval
  5. 5.Query data with AI Agent and memory buffer for context
  6. 6.Send analyzed results and summaries to Slack channel

Use cases

  • Alert sales teams about performance metrics from spreadsheets
  • Route customer reports to support teams with AI-generated summaries

Requirements

  • Google Workspace account with Google Sheets access
  • OpenAI and Supabase API keys
  • 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 OpenAI Vector Store Memory AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 7
Views 318
Downloads 170

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