AI Agents

Generate intelligent Slack responses from Google Sheets data

12 nodes 223 157 Webhook
Download

Workflow Description

Smart automation that receives inquiries through Slack, analyzes Google Sheets data using AI, and sends thoughtful responses back to the channel. Delivers instant answers without manual intervention through semantic search and contextual memory.

How it works

  1. 1.Receive message from Slack via webhook trigger
  2. 2.Split text and extract meaning using OpenAI embeddings
  3. 3.Search Google Sheets data stored as vectors in Weaviate
  4. 4.Send intelligent response back to the Slack channel

Use cases

  • Answer employee questions about stored data instantly
  • Summarize reports from Google Sheets when requested via Slack
  • Quick search through records and historical data without opening the spreadsheet

Requirements

  • Google account with access permissions to specific spreadsheets
  • Slack workspace with bot permissions to send and receive messages
  • API keys from OpenAI and Weaviate for AI processing and vector storage

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 223
Downloads 157

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