AI Agents

Analyze Google Sheets data and send intelligent messages to Slack

12 nodes 362 178 Webhook
Download

Workflow Description

An automation that receives requests via webhook, processes Google Sheets data using an AI agent powered by OpenAI, maintains conversation context in memory, stores data vectors in Pinecone, and delivers answers directly to Slack channels.

How it works

  1. 1.Receive incoming request through webhook trigger
  2. 2.Split and process text content using Text Splitter
  3. 3.Convert data into embeddings via OpenAI API
  4. 4.Store and search vectors in Pinecone database
  5. 5.Run the AI agent to generate intelligent responses
  6. 6.Send results to specified Slack channels

Use cases

  • Answer employee questions about spreadsheet data directly from Slack
  • Automatically generate reports based on natural language requests from your team
  • Connect Google Sheets updates with intelligent Slack notifications

Requirements

  • Active OpenAI API key with sufficient quota
  • Google Sheets containing the data to be analyzed
  • Active Slack workspace with configured channels
  • Pinecone API key for vector storage

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 362
Downloads 178

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

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