AI Agents

Connect Google Sheets with Slack

12 nodes 239 147 Webhook
Download

Workflow Description

An automation template that connects Google Sheets with Slack using an intelligent agent that processes data through embeddings and memory, enabling automatic information retrieval and distribution across Slack based on user queries.

How it works

  1. 1.Receive request via Webhook and process for handling
  2. 2.Split text content and generate embeddings using Cohere
  3. 3.Store data in Weaviate vector store and perform searches
  4. 4.Process queries through OpenAI intelligent agent
  5. 5.Retrieve relevant information from Google Sheets
  6. 6.Send results automatically to Slack channels

Use cases

  • Search spreadsheet data intelligently and send results instantly to team members
  • Create automated alerts when data updates with delivery to Slack
  • Answer employee inquiries by linking databases to communication channels

Requirements

  • Valid API keys for OpenAI, Cohere, and Google Sheets
  • Webhook configuration for request handling and Slack channel setup

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 239
Downloads 147

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