AI Agents

Extract spreadsheet data and analyze it with AI in Slack

12 nodes 296 193 Webhook
Download

Workflow Description

Automation receives webhook requests, extracts data from Google Sheets, processes it using OpenAI models enhanced with memory and vector storage, and delivers analytical insights directly to Slack channels.

How it works

  1. 1.Receive request via webhook and trigger the workflow
  2. 2.Process text and convert it into vector embeddings
  3. 3.Query the AI agent for spreadsheet data and retrieve answers
  4. 4.Send results and analysis to Slack

Use cases

  • Send daily summaries of spreadsheet data to your team on Slack
  • Answer employee questions about specific data in your sheets automatically

Requirements

  • OpenAI API key and Pinecone account for vector storage
  • Organized Google Sheets and access permissions for your Slack workspace

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 296
Downloads 193

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