AI Agents

Analyze Google Sheets data and send intelligent Slack notifications

12 nodes 333 186 Webhook
Download

Workflow Description

Automation receives data from Google Sheets via webhook, processes it using an AI agent powered by embeddings and memory systems, analyzes the content, and automatically sends formatted results to designated Slack channels for team awareness.

How it works

  1. 1.Receive data request through webhook and initiate workflow execution
  2. 2.Process spreadsheet content using OpenAI agent with Vector Store access and memory retrieval
  3. 3.Format analyzed insights and deliver results to Slack channels

Use cases

  • Send intelligent alerts to Slack when spreadsheet data updates or new rows are added
  • Generate automated summaries and reports from sheet data for team distribution
  • Enable the agent to answer team questions about stored spreadsheet data from memory

Requirements

  • Google Workspace account with Google Sheets editor permissions and API access
  • OpenAI API key configured with an AI agent setup in n8n
  • Slack workspace with app integration, authentication tokens, and target channel configuration

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Text Splitter Embeddings Vector Store Memory OpenAI AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 333
Downloads 186

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

Embeddings Cohere

#4

Pinecone Insert

Vector Store Pinecone

#5

Pinecone Query

Vector Store Pinecone

#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