AI Agents

Connect Google Sheets with Slack

12 nodes 248 170 Webhook
Download

Workflow Description

An automation template connecting Google Sheets with Slack through an intelligent AI agent powered by OpenAI. It receives requests via webhook, processes and analyzes text using embeddings, retrieves data from vector storage, and automatically sends results to Slack channels.

How it works

  1. 1.Receive request via webhook and log it
  2. 2.Split text and generate OpenAI embeddings
  3. 3.Search Pinecone vector store and retrieve from memory
  4. 4.Execute AI agent and query Sheets data
  5. 5.Send results to designated Slack channel

Use cases

  • Analyze spreadsheet data and send intelligent summaries to your Slack team
  • Answer questions about Sheets data through interactive Slack conversations

Requirements

  • OpenAI and Pinecone API keys
  • Google Sheets account with access permissions
  • Slack workspace with posting privileges
  • Webhook endpoint or external service connection

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 AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 7
Views 248
Downloads 170

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

Pinecone Insert

Vector Store Pinecone

#5

Pinecone Query

Vector Store Pinecone

#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