AI Agents

Extract Google Sheets data, analyze with AI agent, and send results to Slack

12 nodes 220 151 Webhook
Download

Workflow Description

Automation that receives webhook requests, extracts data from Google Sheets, processes it through an intelligent AI agent powered by Anthropic and OpenAI with conversational memory, and automatically sends analyzed results to Slack channels.

How it works

  1. 1.Receive incoming request via webhook and prepare data
  2. 2.Extract records from Google Sheets for processing
  3. 3.Split and tokenize text content into manageable chunks
  4. 4.Convert text to vector embeddings and store in Supabase
  5. 5.Process query through AI agent using Anthropic and OpenAI models
  6. 6.Send analysis and insights to designated Slack channels

Use cases

  • Automatically summarize sales reports from Google Sheets and share insights with marketing team via Slack
  • Answer employee questions about company data stored in spreadsheets instantly through Slack
  • Monitor customer data changes and trigger intelligent alerts when predefined conditions are met

Requirements

  • Google Workspace account with Google Sheets access permissions
  • Slack workspace with bot and app installation capabilities
  • API keys for Anthropic, OpenAI, and Supabase database

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 220
Downloads 151

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

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