AI Agents

Analyze spreadsheet data with an AI agent and send insights to Slack

12 nodes 302 147 Webhook
Download

Workflow Description

Webhook-triggered automation that processes spreadsheet data through an intelligent AI agent powered by OpenAI embeddings and vector search, then delivers analyzed results directly to Slack with conversation memory.

How it works

  1. 1.Receive incoming data via webhook and split into processable chunks
  2. 2.Convert chunks to embeddings via OpenAI and store in Pinecone vector database
  3. 3.Execute intelligent agent that queries embeddings and maintains conversation context
  4. 4.Fetch and update Google Sheets data based on agent analysis
  5. 5.Send final report and recommendations to designated Slack channel

Use cases

  • Generate daily sales summaries from spreadsheets and send them to team channels
  • Answer HR staff questions about payroll data through intelligent conversational interface
  • Monitor performance metrics and alert teams when KPIs exceed defined thresholds

Requirements

  • Active OpenAI and Pinecone API keys with appropriate permissions
  • Google Sheets account with edit access and Slack workspace with target channel
  • External webhook source to trigger automation with structured data payloads

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 302
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

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