AI Agents

Query Google Sheets data intelligently through Slack conversations

12 nodes 273 169 Webhook
Download

Workflow Description

An automation that receives user queries from Slack, processes them with an AI agent powered by Anthropic models, searches your Google Sheets data using vector embeddings, and returns accurate answers directly in Slack conversations.

How it works

  1. 1.Receive query from Slack via webhook trigger
  2. 2.Split and analyze query text for processing
  3. 3.Search Google Sheets data using intelligent agent with context memory
  4. 4.Convert results through vector embeddings and storage
  5. 5.Deliver formatted response back to Slack

Use cases

  • Answer employee questions about large spreadsheet datasets instantly
  • Automatically generate and share dynamic reports with team members
  • Provide intelligent search interface for quick data retrieval from records

Requirements

  • Active Google Sheets account with data access
  • Slack workspace with message posting permissions
  • API keys for OpenAI and Anthropic services
  • Supabase database configured for vector storage

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 273
Downloads 169

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