AI Agents

Query Google Sheets data and deliver insights to Slack via AI

12 nodes 314 171 Webhook
Download

Workflow Description

Automated workflow that receives requests through webhook, processes Google Sheets data using OpenAI language models with contextual memory, and delivers intelligent responses directly to Slack channels with semantic search capabilities.

How it works

  1. 1.Accept incoming request via webhook and route data to intelligent agent
  2. 2.Split and embed spreadsheet content using Cohere embeddings
  3. 3.Search vector database in Supabase to retrieve relevant context
  4. 4.Process query using OpenAI model while maintaining conversation history
  5. 5.Format and send results to designated Slack channel

Use cases

  • Answer team questions about spreadsheet data directly from Slack
  • Deliver automated reports on sales, inventory, or metrics to Slack
  • Enable natural language queries against structured Google Sheets data
  • Provide on-demand data summaries without manual spreadsheet access

Requirements

  • Google Workspace account with Sheets access permissions
  • OpenAI API key and Cohere account credentials
  • Slack workspace with app installation permissions
  • Supabase vector database instance configured

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Text Splitter Embeddings Vector Store Memory OpenAI AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 314
Downloads 171

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

OpenAI

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12