AI Business Strategy Canvas Generator (GPT-4o + Tavily) for n8n

Turn market research into an Excel business plan—automatically

The AI Business Strategy Canvas Generator (GPT-4o + Tavily) for n8n runs a chat-based AI consultant that researches your market, builds Business Model Canvas, Lean Canvas, and/or SWOT outputs, converts them into a multi-sheet Excel (.xlsx), and emails the workbook to you via Gmail—while keeping conversation context in MongoDB.

What this workflow does

• Receives a new message in an n8n Chat session and forwards it to an OpenAI (GPT-4o) agent.
• Uses Tavily web search/research to ask targeted questions and generate research-backed canvas content during the conversation.
• Detects completion when the agent includes the marker [CANVAS_READY] in its chat output.
• Extracts the confirmed canvas details from the full conversation into a structured JSON using OpenAI with a strict schema parser.
• Generates an .xlsx workbook with one sheet per selected canvas, plus a positioning/next-steps sheet.
• Sends the Excel file as a Gmail attachment and posts a short confirmation message back to chat.
• Maintains chat memory using MongoDB so the consultant stays context-aware across turns.

Use cases

• SaaS operators turning a new idea into a validated Lean Canvas + SWOT with sources from Tavily.
• Automation engineers needing a repeatable GPT-4o + web research + spreadsheet workflow in n8n.
• Teams who want to iterate strategy quickly: refine inputs in chat, then receive an updated Excel workbook by email.

Technical details

• OpenAI (GPT-4o): canvas-generation agent and structured JSON extraction.
• Tavily: web search at https://api.tavily.com/search (replace the hardcoded key in the HTTP requests).
• MongoDB: chat memory (database N8N_Business_model_canvas_generator or update the configured name).
• Gmail: OAuth2 credential + email delivery of the generated .xlsx attachment.
• n8n nodes used: if, code, gmail, sticky note, n8nn8n-nodes-langchainchat, n8nn8n-nodes-langchainagent.