AI Agents

Connect Google Sheets with Slack

12 nodes 211 121 Webhook
Download

Workflow Description

Automation template integrating Google Sheets with Slack through an intelligent AI agent powered by OpenAI. Receives requests via webhook, processes data using embeddings and vector techniques, then automatically delivers results to Slack while maintaining conversation context.

How it works

  1. 1.Receive webhook request and process text data using Text Splitter for optimal chunking
  2. 2.Generate vector embeddings using Cohere and store them in Supabase for semantic search
  3. 3.Activate the OpenAI-based intelligent agent to analyze and process the query
  4. 4.Query the vector database to retrieve relevant context and information
  5. 5.Send analyzed results and response to the specified Slack channel

Use cases

  • Analyze Google Sheets data and send intelligent summaries to your team directly in Slack
  • Answer data-related questions about spreadsheets stored in Google Sheets without leaving Slack

Requirements

  • Active API keys for OpenAI and Cohere services
  • Configured Supabase account for vector storage and database management
  • Accessible webhook endpoint with proper permissions configured for Google Sheets and Slack

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 211
Downloads 121

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

OpenAI

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12