AI Agents

Connect Google Sheets with Slack

12 nodes 202 136 Webhook
Download

Workflow Description

An advanced automation template that integrates an AI agent with Google Sheets and Slack, processing data through sophisticated language models and storing it in a vector database, enabling your team to query information and receive automated alerts via Slack.

How it works

  1. 1.Receive a webhook request and route it to an AI agent powered by Anthropic's language model
  2. 2.Split data content into manageable chunks using the Text Splitter module
  3. 3.Convert text to numerical vectors via OpenAI Embeddings and store them in Supabase
  4. 4.Search and retrieve information through an organized conversation memory system
  5. 5.Read data from Google Sheets tables or write results back to them
  6. 6.Send responses and notifications to designated Slack channels

Use cases

  • Build an intelligent consultation system that answers questions about company data stored in Google Sheets directly through Slack
  • Automate feedback collection from Google Sheets, process it with AI, and publish results to your team on Slack

Requirements

  • An Anthropic account with a valid API key
  • OpenAI account for Embeddings service and Supabase account for vector database
  • Access to Google Sheets API and Slack app with appropriate send and read 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 Anthropic AI Agent Google Sheets Slack

Details

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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12