AI Agents

Connect Google Sheets with Slack

12 nodes 197 153 Webhook
Download

Workflow Description

This template connects Google Sheets with Slack using an intelligent agent powered by memory and vector search. It receives requests via webhook, processes them using OpenAI embeddings and a Weaviate vector store to retrieve relevant sheet data, and automatically sends results to Slack channels.

How it works

  1. 1.Receive incoming request via webhook and pass it to the intelligent agent
  2. 2.Split and embed request text into vector embeddings using OpenAI
  3. 3.Search Weaviate vector store for matching data from Google Sheets
  4. 4.Use conversation memory to maintain context and track previous results
  5. 5.Send final response to designated Slack channel

Use cases

  • Enable team members to query spreadsheet data directly through Slack without leaving the platform
  • Automatically log decisions and updates from Slack conversations back to Google Sheets

Requirements

  • Valid API keys for OpenAI, Google Sheets, and Slack
  • Pre-populated Google Sheets with data to search across
  • Configured Weaviate vector database with document 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 AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 7
Views 197
Downloads 153

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