Generate Deep Research Markdown Reports with GPT, Tavily Search, and Google Sheets
Go to Workflow
Archit Jain
Description
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
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.