AI Agents

Intelligent Data Analysis and Google Sheets Automation

11 nodes 296 174 Webhook
Download

Workflow Description

This automation receives requests via webhook, processes text using advanced language models with contextual memory, stores knowledge in a vector database, and automatically writes results to Google Sheets. It combines natural language understanding with persistent data management for hands-free spreadsheet updates based on incoming queries.

How it works

  1. 1.Receive webhook requests and split text into processable chunks
  2. 2.Convert chunks to numerical vectors using Hugging Face embeddings
  3. 3.Store vectors in Supabase and retrieve contextually relevant information
  4. 4.Process requests through an AI agent while maintaining conversation history
  5. 5.Write analysis results and extracted data to Google Sheets

Use cases

  • Handle customer inquiries and automatically log responses in a centralized sheet
  • Analyze text reports and extract key data points for spreadsheet storage
  • Build an evolving knowledge base that learns from each new interaction

Requirements

  • Google Workspace account with edit permissions on Google Sheets
  • API keys for Hugging Face and Supabase services
  • Configured webhook to receive data from external applications or systems

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Text Splitter Embeddings Vector Store Memory Lm Chat Hf AI Agent Google Sheets

Details

Trigger Webhook
Nodes 11
Apps 7
Views 296
Downloads 174

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 Hf

#9

Agent

Agent

#10

Sheet

Google Sheets

#11