AI Agents

Connect Google Sheets with Slack

12 nodes 206 147 Webhook
Download

Workflow Description

An intelligent agent template connecting Google Sheets to Slack, analyzing data and sending automated notifications. Uses OpenAI to process text and vector storage to enable semantic search, allowing instant answers to queries about spreadsheet content.

How it works

  1. 1.Receive webhook request and split text into manageable segments
  2. 2.Convert data into embeddings within Weaviate vector store for semantic search
  3. 3.Execute intelligent agent that interacts with Google Sheets and generates responses
  4. 4.Send results and alerts to designated Slack channels

Use cases

  • Automatically notify sales teams of new updates in spreadsheet records
  • Answer employee questions about data stored in sheets directly via Slack
  • Analyze large datasets and extract intelligent summaries automatically

Requirements

  • Valid API keys for OpenAI, Google Sheets, and Slack services
  • Organized data structure in Google Sheets aligned with expected queries
  • Knowledge of webhook configuration and secure authentication

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 206
Downloads 147

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