AI Agents

Connect Google Sheets with Slack

12 nodes 239 162 Webhook
Download

Workflow Description

An intelligent automation connects Google Sheets with Slack, where an AI agent processes data using OpenAI models and Pinecone vector storage, automatically sending results to Slack for immediate team review and collaboration.

How it works

  1. 1.Receive data from Google Sheets via webhook trigger
  2. 2.Split and process text content using Text Splitter
  3. 3.Convert data to vector embeddings via Cohere model
  4. 4.Search Pinecone vector store and retrieve relevant results
  5. 5.Process findings with OpenAI intelligent agent
  6. 6.Send summaries and responses to Slack channel

Use cases

  • Analyze spreadsheet data and send automated summaries to team channels
  • Answer employee questions about stored data directly in Slack
  • Monitor new spreadsheet updates and notify the team in real time

Requirements

  • Google Sheets account with read and write permissions
  • API keys for OpenAI, Cohere, and Pinecone services
  • Webhook endpoint and configured Slack channel for message delivery

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 162

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

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