Automate deep research using N8N & generate report using Tavily

How it works

• User submits a search topic through a form.
• AI generates five deep-dive subtopics for that main topic.
• AI creates a research report intro, title, and table of contents based on those topics.
• Each subtopic is sent to a search API (Tavily) to collect top 5 sources.
• AI writes detailed Markdown content for each subtopic using retrieved sources.
• Final content, ToC, intro, and clickable sources are saved to a Google Sheet.

Set up steps

• Requires connections to OpenRouter (AI), Tavily (search API), and Google Sheets.
• Import into n8n and connect credentials for the above services.
• Configure Google Sheet with proper column headers and grant edit access.
• Estimated setup time: 20–30 minutes with working API keys.
• Includes embedded instructions and markdown-style annotations for guidance.