AI Agents

Connect Google Sheets with Slack

12 nodes 206 136 Webhook
Download

Workflow Description

An automation template that connects Google Sheets with Slack through an intelligent AI agent powered by OpenAI. It receives queries via webhook, processes them using text splitting and embeddings, retrieves data from spreadsheets, and sends contextual responses via Slack.

How it works

  1. 1.Receive and log the incoming request through webhook
  2. 2.Split text and convert it into OpenAI embeddings
  3. 3.Search the Vector Store in Supabase for relevant data
  4. 4.Use OpenAI agent with memory to understand context
  5. 5.Fetch required data from Google Sheets
  6. 6.Send the final answer to the specified Slack channel

Use cases

  • Query spreadsheet data and get instant answers in Slack
  • Automatically generate reports from Google Sheets and share them with your team on Slack

Requirements

  • OpenAI API key for running the intelligent agent and embeddings
  • Supabase database connection to store and retrieve Vector Store

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 206
Downloads 136

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