AI Agents

Automate Google Sheets

11 nodes 215 157 Webhook
Download

Workflow Description

Advanced template integrating an intelligent agent with Google Sheets. Receives data via webhook, processes it using language models and vector storage, then writes results directly to Google Sheets with full automation.

How it works

  1. 1.Receive data via webhook and trigger the workflow
  2. 2.Split texts and generate embeddings using Cohere model
  3. 3.Search Supabase vector store and retrieve relevant information
  4. 4.AI agent interacts with HuggingFace language model and buffer memory
  5. 5.Process queries and responses through the memory system
  6. 6.Write final results to the specified Google Sheets worksheet

Use cases

  • Document frequently asked questions with intelligent answers in a centralized spreadsheet
  • Automatically process customer inquiries and log them in a data sheet
  • Analyze documents, generate summaries, and store results in Google Sheets

Requirements

  • Valid API keys for Cohere and HuggingFace services
  • Active Supabase account with configured vector database
  • Sufficient permissions in Google Sheets and OAuth access credentials

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 215
Downloads 157

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 Hf

#9

Agent

Agent

#10

Sheet

Google Sheets

#11