AI Agents

Analyze Google Sheets data with AI and deliver insights to Slack

12 nodes 328 177 Webhook
Download

Workflow Description

Automate data retrieval from Google Sheets, process it through an OpenAI-powered AI agent with semantic search capabilities, and push analyzed results and recommendations directly to Slack channels for real-time team access and decision-making.

How it works

  1. 1.Receive trigger via webhook and initiate automation workflow
  2. 2.Fetch data from specified Google Sheets and tables
  3. 3.Split and prepare text content for semantic processing
  4. 4.Generate OpenAI embeddings and query Vector Store database
  5. 5.Run AI agent to analyze patterns and generate insights
  6. 6.Send formatted results and summaries to designated Slack channel

Use cases

  • Deliver automated daily sales analysis and KPI summaries to Slack for executive review
  • Enable team members to ask questions about sheet data and receive AI-powered answers via Slack

Requirements

  • Active Google Sheets with read access to required tables and data
  • Valid OpenAI API key and Supabase Vector Store database connection
  • Slack workspace with Bot token and target channel permissions configured

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 328
Downloads 177

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