AI Agents

Analyze Google Sheets data and send intelligent summaries to Slack

12 nodes 334 181 Webhook
Download

Workflow Description

Automation that retrieves data from Google Sheets, processes it using machine learning and vector embeddings, and delivers smart summaries and key insights to Slack channels automatically when data updates.

How it works

  1. 1.Receive new data from Google Sheets via webhook trigger
  2. 2.Split and convert text into machine-readable vector embeddings
  3. 3.Query the AI agent (OpenAI) to extract insights and generate summaries
  4. 4.Send results directly to designated Slack channels in real time

Use cases

  • Automatic alerts when key performance indicators or sensitive data changes in spreadsheets
  • Generate daily intelligent reports from sales and operations sheets for team distribution
  • Answer team questions about specific spreadsheet data via Slack without manual intervention

Requirements

  • Active Google Workspace account with spreadsheet editing permissions
  • Slack workspace account with channel posting permissions
  • Valid OpenAI API key for model access
  • Enabled Supabase service for vector storage

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 334
Downloads 181

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