AI Agents

Connect Google Sheets with Slack

12 nodes 236 158 Webhook
Download

Workflow Description

Intelligent automation connecting Google Sheets with Slack using an AI agent powered by Anthropic. The template receives data via webhook, processes it through embeddings and vector search, then sends organized results to Slack channels automatically.

How it works

  1. 1.Receive webhook request containing data or query
  2. 2.Split and convert text to embeddings using Cohere
  3. 3.Search Pinecone vectors to find relevant data from Google Sheets
  4. 4.Process context through memory and Anthropic AI agent
  5. 5.Formulate response and send to Slack

Use cases

  • Answer employee questions about company data stored in Sheets directly in Slack
  • Monitor spreadsheets and automatically alert your team when changes occur

Requirements

  • API keys for Anthropic, Cohere, and Pinecone
  • Google Sheets spreadsheet containing the data to search
  • Slack channel or workspace with proper bot permissions
  • Configured and enabled webhook

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 236
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

Lm Chat Anthropic

#9

RAG Agent

Agent

#10

Append Sheet

Google Sheets

#11

Slack Alert

Slack

#12