Generate Deep Research Markdown Reports with GPT, Tavily Search, and Google Sheets

This workflow generates deep researched report in markdown format and saves it in Google Sheet, that I then use for generating blogs for my website - Architjn Blogs

How it works

1. User submits a search topic through a form.
2. AI generates five deep-dive subtopics for that main topic.
3. AI creates a research report intro, title, and table of contents based on those topics.
4. Each subtopic is sent to a search API (Tavily) to collect top 5 sources.
5. AI writes detailed Markdown content for each subtopic using retrieved sources.
6. 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.