AI Agents

Connect Google Sheets with Slack

12 nodes 262 166 Webhook
Download

Workflow Description

A template that integrates Google Sheets data with Slack through an intelligent agent powered by Anthropic, processing and storing text in Pinecone vector database for accurate retrieval and automatic delivery to Slack channels.

How it works

  1. 1.Receive webhook request to trigger workflow execution
  2. 2.Process and split incoming text using Text Splitter module
  3. 3.Convert data to embeddings via Cohere and store in Pinecone vector database
  4. 4.Execute intelligent agent querying Google Sheets and retrieving relevant data
  5. 5.Send results and responses directly to specified Slack channels

Use cases

  • Answer employee questions about company spreadsheet data in real-time via Slack
  • Analyze and summarize stored document content with automatic team notification
  • Retrieve customer or project information from Google Sheets and share it in Slack conversations instantly

Requirements

  • Connected Google Workspace account with Google Sheets API access enabled
  • Slack workspace with permissions to create and manage bot applications
  • API keys for Cohere, Pinecone, and Anthropic services

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Text Splitter Embeddings Vector Store Memory Anthropic AI Agent Google Sheets Slack

Details

Trigger Webhook
Nodes 12
Apps 8
Views 262
Downloads 166

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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12