N8N Workflow: Find Medium SEO Keywords with Gemini + Google Sheets

Find Medium SEO keywords faster—automatically

This n8n workflow finds high-potential Medium keyword ideas by pulling topics from Google Trends RSS, Reddit, and Medium tag RSS feeds, then uses Google Gemini to score and generate Medium-style title options. Only ideas that meet your minimum SEO threshold get saved into Google Sheets for ongoing, weekly content planning.

What this workflow does

• Runs weekly (or on demand) via a schedule, or when you submit a “Set Up a New Niche” form.
• If you submit the niche form, Google Gemini suggests relevant subreddits and Medium tags, and the workflow saves that niche configuration into the Google Sheets “Niche Config” tab.
• Loads the active niche configuration and reads existing entries from Google Sheets to avoid re-scoring topics already captured and to remember previously seen competitor posts.
• Fetches fresh candidates from Google Trends RSS, top weekly Reddit threads for the chosen subreddits, and Medium tag RSS feeds used for competitor validation.
• Parses, de-duplicates, and filters topics—skipping anything already in the “Keyword Ideas” sheet and limiting the queue to a maximum number of candidates per run.
• For each remaining topic, Gemini generates three Medium-style title options and returns SEO and Medium-fit scores, plus intent and a short rationale.
• Appends only topics that meet the minimum SEO score threshold to the Google Sheets “Keyword Ideas” tab, and records newly discovered competitor post hashes in “Seen Competitor Posts”.

Use cases

• Generate Medium SEO keyword ideas weekly for a specific niche without manual research.
• Validate topic opportunities against competitor coverage using Medium tag RSS feeds.
• Use the “Set Up a New Niche” form to bootstrap new content niches with Gemini-recommended sources.

Technical details

• Integrations: Google Sheets, Google Gemini, RSS sources (Google Trends RSS, Reddit weekly threads, Medium tag RSS feeds).
• Workflow components/nodes (as provided): if, set, code, no op, sticky note, form trigger.