Ensure n8n Data Table with Gemma Chat Agent + Tools

Automatically ensure your n8n Data Table exists—using an OpenAI chat agent when it’s missing

This workflow is designed to be called by another n8n workflow. It checks whether a specific n8n Data Table already exists, and if not, it creates the table using an OpenAI-powered agent with the appropriate Data Table tool—so your automations won’t fail due to missing storage.

What this workflow does

• Accepts inputs via an Execute Workflow trigger: a target table_name and desired table_structure.
• Lists all existing n8n Data Tables and iterates through them to find a matching table name.
• Sets a flag in execution data when the table is already present.
• If the table is not found, sends the requested table_name and columns to an OpenAI chat model through an AI agent.
• The AI agent then selects the appropriate n8n Data Table tool (supports 1–5 columns) and creates the new Data Table with generated column names.
• Designed to be executed as part of a larger “master” workflow, ensuring tables are created automatically when required.

Use cases

• Prevent runtime errors in SaaS automation when downstream workflows rely on a specific Data Table.
• Initialize storage for multi-step onboarding flows that need a table for user or event tracking.
• Make deployment safer by ensuring required n8n Data Tables are created automatically during workflow setup.

Technical details

• Triggers/logic: Execute Workflow trigger, if, iteration with batching (split in batches), and execution data flags.
• AI integration: OpenAI Chat Model accessed via an AI agent, with tool-based table creation.
• Core tools: Data Table, Data Table Tool (1–5 columns), plus supporting workflow nodes (e.g., sticky note).
• Setup requirement: Add an OpenAI API credential for the OpenAI Chat Model, and confirm Data Tables are enabled and the executing user can list/create tables.

Automatically create table if not exists from a SubNode—so your n8n workflows stay reliable as they scale.