AI Agents

Automate Google Sheets Data Processing with AI Agent

11 nodes 227 163 Webhook
Download

Workflow Description

Intelligent automation receives data via Webhook and processes it using an advanced language model with memory and semantic search capabilities, then automatically logs results in Google Sheets.

How it works

  1. 1.Receive data through Webhook and split it into manageable text chunks
  2. 2.Convert text to embeddings and store in Vector Store for semantic search
  3. 3.Process queries using an AI Agent powered by HuggingFace language model with contextual memory
  4. 4.Record results and outputs directly in Google Sheets

Use cases

  • Index large documents and datasets, converting unstructured text into organized spreadsheet tables
  • Answer questions about stored data and automatically document query results in sheets

Requirements

  • Google account with access permissions to Google Sheets
  • API keys for Cohere, HuggingFace services, and Redis connection for storage

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 227
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 Cohere

#4

Insert

Vector Store Redis

#5

Query

Vector Store Redis

#6

Tool

Tool Vector Store

#7

Memory

Memory Buffer Window

#8

Chat

Lm Chat Hf

#9

Agent

Agent

#10

Sheet

Google Sheets

#11