AI Agents

Connect Google Sheets with Slack

12 nodes 240 161 Webhook
Download

Workflow Description

An automation template that integrates an AI agent powered by OpenAI models with Google Sheets and Slack. It processes data through text splitting, embeddings, and vector storage, then extracts relevant information and automatically publishes it to Slack channels.

How it works

  1. 1.Receive requests via webhook and trigger the workflow
  2. 2.Split text content and convert it to vector embeddings using OpenAI
  3. 3.Store vector representations in Supabase and retrieve relevant data
  4. 4.Run an intelligent agent with conversation memory to answer queries
  5. 5.Read and process data from Google Sheets using the agent
  6. 6.Send results and summaries to designated Slack channels

Use cases

  • Monitor large datasets, extract insights, and notify your team instantly via Slack
  • Answer user questions about Google Sheets data and send responses directly to Slack
  • Automate recurring reports from spreadsheet data and publish them to Slack

Requirements

  • Valid OpenAI API key with sufficient quota
  • Google Sheets read and write permissions
  • Active and reliable webhook endpoint
  • Supabase vector storage configuration
  • Slack bot token or webhook URL

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

OpenAI

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12