AI Agents

Query Google Sheets data and deliver insights to Slack with AI

12 nodes 312 190 Webhook
Download

Workflow Description

Intelligent automation that receives requests through webhooks, analyzes Google Sheets data using an AI agent powered by Anthropic's model, and sends results and summaries to Slack channels automatically while maintaining context and conversation history.

How it works

  1. 1.Receive webhook request and prepare data for processing
  2. 2.Split text content and convert into numerical embeddings for semantic understanding
  3. 3.Search the vector database intelligently and answer queries with context
  4. 4.Execute AI agent using Anthropic model for analysis and summarization
  5. 5.Retrieve relevant data from Google Sheets based on agent instructions
  6. 6.Send results and reports to designated Slack channels automatically

Use cases

  • Receive employee inquiries about sales data from Slack and return reports from Google Sheets instantly
  • Monitor financial spreadsheets and send smart summaries to teams when important updates occur
  • Automatically answer recurring customer questions based on a comprehensive Google Sheets database

Requirements

  • Active Anthropic account with valid API Key configured
  • Full access to Google Sheets and write permissions to target Slack channel or direct message
  • Configured Supabase database connected to store and query embeddings

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 312
Downloads 190

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