AI Agents

Connect Google Sheets with Slack

12 nodes 235 151 Webhook
Download

Workflow Description

An intelligent automation that retrieves and analyzes Google Sheets data using an AI agent powered by OpenAI, then automatically sends insights and summaries to designated Slack channels in real time.

How it works

  1. 1.Receive request via webhook and trigger workflow
  2. 2.Split sheet content into processable segments
  3. 3.Convert data into vector embeddings and store in vector database
  4. 4.Use AI agent to answer data questions and generate insights
  5. 5.Send generated results and reports to Slack channels

Use cases

  • Analyze sales and customer data stored in Sheets and send daily summary reports to the sales team
  • Automatically answer employee queries about company records in spreadsheets and respond in Slack
  • Monitor spreadsheet updates and instantly notify the team when important changes occur

Requirements

  • Active Google account with access to Google Sheets
  • Slack workspace with permissions to send messages to channels
  • Valid API keys for OpenAI and Supabase

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 235
Downloads 151

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

Supabase Insert

Vector Store Supabase

#5

Supabase Query

Vector Store Supabase

#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