AI Agents

Connect Google Sheets with Slack

12 nodes 214 161 Webhook
Download

Workflow Description

An intelligent automation that connects Google Sheets with Slack through an AI agent, processing data using advanced language models and storing it in a vector database to provide instant responses to your team's inquiries in Slack based on spreadsheet content.

How it works

  1. 1.Receive webhook requests and split text into processable units
  2. 2.Convert data to numerical vectors and store in Supabase
  3. 3.Activate AI agent with contextual memory for answering queries
  4. 4.Retrieve relevant data from Google Sheets
  5. 5.Send results and responses to Slack channel

Use cases

  • Automatically answer team questions about spreadsheet data directly in Slack
  • Monitor Google Sheets updates and notify the team of critical changes
  • Perform intelligent searches across multiple spreadsheets with automatic summaries

Requirements

  • Google Workspace account with Google Sheets access permissions
  • Slack workspace with app management privileges
  • API keys for OpenAI, Anthropic, and Supabase database access

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