AI Agents

Analyze Google Sheets data and send intelligent summaries to Slack

12 nodes 228 152 Webhook
Download

Workflow Description

An AI-powered automation that receives webhook requests, processes Google Sheets data using OpenAI and Anthropic models, stores information in a vector database, and automatically delivers results to Slack channels. The system maintains conversation context and retrieves relevant data through semantic search.

How it works

  1. 1.Receive request via webhook and activate intelligent agent
  2. 2.Extract and split text data from Google Sheets
  3. 3.Generate smart responses using OpenAI and Anthropic models
  4. 4.Search Pinecone vector database for relevant information
  5. 5.Send insights and recommendations to Slack channels

Use cases

  • Automatically summarize spreadsheet reports and notify teams on Slack
  • Answer data questions intelligently by connecting sheets to conversation history
  • Extract actionable insights from large datasets and alert teams instantly

Requirements

  • Google Workspace account with sheet editing permissions
  • Slack workspace with channel management and messaging access
  • API keys for OpenAI, Anthropic, and Pinecone services

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 Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 228
Downloads 152

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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12