AI Agents

Query Google Sheets data intelligently through Slack

12 nodes 286 192 Webhook
Download

Workflow Description

Automation that receives inquiries via Slack, employs an AI agent powered by Anthropic's language model to search Google Sheets data, and returns answers directly to users through semantic Vector Store retrieval for efficient information discovery.

How it works

  1. 1.Receive query via webhook from Slack
  2. 2.Split text into processable chunks and convert to semantic embeddings
  3. 3.Search Vector Store linked to Google Sheets data and retrieve relevant records
  4. 4.Process query through an intelligent agent using Anthropic's language model
  5. 5.Send synthesized response back to Slack

Use cases

  • Answer employee questions about project data and contracts stored in spreadsheets
  • Instant search for sales or customer information without manually opening Sheets
  • Generate summary reports from spreadsheet data based on natural language queries

Requirements

  • Google Sheets account with required access and prepared spreadsheet file
  • Slack account with permissions to send and receive messages
  • API keys for Anthropic and OpenAI (embeddings)
  • Supabase or Vector Store database configured for semantic search

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 286
Downloads 192

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