AI Agents

Intelligent Spreadsheet Analysis and Slack Notifications

12 nodes 252 153 Webhook
Download

Workflow Description

An intelligent automation that extracts data from Google Sheets and analyzes it using an OpenAI-powered agent with vector search capabilities, then sends summaries and insights directly to Slack channels without manual work.

How it works

  1. 1.Receive data from Google Sheets via webhook trigger
  2. 2.Split and preprocess text and structured data
  3. 3.Process information through an intelligent agent powered by OpenAI with memory
  4. 4.Perform semantic search across vector database (Supabase)
  5. 5.Generate summaries and actionable insights
  6. 6.Send results to designated Slack channels

Use cases

  • Monitor daily sales reports and alert teams instantly to performance changes
  • Analyze customer feedback and send automated summaries to support staff
  • Track project milestones and deadlines with real-time Slack notifications
  • Extract sensitive data from large spreadsheets and brief leadership

Requirements

  • Active Google Workspace account with spreadsheet edit permissions
  • OpenAI API key with sufficient quota
  • Supabase account or compatible vector database
  • Slack app token with write permissions to channels

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 252
Downloads 153

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