AI Agents

Connect Google Sheets with Slack

12 nodes 228 179 Webhook
Download

Workflow Description

An intelligent automation template connecting Google Sheets with Slack through an AI agent powered by OpenAI. It receives requests via webhook, processes data using embeddings and vector storage, maintains conversation memory, and automatically sends results to Slack channels for team collaboration and data-driven decision-making.

How it works

  1. 1.Trigger workflow via webhook and initialize the request pipeline
  2. 2.Split and embed text content using OpenAI models
  3. 3.Store and retrieve data vectors in Weaviate database
  4. 4.Process queries through intelligent agent with contextual memory
  5. 5.Read and update data in Google Sheets dynamically
  6. 6.Send results and notifications directly to Slack channels

Use cases

  • Monitor spreadsheet changes and send instant alerts to team Slack channels
  • Search sheet content intelligently and answer queries automatically
  • Automate data extraction from sheets and share insights across teams
  • Build a smart support system combining company data with conversational AI

Requirements

  • Valid OpenAI API key for language models and embedding generation
  • Authenticated Google Sheets connection with read and write permissions
  • Slack workspace token with message posting authorization for target channels
  • Running Weaviate instance for stable vector storage and retrieval

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 228
Downloads 179

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