AI Agents

Connect Google Sheets with Slack

12 nodes 260 141 Webhook
Download

Workflow Description

An intelligent automation template connecting Google Sheets with Slack through an AI agent powered by OpenAI. Receives data via webhook, processes it using advanced language models, stores embeddings in a vector database, and delivers results directly to Slack channels.

How it works

  1. 1.Receive data requests via webhook and trigger the workflow
  2. 2.Split text content using Text Splitter for optimized processing
  3. 3.Generate vector embeddings from data using OpenAI models
  4. 4.Store embeddings in Weaviate Vector Store for fast retrieval
  5. 5.Process queries through an intelligent agent with memory and language capabilities
  6. 6.Fetch data from Google Sheets and send formatted messages to Slack

Use cases

  • Automatically notify teams when critical spreadsheet data changes
  • Generate AI-powered summaries of customer data and push to Slack channels

Requirements

  • Valid OpenAI API key and Weaviate access credentials
  • Full permissions to Google Sheets and Slack workspace

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 260
Downloads 141

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

Weaviate Insert

Vector Store Weaviate

#5

Weaviate Query

Vector Store Weaviate

#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