AI Agents

Automate Google Sheets with AI Agent and Semantic Processing

11 nodes 331 179 Webhook
Download

Workflow Description

An automation template combining a Claude-powered AI agent with advanced text processing techniques to automate Google Sheets operations. It segments text into embeddings, stores them in a vector database, maintains conversation context, and executes complex spreadsheet tasks with precision.

How it works

  1. 1.Receive requests via webhook and trigger the AI agent
  2. 2.Split text and convert into semantic embeddings using Cohere
  3. 3.Search vector store and retrieve relevant data from Supabase
  4. 4.Maintain conversation memory and execute actions on Google Sheets

Use cases

  • Process conversational requests and update spreadsheets based on intent
  • Extract information from documents and organize it into structured tables
  • Answer queries about spreadsheet data using contextual memory from previous interactions

Requirements

  • Anthropic API key configured and valid
  • Supabase vector store database set up and connected
  • Google Sheets credentials with edit permissions enabled

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 331
Downloads 179

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 Cohere

#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