AI Agents

Intelligent sheet data analysis and search via Slack

12 nodes 228 154 Webhook
Download

Workflow Description

An AI agent receives queries from Slack, searches Google Sheets data using advanced embeddings and memory, and delivers accurate analytical responses instantly without delays or manual intervention.

How it works

  1. 1.Receive Slack inquiry through webhook trigger
  2. 2.Split and embed text using Cohere embeddings
  3. 3.Search Pinecone vector store for relevant data
  4. 4.Maintain context with buffer memory and OpenAI processing
  5. 5.Execute intelligent agent reasoning for response
  6. 6.Send result back to Slack channel

Use cases

  • Instant team answers about spreadsheet data and metrics
  • Real-time report and statistics analysis from Slack
  • Smart search through stored records and historical data

Requirements

  • OpenAI and Cohere API keys configured
  • Pinecone account with indexed Google Sheets data
  • Slack workspace with webhook permissions enabled

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 228
Downloads 154

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