AI Agents

Automate Google Sheets with Intelligent Agent and Memory

11 nodes 294 181 Webhook
Download

Workflow Description

A workflow combining an AI agent powered by Anthropic's Claude model with conversational memory and semantic embeddings to process sheet requests automatically. It splits text content, computes embeddings in Supabase's vector store, and writes results directly to Google Sheets via webhook triggers.

How it works

  1. 1.Receive webhook request and activate the AI agent
  2. 2.Split input text and generate semantic embeddings
  3. 3.Search vector store and retrieve relevant context
  4. 4.Process request using dialogue memory and log results to Google Sheets

Use cases

  • Automated data analysis assistant that understands repeated question context
  • Self-managing knowledge repository with automatic responses

Requirements

  • Anthropic API key for Claude access
  • Supabase account with configured vector database
  • Google Sheets with write 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 294
Downloads 181

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