π¬ Generate podcast topic ideas from RSS feeds with Gemini, SerpAPI and Notion
β‘ 66 views Β· π¬ Content Creation & Video
Description
3PODCAST TOPIC RESEARCH 1.jpgπ€ Automated AI content researcher: YouTube & RSS to Notion via Gemini
This workflow is basically my shortcut for researching popular topics to create podcast content on without spending all day on YouTube, scrolling X and reading websites.
It grabs the latest videos and articles from the last 24 hours, runs them through Gemini Pro (with SerpAPI to double-check inputs), and then spits out actual content hooks and thumbnail ideas.
Everything gets cleaned up into a neat Notion database so I can just log in, see whatβs hot, and start working on the podcast.
What you need To use this workflow, you need credentials for the following services:
Google Gemini API: (Free tier available via Google AI Studio) for the LLM.
SerpAPI: To allow the AI Agent to browse live Google search results.
Google Sheets: To maintain your list of target RSS feeds.
Notion: For storing the researched content.
Telegram: For mobile notifications.
Resources Video Tutorial: https://youtu.be/IoHayi68Ckk
Created by: Scalo Labs
π Nodes Used
Google Sheets, RSS Read, Telegram, Notion, Schedule Trigger, Filter
π₯ Import
Download workflow.json and import into n8n:
Workflow menu β Import from File