AI Agents

Analyze Google Sheets and send intelligent summaries to Slack

12 nodes 300 176 Webhook
Download

Workflow Description

An automation that connects Google Sheets with Slack through an AI agent, analyzing tabular data and extracting key insights automatically. The system delivers real-time alerts and smart summaries directly to team channels, enabling data-driven decisions.

How it works

  1. 1.Receive Google Sheets data via webhook trigger
  2. 2.Split and process text with Cohere embeddings
  3. 3.Query Weaviate vector store for contextual information
  4. 4.Execute AI agent logic using OpenAI with conversation memory
  5. 5.Format and deliver results to designated Slack channels

Use cases

  • Alert teams instantly when critical data changes in spreadsheets
  • Generate and send automated daily data summaries to Slack
  • Answer team questions about sheet data using AI analysis

Requirements

  • Connected Google Sheets account with shared document access
  • Slack workspace with bot permissions and channel access
  • OpenAI and Cohere API credentials configured
  • Weaviate instance set up for vector storage

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 300
Downloads 176

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