AI Agents

Extract, analyze spreadsheet data and send intelligent alerts to Slack

12 nodes 291 175 Webhook
Download

Workflow Description

An AI agent that monitors Google Sheets updates, processes data through advanced language models with vector embeddings, and delivers contextual summaries and insights to Slack channels automatically. The agent maintains conversation memory for continuous learning.

How it works

  1. 1.Webhook receives Google Sheets update triggers
  2. 2.Data is split into manageable chunks using text splitter
  3. 3.Content analyzed by AI agent powered by Claude and OpenAI embeddings
  4. 4.Vector embeddings created and stored in Weaviate for semantic search
  5. 5.Agent retrieves relevant context and formulates response
  6. 6.Analyzed insights and alerts sent to Slack channel

Use cases

  • Alert teams instantly when sales data or KPIs change in shared sheets
  • Summarize project updates and notify team members of critical changes
  • Analyze customer feedback collected in sheets and share insights
  • Monitor inventory or resource allocation sheets with automated notifications

Requirements

  • Google Workspace account with sheet modification permissions
  • Slack workspace with bot creation and app installation access
  • OpenAI and Anthropic API keys for language models
  • Weaviate vector store access for embeddings storage

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 291
Downloads 175

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

Weaviate Insert

Vector Store Weaviate

#5

Weaviate Query

Vector Store Weaviate

#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