AI Agents

Automate Google Sheets

11 nodes 216 169 Webhook
Download

Workflow Description

An automation template that enables intelligent management of Google Sheets using an AI agent powered by Claude. It processes text data, stores embeddings in a vector database, and automatically updates sheets in response to webhook requests with natural language understanding.

How it works

  1. 1.Receive webhook request and initiate workflow
  2. 2.Split and process text using Text Splitter component
  3. 3.Generate embeddings from text via Hugging Face model
  4. 4.Store and retrieve vectors from Supabase vector store
  5. 5.Query AI agent powered by Claude for intelligent responses
  6. 6.Write results back to Google Sheets automatically

Use cases

  • Maintain dynamic knowledge bases with intelligent semantic search capabilities
  • Automatically update Google Sheets reports based on natural language queries

Requirements

  • Anthropic API key for Claude model access
  • Supabase project with configured vector database
  • Google Sheets API credentials and proper permissions

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

Details

Trigger Webhook
Nodes 11
Apps 7
Views 216
Downloads 169

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 (11)

/

Sticky

Sticky Note

#1

Webhook

Webhook

#2

Splitter

Text Splitter Character Text Splitter

#3

Embeddings

Embeddings Hugging Face

#4

Insert

Vector Store Supabase

#5

Query

Vector Store Supabase

#6

Tool

Tool Vector Store

#7

Memory

Memory Buffer Window

#8

Chat

Lm Chat Anthropic

#9

Agent

Agent

#10

Sheet

Google Sheets

#11