AI Agents

Analyze Google Sheets Data and Send Intelligent Summaries to Slack

12 nodes 310 191 Webhook
Download

Workflow Description

An AI-powered automation that processes Google Sheets data using intelligent agents to generate insights and deliver them directly to Slack channels. The workflow splits text, embeds it into vector databases, and leverages OpenAI and Anthropic models to create actionable summaries with contextual memory for your team.

How it works

  1. 1.Receive data updates from Google Sheets through a webhook trigger
  2. 2.Parse and split content into embeddings using OpenAI models
  3. 3.Query vector database and analyze context using AI agent with memory
  4. 4.Send insights and formatted summaries to designated Slack channels

Use cases

  • Monitor daily reports in spreadsheets and notify teams with AI-generated summaries
  • Extract customer insights from tracking sheets and push to sales team channels
  • Analyze project notes and recommend next steps automatically via Slack

Requirements

  • Active Google Sheets with API access and edit permissions on target sheet
  • Slack workspace with app creation permissions and message posting rights
  • Valid API keys for OpenAI and Anthropic models

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 Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 310
Downloads 191

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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12