AI Agents

Connect Google Sheets with Slack

12 nodes 213 161 Webhook
Download

Workflow Description

An automation template connecting Google Sheets with Slack through an intelligent agent powered by Anthropic and OpenAI models. It splits text data, creates vector embeddings, stores them in Supabase, and responds to Slack inquiries with AI-driven answers.

How it works

  1. 1.Receive and process webhook requests
  2. 2.Split text and generate vector embeddings via OpenAI and Anthropic
  3. 3.Store data in Supabase vector store with buffered memory
  4. 4.Smart agent queries Google Sheets and delivers intelligent responses to Slack

Use cases

  • Automate employee queries about spreadsheet data directly through Slack messages
  • Archive and retrieve documentation using natural language inquiries in Slack
  • Generate data summaries and reports from Google Sheets on-demand via Slack

Requirements

  • Active Google Workspace account with organized Google Sheets data
  • Slack workspace with app installation and integration permissions
  • API keys for OpenAI, Anthropic, and an active Supabase database instance

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 213
Downloads 161

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