n8n

How to Automate Notion Research Reports?

Turn a simple request from Telegram or an incoming webhook into a finished research report in Notion. Teams use it to plan topics, search the web, extract key facts, and save a clean summary without manual work.

The flow starts when a message arrives in Telegram or through a webhook. A memory step keeps the chat session so the agent can ask follow up questions and confirm the topic. A strategy agent clarifies scope, a query agent creates up to three short search queries, and the workflow loops over each query. It calls the Tavily API to get results and extract content, then uses an AI model to draft findings. Results are combined, converted to markdown and HTML, turned into Notion blocks, and saved to a Notion database. You get a link back and a notification when the report is ready.

Set up needs API keys for one AI model provider, Tavily, and Notion, plus a Telegram bot if you want chat entry. Expect research time to drop from hours to minutes while keeping a clear record in Notion. Use it for content briefs, market snapshots, sales one pagers, or FAQ drafts at scale.

What are the key features?

  • Telegram and Webhook triggers capture requests from chat or any app
  • Session memory keeps context using chat id or a custom session id
  • Strategy agent clarifies goals and confirms next steps
  • Search query agent generates up to three keyword based queries with a structured parser
  • Loop over queries to call Tavily search and extract page content
  • AI models from OpenAI, Google Gemini, or OpenRouter draft and refine summaries
  • Aggregate results, convert markdown to HTML, and build Notion blocks
  • Save the final report and metadata to a Notion database
  • Respond to webhook to acknowledge requests and return links

What are the benefits?

  • Reduce manual research from 3 hours to 15 minutes per topic
  • Automate 80 percent of query building, searching, and extraction
  • Improve reporting consistency by saving a standard format in Notion
  • Handle multiple requests at once with batch query loops
  • Connect Telegram, Notion, Tavily, and your chosen AI model in one flow

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Telegram, Notion, OpenAI, Google Gemini, OpenRouter and Tavily. See the Tools Required section above for links to create accounts with these services.
  3. Create a Telegram bot using BotFather and copy the bot token. In n8n, open the Telegram Trigger node, choose Create new credential, and paste the token. Start a chat with the bot so it can receive messages.
  4. Open the Webhook node. Copy the Test URL for testing and the Production URL for live use. If another app will trigger it, set that app to send a POST request with JSON fields session_id and message.
  5. In Notion, create an internal integration and copy the secret. Share your target database with the integration. In n8n, open a Notion node, create a new credential, paste the secret, and select your database.
  6. Get a Tavily API key from the Tavily dashboard. In n8n, open each Tavily HTTP Request node, choose Create new credential for HTTP Custom Auth, and add the API key in the header field required by Tavily.
  7. Choose one AI provider. For OpenAI, create an API key then open the OpenAI nodes and add a new API Key credential. For Google Gemini, create an API key and add it in the Google Gemini Chat Model node. For OpenRouter, create an API key and add it in the OpenRouter Chat Model nodes.
  8. Review the Strategy Agent and Search Query Agent prompts. Adjust tone, depth, and query count to match your use case. Keep the structured output parser schemas as is to avoid errors.
  9. Map Notion fields in the Notion nodes. Set the page title, content blocks, tags, and any status or owner fields to your database properties.
  10. Open the Respond to Webhook nodes and confirm the success messages include the Notion page link or task id. Update the message text to fit your team style.
  11. Run a test. Send a Telegram message to the bot or post to the webhook with a topic. Check the Execution log in n8n, confirm Tavily calls succeed, and verify a new page appears in Notion.
  12. If Notion returns permission errors, make sure you shared the database with the integration. If Tavily returns 401, recheck the API key. If Telegram does not respond, confirm the bot token and that you started the chat.
  13. Scale up by increasing the batch size in the Loop Over Queries node and by selecting a smaller or larger AI model to balance cost and speed.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Google Gemini

Sign up

Free tier: $0 via Gemini API; e.g., Gemini 2.5 Flash-Lite free limits 1,000 requests/day (15 RPM, 250k TPM). Paid from $0.10/1M input tokens and $0.40/1M output tokens.

Notion

Sign up

Free plan: $0 per member / mo (Public API included)

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

OpenRouter

Sign up

Free models: $0 via API, 20 requests/min; 50/day or 1000/day with ≥10 credits

Tavily

Sign up

Free plan: $0 / mo, 1,000 API credits / mo

Telegram

Sign up

Free: $0, Telegram Bot API usage is free for developers

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.