Hi everyone,
I’m building a large workflow that will eventually use more than 10 Google Sheets operations (read, lookup, update, etc.). I’m unsure which approach is better in terms of performance, reliability, and best practice:
Option 1:
Use Google Sheets via the AI Agent Tools, so the agent reads and interprets the data directly.
Option 2:
Use separate Google Sheets nodes in the workflow and then pass that structured data into the AI agent.
I’m trying to understand which approach is more stable, easier to manage, and more cost-efficient—especially when doing many lookups across multiple sheets.
Additional Question:
If using AI Agent Tools is the recommended approach, should I load all my Google Sheets into a single AI agent node?
I noticed that the more tools and instructions I put into one AI agent’s system prompt, the more complex and confusing it becomes for the agent. Because of this, I’m wondering:
-
Is it better to separate the sheets into smaller groups?
-
For example, maybe one AI agent for 3 sheets, another AI agent for another 3 sheets, etc.?
-
Does splitting them improve accuracy and reduce confusion?
-
Or is a single agent with many tools still the best practice?
Any guidance from people who have tried both methods would be really appreciated.
Thanks!