AI Agents

Connect Google Sheets with Slack

12 nodes 236 172 Webhook
Download

Workflow Description

An intelligent automation system connecting Google Sheets with Slack through an AI agent that analyzes data and retrieves relevant information using advanced language models and vector storage, enabling automatic alerts and organized content delivery to Slack channels.

How it works

  1. 1.Receive requests via webhook and split text into logical segments
  2. 2.Convert data to vectors using OpenAI embeddings and store in Weaviate
  3. 3.Process queries through AI agent with context memory and Anthropic language model
  4. 4.Fetch relevant data from Google Sheets and compose response
  5. 5.Send final results to designated Slack channels

Use cases

  • Analyze Google Sheets reports and distribute to Slack team based on natural language queries
  • Create smart alerts when specific data updates with contextual explanations

Requirements

  • Valid API keys for OpenAI, Anthropic, and active Weaviate database instance
  • Google Sheets account with read permissions and Slack account with channel write access

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 Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 236
Downloads 172

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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12