AI Agents

Send Google Sheets Data to Slack with Intelligent Agent

12 nodes 343 173 Webhook
Download

Workflow Description

Automation that captures updates from Google Sheets, processes them using advanced AI embeddings and vector search, then delivers intelligent summaries and reports to Slack channels automatically through a conversation-based AI agent.

How it works

  1. 1.Receive new data updates from Google Sheets through webhook trigger
  2. 2.Split and convert text into vector embeddings using Cohere service
  3. 3.Search vector database (Supabase) for relevant related records and context
  4. 4.Use AI agent powered by Anthropic to analyze data and generate insightful responses
  5. 5.Send automatically generated summaries and insights to designated Slack channels

Use cases

  • Generate daily reports from spreadsheets and deliver them to team Slack channels
  • Analyze customer or product data and alert teams to important findings automatically
  • Monitor sales orders and inventory from shared sheets with intelligent Slack notifications

Requirements

  • Active Google Sheets account with regularly updated data table
  • Slack workspace with permission to post messages to channels
  • Anthropic API key to power the intelligent agent's reasoning
  • Access to Supabase database for vector storage and semantic search

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 343
Downloads 173

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