{"product_id":"n8n-workflow-find-medium-seo-keywords-with-gemini-google-sheets","title":"N8N Workflow: Find Medium SEO Keywords with Gemini + Google Sheets","description":"\u003ch3\u003eFind Medium SEO keywords faster—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow finds high-potential Medium keyword ideas by pulling topics from Google Trends RSS, Reddit, and Medium tag RSS feeds, then uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to score and generate Medium-style title options. Only ideas that meet your minimum SEO threshold get saved into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for ongoing, weekly content planning.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly (or on demand)\u003c\/strong\u003e via a schedule, or when you submit a “Set Up a New Niche” form.\u003c\/li\u003e\n  \u003cli\u003eIf you submit the niche form, \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e suggests relevant \u003cstrong\u003esubreddits\u003c\/strong\u003e and \u003cstrong\u003eMedium tags\u003c\/strong\u003e, and the workflow saves that niche configuration into the \u003cstrong\u003eGoogle Sheets “Niche Config”\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eLoads the active niche configuration and reads existing entries from Google Sheets to \u003cstrong\u003eavoid re-scoring\u003c\/strong\u003e topics already captured and to remember previously seen competitor posts.\u003c\/li\u003e\n  \u003cli\u003eFetches fresh candidates from \u003cstrong\u003eGoogle Trends RSS\u003c\/strong\u003e, \u003cstrong\u003etop weekly Reddit threads\u003c\/strong\u003e for the chosen subreddits, and \u003cstrong\u003eMedium tag RSS feeds\u003c\/strong\u003e used for competitor validation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses, de-duplicates, and filters\u003c\/strong\u003e topics—skipping anything already in the “Keyword Ideas” sheet and limiting the queue to a \u003cstrong\u003emaximum number of candidates per run\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each remaining topic, Gemini generates \u003cstrong\u003ethree Medium-style title options\u003c\/strong\u003e and returns SEO and Medium-fit scores, plus \u003cstrong\u003eintent\u003c\/strong\u003e and a short rationale.\u003c\/li\u003e\n  \u003cli\u003eAppends only topics that meet the \u003cstrong\u003eminimum SEO score threshold\u003c\/strong\u003e to the \u003cstrong\u003eGoogle Sheets “Keyword Ideas”\u003c\/strong\u003e tab, and records newly discovered competitor post hashes in \u003cstrong\u003e“Seen Competitor Posts”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate \u003cstrong\u003eMedium SEO keyword ideas\u003c\/strong\u003e weekly for a specific niche without manual research.\u003c\/li\u003e\n  \u003cli\u003eValidate topic opportunities against competitor coverage using Medium tag RSS feeds.\u003c\/li\u003e\n  \u003cli\u003eUse the “Set Up a New Niche” form to bootstrap new content niches with Gemini-recommended sources.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Google Gemini, RSS sources (Google Trends RSS, Reddit weekly threads, Medium tag RSS feeds).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow components\/nodes (as provided):\u003c\/strong\u003e if, set, code, no op, sticky note, form trigger.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46010439336115,"sku":"N8N-19522","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/XqzfaLE81AeDS3A8tTjH8_P9VqPDEC.png?v=1789290263","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-find-medium-seo-keywords-with-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}