AI Agents

Send Sheets data analysis to Slack using an AI agent

12 nodes 271 146 Webhook
Download

Workflow Description

An automation that retrieves data from Google Sheets, processes it with an intelligent agent powered by vector search and memory, then automatically sends summaries and insights to designated Slack channels.

How it works

  1. 1.Receive webhook request to trigger automation
  2. 2.Fetch data from the specified Google Sheets table
  3. 3.Process texts, split them, and convert to vector embeddings
  4. 4.Generate intelligent analysis using Claude with conversation memory
  5. 5.Send formatted results as messages to Slack

Use cases

  • Send weekly data report summaries from Sheets to team Slack channels
  • Generate real-time customer data insights and alert the team immediately

Requirements

  • Google Workspace account with Sheets access permissions
  • Slack workspace account with channel management rights
  • Valid API keys for OpenAI and Anthropic services

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 271
Downloads 146

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