AI Agents

Analyze Google Sheets data and send intelligent Slack reports

12 nodes 310 185 Webhook
Download

Workflow Description

An automation template that retrieves data from Google Sheets, processes it through an AI-powered agent, and automatically converts the information into concise, actionable reports delivered to Slack channels. Eliminates manual data analysis and ensures your team stays informed in real time.

How it works

  1. 1.Receive a trigger via Webhook to initiate the automation
  2. 2.Fetch data from the specified Google Sheets table
  3. 3.Process text content and convert it into embeddings using OpenAI
  4. 4.Store data in Supabase Vector Store and perform semantic searches
  5. 5.Generate intelligent summaries using an AI agent with contextual memory
  6. 6.Send the final report to the designated Slack channel

Use cases

  • Send daily sales performance summaries from spreadsheets directly to your sales team channel
  • Analyze customer feedback collected in Sheets and deliver AI-generated insights to Slack automatically

Requirements

  • Active Google Workspace account with edit permissions on the target Sheets document
  • Slack workspace access with permissions to post messages to target channels
  • OpenAI and Supabase API keys with Vector Store enabled

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 310
Downloads 185

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