n8n AI Agent for Google Sheets Automation | Items & Stock Validation

Описание: In this video, you’ll learn how to build a smart AI Agent in n8n that connects to multiple Google Sheets to answer product and inventory questions accurately and reliably.

This AI Agent is designed to:

🔍 Always check BOTH Items and Stock sheets

📦 Validate product availability and stock quantity

🧠 Follow a strict reasoning flow before answering

🗣️ Respond in plain English (NO JSON responses)

❌ Never guess stock values

❌ Never answer availability without checking the Stock sheet

🧩 Sheets Used in This Automation:

1️⃣ Items Sheet (Product Master)

ID

Name

Category

Price

2️⃣ Stock Sheet (Inventory)

ID

Name

Category

Stock Quantity

The AI Agent matches products using Item ID first, with Item Name as fallback, and treats missing stock entries as out of stock.

🤖 What You’ll See in This Demo:

n8n AI Agent configuration

Google Sheets integration (multiple read nodes)

Strict system prompt enforcement

Inventory-aware AI responses

Human-friendly answers like:

“Chicken Burger is currently out of stock.”

“Large Pizza costs $12 and 5 are available.”

🎯 Use Cases:

Inventory chatbots

Restaurant ordering assistants

E-commerce product availability checks

Internal stock inquiry bots

AI-powered business assistants

🛠️ Tools & Tech:

n8n AI Agent

Google Sheets

Gemini / LLM Chat Model

Prompt Engineering for Validation Logic