AI Agents

Intelligent data analysis from Google Sheets with Slack notifications

12 nodes 235 164 Webhook
Download

Workflow Description

An automation that deploys an AI agent powered by advanced language models to read Google Sheets data, process it through vector embeddings and contextual memory, then deliver intelligent summaries and actionable alerts to Slack channels automatically.

How it works

  1. 1.Webhook triggers the workflow when new data arrives
  2. 2.Text splitter breaks down data into processable segments
  3. 3.OpenAI embeddings are generated and stored in Weaviate vector database
  4. 4.AI agent retrieves relevant context from vector store and conversation memory
  5. 5.Agent formulates insights and sends structured messages to Slack

Use cases

  • Monitor spreadsheet updates in real time and notify teams with intelligent summaries
  • Analyze customer or sales data and generate automated business insights for Slack
  • Query structured data through a conversational AI agent trained on your sheets

Requirements

  • Google Workspace account with Google Sheets API access enabled
  • API keys for OpenAI and Anthropic, plus Weaviate vector database configuration
  • Slack workspace with app installation permissions and message posting rights

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 235
Downloads 164

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