AI Agents

(ز) Google Sheets (كذاكرة)

17 nodes 223 119 Webhook
Download

Workflow Description

An advanced automation template combining an intelligent agent powered by Gemini with Google Sheets as a persistent memory system. The workflow processes queries, retrieves contextual data, and logs all interactions for continuous learning and optimization.

How it works

  1. 1.Receive incoming requests through a webhook endpoint
  2. 2.Pass the query to the AI agent for intelligent processing using Gemini
  3. 3.Query and retrieve relevant data from Google Sheets memory
  4. 4.Update sheets with new information and send the response back

Use cases

  • Build a knowledge base system that learns from user interactions over time
  • Maintain a complete audit trail of all queries and responses for compliance
  • Create a context-aware chatbot that uses historical data to improve recommendations

Requirements

  • Active Google account with edit permissions on target Sheets
  • Valid API credentials for Gemini language model access
  • Webhook configuration to accept incoming requests from external sources

Service Value

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

Apps Used

AI Agent Gemini Google Sheets

Details

Trigger Webhook
Nodes 17
Apps 3
Views 223
Downloads 119

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 (17)

/

Webhook

Webhook

#1

AI Agent

Agent

#2

Google Gemini Chat Model

Gemini Model

#3

Edit Fields

Set

#4

HTTP Request

HTTP Request

#5

Get History

Google Sheets

#6

Prepare Prompt

Set

#7

Save History

Google Sheets

#8

Sticky Note

Sticky Note

#9

Sticky Note1

Sticky Note

#10

Sticky Note2

Sticky Note

#11

Sticky Note3

Sticky Note

#12

Sticky Note4

Sticky Note

#13

Sticky Note5

Sticky Note

#14

Split History

Code

#15

Sticky Note6

Sticky Note

#16

Sticky Note7

Sticky Note

#17