Connect Google Sheets to n8n AI Agent: The Complete "Tools" Tutorial

00:00 - Intro: Using "Expression Mode" for System Prompts
00:43 - Q&A: Can we use PDFs/Docs instead of typing text?
02:09 - Theory: Context vs. RAG vs. Fine-Tuning (What's the difference?)
11:36 - Adding the "Google Sheets" Tool to the AI Agent
12:43 - Setting up Google Credentials (One-click Sign-in)
16:00 - Critical Step: Manually configuring the "Tool Description"
20:35 - Connecting the Sheet via URL
23:56 - Executing the Tool Node (Testing the connection)
25:41 - Updating the System Prompt to reference the Tool
27:45 - Live Test: Asking the AI to summarize iPhone stock
30:06 - Troubleshooting: What to do if the AI can't find the price

Description
In this section, we move beyond simple text responses and give our AI Agent access to real-time data .

I explain the difference between RAG (Retrieval Augmented Generation), Fine-Tuning, and Tool Calling. Then, we walk through the step-by-step process of connecting a Google Sheet to the AI Agent so it can look up specific data (like iPhone stock and prices) dynamically.

Key concepts covered:

Tools: How to connect external apps (Google Sheets) to the AI Agent node.

Tool Descriptions: The secret to making the AI "understand" when to use the spreadsheet.

Troubleshooting: Why you must "Save" and "Refresh" if the AI isn't finding your data.

#n8n #GoogleSheets #AIAutomation #NoCode #GeminiAPI

Видео Connect Google Sheets to n8n AI Agent: The Complete "Tools" Tutorial канала Chan Wei Khjan