AI Agents

Analyze spreadsheet data and send intelligent summaries to Slack

12 nodes 282 172 Webhook
Download

Workflow Description

Smart automation receives data from Google Sheets via webhook, processes it with an AI agent powered by OpenAI and advanced memory management, stores information in a Weaviate vector database, and delivers customized summaries and insights to Slack channels.

How it works

  1. 1.Receive webhook request containing Google Sheets data
  2. 2.Process and split text, convert to embeddings using OpenAI
  3. 3.Search vector database and retrieve relevant information
  4. 4.Execute intelligent agent to make decisions based on context and memory
  5. 5.Send results and findings to Slack

Use cases

  • Smart alerts about critical spreadsheet changes with automatic analysis
  • Answer team questions about spreadsheet data directly from Slack
  • Generate daily summary reports from Google Sheets and deliver to team

Requirements

  • Google Sheets account with full access permissions
  • Slack account with message posting and channel management rights
  • OpenAI API key for language models and embeddings
  • Active Weaviate vector database or vector storage service

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 282
Downloads 172

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

OpenAI

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12