AI Agents

Connect Google Sheets with Slack

12 nodes 205 151 Webhook
Download

Workflow Description

An intelligent automation template connecting Google Sheets with Slack through an AI agent powered by OpenAI's natural language capabilities, enabling automatic data extraction, analysis, and smart message delivery to team channels.

How it works

  1. 1.Receive webhook request and route to the AI agent
  2. 2.Process and split long-form text using Text Splitter
  3. 3.Generate vector embeddings from data using OpenAI Embeddings
  4. 4.Retrieve relevant information from Supabase Vector Store
  5. 5.Maintain conversation context through Buffer Window Memory
  6. 6.Execute agent queries on Google Sheets and deliver results to Slack

Use cases

  • Send intelligent alerts to Slack when specific Google Sheets data changes
  • Search sheet information and receive AI-generated answers directly in Slack
  • Automate periodic reports from Google Sheets with AI analysis for team notification

Requirements

  • Active Google Cloud account with Google Sheets API enabled
  • Valid OpenAI API keys for language model access
  • Slack workspace API token with appropriate bot permissions

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 AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 7
Views 205
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

OpenAI

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12