AI Agents

Connect Google Sheets with Slack

12 nodes 242 158 Webhook
Download

Workflow Description

An intelligent automation that connects Google Sheets with Slack using AI agents. Processes spreadsheet data, analyzes it through embeddings and vector search, and automatically sends smart messages to Slack channels based on extracted insights.

How it works

  1. 1.Receive webhook request and split text using Text Splitter
  2. 2.Convert data to embeddings via Cohere and store in Pinecone vector database
  3. 3.Activate AI agent with conversation memory to understand context
  4. 4.Retrieve relevant data from vector search
  5. 5.Generate smart message through OpenAI and send to Slack
  6. 6.Read or update Google Sheets data as needed

Use cases

  • Send automated reports from spreadsheets to Slack channels with intelligent analysis
  • Answer team questions about spreadsheet data directly through Slack

Requirements

  • Active OpenAI API account with valid API key
  • Slack workspace with bot permissions to send messages
  • Organized Google Sheets with appropriate sharing permissions
  • Pinecone account and configured vector space

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 242
Downloads 158

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