AI Agents

Connect Google Sheets with Slack

12 nodes 206 156 Webhook
Download

Workflow Description

An advanced automation that combines an AI agent with Google Sheets and Slack. It receives requests via webhook, processes them using language models, retrieves relevant data from Google Sheets, and delivers intelligent responses directly to Slack channels.

How it works

  1. 1.Receive request through webhook and split text into processable chunks
  2. 2.Convert chunks into embeddings and store in vector database
  3. 3.Trigger AI agent to retrieve relevant data from Google Sheets using vector search tool
  4. 4.Process query with Anthropic language model while maintaining conversation context
  5. 5.Send intelligent response to Slack

Use cases

  • Auto-respond to team inquiries about specific data stored in Google Sheets
  • Process data requests from Slack and provide AI-powered answers backed by actual information
  • Build intelligent conversations combining Google Sheets data with natural language understanding

Requirements

  • Google account with access to target Google Sheets
  • Slack workspace with permissions to send messages and read channels
  • API keys for Anthropic and OpenAI language models
  • Supabase database to store embeddings

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

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