AI Agents

Automate Google Sheets with Intelligent Agent

11 nodes 325 172 Webhook
Download

Workflow Description

This template combines a smart agent powered by language models and conversational memory with Redis vector storage for context retrieval. It processes text data, generates intelligent responses, and updates Google Sheets automatically via webhook triggers.

How it works

  1. 1.Receive data through webhook and split text into processable segments
  2. 2.Convert text to embeddings and store them in Redis for fast retrieval
  3. 3.Activate an intelligent agent using language models with conversation memory to answer queries
  4. 4.Write results and responses directly to Google Sheets

Use cases

  • Process customer inquiries and automatically document them in work spreadsheets
  • Analyze and classify text data while saving results to Sheets

Requirements

  • Valid API keys for OpenAI and Hugging Face models
  • Active Redis connection and configured Google Sheets access

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

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

Details

Trigger Webhook
Nodes 11
Apps 7
Views 325
Downloads 172

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

OpenAI

#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