AI Agents

Automate Google Sheets

11 nodes 208 163 Webhook
Download

Workflow Description

Deploy an AI agent that receives data via webhook, splits text into chunks, generates embeddings using Hugging Face, stores vectors in Supabase, and uses Anthropic's language model with memory to process queries and automatically update Google Sheets with results and insights.

How it works

  1. 1.Receive incoming data through webhook and trigger the automation workflow
  2. 2.Split text into manageable chunks using character-level text splitting
  3. 3.Generate embeddings from text using Hugging Face embedding model
  4. 4.Store vector data in Supabase database for semantic search capabilities
  5. 5.Process user queries through Anthropic AI agent with contextual memory
  6. 6.Update Google Sheets with results, metadata, and new information automatically

Use cases

  • Automatically process and organize large volumes of text data into Google Sheets
  • Answer intelligent questions about stored documents and data using semantic search
  • Build and maintain a searchable knowledge base that updates in real-time

Requirements

  • Active Anthropic API key with sufficient credits
  • Supabase credentials and configured database instance
  • Google account with edit permissions for target spreadsheets

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 208
Downloads 163

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