AI Agents

Intelligent analysis of spreadsheets and delivery to Slack channels

12 nodes 312 183 Webhook
Download

Workflow Description

An automation receives data through webhooks, processes it with an AI agent powered by OpenAI, stores embeddings in Weaviate vector database, and retrieves actionable insights to deliver directly to Slack channels in real time.

How it works

  1. 1.Receive webhook requests and split data content into manageable chunks
  2. 2.Convert text to embeddings using Cohere and persist them in Weaviate
  3. 3.Activate AI agent with window memory for intelligent data querying
  4. 4.Fetch and format data from Google Sheets
  5. 5.Analyze findings and send results to designated Slack channels

Use cases

  • Send automated analytical alerts from spreadsheets to team channels on Slack
  • Enable AI-powered Q&A on company data stored in Google Sheets
  • Generate and broadcast daily data summaries to collaborative channels

Requirements

  • Google account with access permissions to Google Sheets
  • Slack workspace with app creation and webhook capabilities
  • OpenAI and Cohere API keys for intelligent processing
  • Live Weaviate instance for vector storage and retrieval

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 312
Downloads 183

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

Weaviate Insert

Vector Store Weaviate

#5

Weaviate Query

Vector Store Weaviate

#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