AI Agents

Connect Google Sheets with Slack

12 nodes 215 139 Webhook
Download

Workflow Description

An intelligent automation connecting Google Sheets to Slack via an AI-powered agent. Receives requests through webhook, processes them using Anthropic and OpenAI models, stores data in Supabase vector database, and sends customized responses directly to Slack channels.

How it works

  1. 1.Receive and parse request via webhook trigger
  2. 2.Split and process text using Text Splitter component
  3. 3.Convert data to embeddings via OpenAI model
  4. 4.Search vector database in Supabase and retrieve context
  5. 5.Generate intelligent response using Anthropic AI agent
  6. 6.Send result to designated Slack channel

Use cases

  • Automatically answer employee questions about spreadsheet data
  • Update Slack messages when spreadsheet information changes
  • Analyze team inquiries and provide AI-powered responses
  • Automate data reports and distribute them across Slack channels

Requirements

  • Active Google Sheets account with access permissions
  • Slack workspace with message posting rights
  • OpenAI and Anthropic API keys configured
  • Supabase account 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 215
Downloads 139

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