AI Agents

Analyze Google Sheets data and share insights with Slack

12 nodes 226 156 Webhook
Download

Workflow Description

An intelligent automation receives webhook requests, processes Google Sheets data using an AI agent powered by Anthropic's models, stores information in a vector database, and retrieves contextual answers from your data. Results are sent directly to Slack channels for team visibility.

How it works

  1. 1.Receive incoming request via webhook and extract query parameters
  2. 2.Split and process Google Sheets content into manageable chunks
  3. 3.Generate embeddings and store vectorized data in Supabase
  4. 4.Query AI agent with conversation memory to answer data questions
  5. 5.Deliver analysis results to designated Slack channel

Use cases

  • Enable instant employee Q&A about project data stored in shared Google Sheets
  • Automatically analyze sales reports and financial data, sending AI-generated summaries to Slack

Requirements

  • Google Workspace account with edit permissions on target spreadsheets
  • Slack workspace with bot or app access for message posting
  • Anthropic API key to access Claude language models

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Text Splitter Embeddings Vector Store Memory Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 226
Downloads 156

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

Embeddings Cohere

#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