Deploy Notion Chat Assistants via OpenAI + n8n API

Generate and Deploy a Notion Chat Assistant Workflow to Your n8n—Automatically

This n8n workflow turns a single chat message containing a Notion database URL into a tailored Notion-search chat assistant workflow, validates the generated n8n JSON, and then deploys it to your n8n instance via the n8n REST API (or returns the JSON if deployment fails).

What this workflow does

• Receives a chat message with a Notion database URL inside n8n chat.
• Fetches the database schema using the Notion API and simplifies the property list for prompting.
• Uses OpenAI to generate a customized n8n chat-assistant workflow JSON configured to query and read pages from your specific Notion database.
• Validates the generated workflow JSON, including checks for a known Notion query jsonBody placeholder issue and overall n8n workflow JSON validity.
• Retries generation with feedback up to the configured limit if validation fails.
• Deploys the new workflow by building a deployment payload from the generated nodes and connections and calling the n8n REST API.
• Responds in chat with a direct link to the deployed workflow, or returns the generated JSON for manual import if the API call fails.

Use cases

• Create a Notion Q&A/chat assistant for a specific database (e.g., projects, knowledge base, tickets) without writing the n8n workflow from scratch.
• Rapidly generate multiple database-specific assistants for different teams or SaaS tenants.
• Give non-technical operators an easy way to produce a working n8n automation by providing only a Notion database URL.

Technical details

• Integrations: Notion, OpenAI, and n8n REST API workflow deployment.
• n8n nodes mentioned in the workflow: if, set, code, merge, notion, switch.
• Required setup: Notion API credentials + shared databases, OpenAI API credential for generation/validation, and an n8n API key using an HTTP header credential X-N8N-API-KEY.