AI Agents

Analyze Google Sheets data and deliver intelligent insights to Slack

12 nodes 327 164 Webhook
Download

Workflow Description

Automation receives data via webhook, processes it using an AI agent powered by OpenAI, analyzes content through embeddings and vector storage, then delivers results automatically to designated Slack channels with contextual intelligence.

How it works

  1. 1.Receive webhook request and split data into manageable chunks for processing
  2. 2.Convert text to embeddings and store in Pinecone vector database for semantic search
  3. 3.Activate intelligent agent with contextual memory and OpenAI model to analyze data
  4. 4.Retrieve relevant records from Google Sheets based on semantic similarity
  5. 5.Compose response and send automatically to Slack channel

Use cases

  • Intelligent alerts when specific data changes in spreadsheets
  • Automated analysis of incoming questions with answers grounded in company data

Requirements

  • Active OpenAI API key and Cohere account for embeddings
  • Pinecone subscription and full access permissions to Google Sheets

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 327
Downloads 164

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