AI Agents

Connect Google Sheets with Slack

12 nodes 231 148 Webhook
Download

Workflow Description

Intelligent automation connecting Google Sheets and Slack through an AI agent powered by Anthropic, extracting and processing data with embeddings and memory, then automatically sending updates and alerts to designated Slack channels.

How it works

  1. 1.Receive request via webhook and activate the intelligent agent
  2. 2.Split data texts and compute embeddings to understand context
  3. 3.Search Pinecone and retrieve relevant records from Google Sheets
  4. 4.Process information using buffer memory and generate response via Anthropic
  5. 5.Send results and suggested actions to Slack

Use cases

  • Instantly notify sales team when new clients are added to spreadsheets
  • Send Slack alerts when performance metrics exceed defined thresholds
  • Perform intelligent search across spreadsheet data and respond via Slack

Requirements

  • Google Sheets API key with access permissions to required spreadsheets
  • Active Slack workspace with permissions to post messages in channels
  • Anthropic, Cohere, and Pinecone API keys for processing and storage

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 231
Downloads 148

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