AI Agents

Connect Google Sheets with Slack

12 nodes 219 151 Webhook
Download

Workflow Description

Advanced automation template that connects Google Sheets with Slack through an intelligent AI agent powered by Anthropic. The workflow processes sheet data, generates embeddings via OpenAI, stores vectors in Supabase, and enables smart queries on your spreadsheets with results posted automatically to Slack channels.

How it works

  1. 1.Trigger workflow execution via incoming webhook request
  2. 2.Split and process incoming data using character-based text splitter
  3. 3.Generate vector embeddings from data using OpenAI embeddings model
  4. 4.Store and index vectors in Supabase vector database
  5. 5.Query data through intelligent AI agent backed by Anthropic Claude
  6. 6.Send formatted results and responses to designated Slack channel

Use cases

  • Answer team questions about spreadsheet data instantly without manual data lookup
  • Analyze large datasets intelligently, generate summaries, and share insights in Slack
  • Create smart alerts with contextual explanations when specific data changes occur

Requirements

  • Active Google Sheets account with API access enabled
  • API keys for OpenAI, Anthropic, and Supabase services
  • Slack workspace with bot permissions to send messages
  • Configured webhook URL for triggering the automation workflow

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 219
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