AI Agents

Connect Google Sheets with Slack

12 nodes 211 159 Webhook
Download

Workflow Description

An intelligent agent receives data via webhook, processes it using OpenAI language models with conversational memory, stores it in Pinecone vector database, and automatically sends results to Slack with full context retention.

How it works

  1. 1.Receive incoming requests through webhook and split large text into manageable chunks
  2. 2.Convert data into vector embeddings using Cohere to enable semantic search
  3. 3.Store vectors in Pinecone and retrieve contextually relevant information efficiently
  4. 4.Execute an AI agent powered by OpenAI with continuous memory for stateful conversations
  5. 5.Fetch or update data records in Google Sheets based on agent decisions
  6. 6.Deliver summaries and final results to specified Slack channels in real-time

Use cases

  • Monitor spreadsheet changes and alert teams automatically when critical updates occur
  • Build intelligent customer support systems that reference sheet data and respond in Slack
  • Document and analyze business data using AI while maintaining complete conversation history

Requirements

  • Active OpenAI API account with access to chat completion models
  • Cohere API key and Pinecone account for vector storage and retrieval
  • Google Sheets with appropriate permissions and Slack workspace with 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 211
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

Similar Templates

Automate Google Sheets

11 nodes

Connect Telegram with Google Docs

23 nodes

Connect Telegram with OpenAI

15 nodes

Automated workflow

10 nodes

Build an intelligent agent processing inquiries with memory and tools

17 nodes

Connect Google Sheets with Slack

12 nodes