AI Agents

Connect Google Sheets with Slack

12 nodes 205 139 Webhook
Download

Workflow Description

An advanced automation template that connects Google Sheets with Slack using an AI-powered agent. The workflow receives data via webhook, processes it using OpenAI embeddings and memory systems, then automatically delivers results to specified Slack channels with intelligent context awareness.

How it works

  1. 1.Receive incoming request through webhook and log the event
  2. 2.Split and process text using OpenAI embeddings
  3. 3.Search the vector database and retrieve relevant context
  4. 4.Execute the AI agent to answer user queries
  5. 5.Read or update data in Google Sheets
  6. 6.Send results and notifications to Slack channels

Use cases

  • Automatically analyze spreadsheet data and send summaries to team channels
  • Answer employee questions about specific spreadsheet data directly in Slack

Requirements

  • API keys for OpenAI, Google Sheets, and Slack
  • Weaviate vector database or compatible vector storage service

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 205
Downloads 139

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