AI Agents

Connect Google Sheets with Slack

12 nodes 223 154 Webhook
Download

Workflow Description

An intelligent agent automation that processes webhook requests using advanced language models, embeds text data, searches a vector database, retrieves relevant context, and automatically updates Google Sheets while posting results to Slack channels in real time.

How it works

  1. 1.Receive incoming webhook request and route to AI agent
  2. 2.Split text input and generate embeddings using OpenAI API
  3. 3.Search Weaviate vector store for contextual information
  4. 4.Process query with Anthropic LLM using buffer memory
  5. 5.Write response data to Google Sheets
  6. 6.Post results and notifications to designated Slack channel

Use cases

  • Automate customer inquiry handling from Slack to tracked documentation in Google Sheets
  • Build intelligent search system connecting spreadsheet data with real-time Slack conversations

Requirements

  • Active API keys for OpenAI and Anthropic services
  • Pre-configured Weaviate instance with network connectivity
  • Slack webhook URL and Google Sheets API credentials with edit permissions

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

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

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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12