AI Agents

Connect Google Sheets with Slack

12 nodes 220 157 Webhook
Download

Workflow Description

An automation template that integrates Google Sheets with Slack using an intelligent AI agent powered by advanced language models. It receives requests via webhook, processes them using embedding and memory techniques, and automatically sends results to Slack channels and conversations.

How it works

  1. 1.Receive incoming webhook requests and parse user input text
  2. 2.Convert data into numerical embeddings and store them in a vector database
  3. 3.Execute the intelligent agent to search and respond to data queries
  4. 4.Retrieve relevant data from Google Sheets based on context and user request
  5. 5.Send formatted responses to designated Slack channels or direct messages

Use cases

  • Enable employees to ask questions about company data stored in Google Sheets directly through Slack without manual lookup
  • Automatically generate and deliver intelligent reports to team channels based on complex data queries processed by the AI agent

Requirements

  • Google account with access permissions to the required Google Sheets
  • Slack workspace account with message posting and conversation reading permissions
  • API keys for Anthropic, Cohere, and Supabase services

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Text Splitter Embeddings Vector Store Memory Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 220
Downloads 157

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

Supabase Insert

Vector Store Supabase

#5

Supabase Query

Vector Store Supabase

#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