Ensure required data tables exist using OpenAI and Google Gemini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 15 nodes and runs when another workflow calls it. Along the way it connects Google Gemini Chat Model and Data table.
How it runs
Trigger: When another workflow calls it.
- List data tables (Data table): work with table
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 8 tools (c1Table, c2Table, c3Table, c4Table…); memory: Simple Memory
- MatchingTableFound (If): checks a condition and branches into true / false
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Data table
n8n-nodes-base.dataTable - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Data Table Tool
n8n-nodes-base.dataTableTool
From the author
Quick overview This workflow is called by another n8n workflow to ensure a specific n8n Data Table exists, checking existing tables first and creating the table with an OpenAI-powered agent and Data Table tools when it is missing. How it works 1. Receives…