AI Agents

Connect Google Sheets with Slack

12 nodes 223 152 Webhook
Download

Workflow Description

An intelligent automation that receives data via webhook, processes it through an AI agent using OpenAI models, stores embeddings in Weaviate vector database, and automatically sends results to Slack and Google Sheets for centralized tracking and collaboration.

How it works

  1. 1.Receive incoming request via webhook and trigger workflow execution
  2. 2.Process text by splitting into chunks and converting to Cohere embeddings
  3. 3.Store embeddings in Weaviate database and maintain conversation memory context
  4. 4.Execute intelligent agent using OpenAI for analysis and reasoning tasks
  5. 5.Write results to Google Sheets and send summary notifications to Slack

Use cases

  • Automatically process customer inquiries and organize responses in shared documents
  • Analyze large documents and datasets, delivering AI-powered summaries to teams
  • Collect external data sources and intelligently classify or categorize them

Requirements

  • Active OpenAI account with API access and sufficient credits
  • Connected Google Sheets workspace and Slack channel workspace
  • Weaviate vector database instance (self-hosted or cloud-managed)

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 223
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

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