n8n Workflow: Find SEO Keywords & Medium Titles via Trends + Reddit + Gemini

Find Medium SEO keyword ideas and fresh post title angles automatically—using Google Trends, Reddit, and Google Gemini

This n8n workflow discovers high-potential Medium topics by combining Google Trends signals, Reddit discussion activity, and Medium tag feeds—then uses Google Gemini to generate three Medium-style title options with SEO scoring and saves the best keyword ideas into Google Sheets for ongoing publishing.

What this workflow does

• Runs weekly or on demand via an n8n form submission to set (or update) the active blog niche.
• Generates niche guidance when the form is used: Google Gemini suggests relevant subreddits and Medium tag slugs, and the workflow stores the niche configuration in a Google Sheets “Niche Config” tab.
• Loads the active niche and reads prior entries from Google Sheets tabs like “Keyword Ideas” and “Seen Competitor Posts” to prevent duplicates across runs.
• Collects candidate topics from:
  • Google Trends RSS feed
  • Reddit weekly top listing
  • Medium tag RSS feeds (for competitor validation)
• Normalizes, deduplicates, and filters candidates, excludes already-logged ideas, and limits the queue to a configured maximum per run.
• Uses Google Gemini to produce 3 Medium-style titles per qualifying topic, including SEO and Medium-fit scores.
• Writes results to Google Sheets: appends high-scoring keyword ideas to “Keyword Ideas” and records newly seen competitor post hashes in “Seen Competitor Posts”.

Use cases

• SaaS teams publishing on Medium and needing reliable SEO keyword discovery tied to current trends.
• Automation engineers building an n8n content ideation system that continuously mines trends and avoids duplicate targets.
• Operators who want to validate topics against competitor post history before investing writing time.

Technical details

• Schedule + form trigger to set/update the active niche
• Google Sheets read/write for “Niche Config”, “Keyword Ideas”, and “Seen Competitor Posts”
• Data processing with nodes including if, set, code, no op, and sticky note
• Generation of Medium headline options using Google Gemini and scoring against a configured SEO threshold