AI Agents

Connect Google Sheets with Slack

12 nodes 213 159 Webhook
Download

Workflow Description

An advanced n8n automation that links Google Sheets with Slack through an AI-powered agent backed by OpenAI. It processes spreadsheet data using Cohere embeddings and Pinecone vector storage, delivering intelligent responses directly to Slack.

How it works

  1. 1.Receive trigger via webhook and initialize workflow execution
  2. 2.Extract and parse data from Google Sheets using text splitting
  3. 3.Convert extracted content to embeddings and store in Pinecone vector database
  4. 4.Process user queries through OpenAI agent with conversation memory
  5. 5.Route intelligent responses to designated Slack channels

Use cases

  • Enable teams to query business data stored in Google Sheets through Slack conversations
  • Automate data summarization and analysis delivery to team channels for real-time insights

Requirements

  • Active OpenAI API account with sufficient credits
  • Pinecone vector database instance configured
  • Google Sheets access permissions and Slack bot token

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 213
Downloads 159

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