{"product_id":"daily-ai-viral-topic-generator-gemini-reddit-news-to-google-sheets","title":"Daily AI Viral Topic Generator (Gemini + Reddit\/News) to Google Sheets","description":"\u003ch3\u003eTurn daily AI trends into ready-to-post viral topics—automatically\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eDaily AI Viral Topic Generator (Gemini + Reddit\/News) to Google Sheets\u003c\/strong\u003e is an n8n automation that runs every morning at \u003cstrong\u003e8:00 AM\u003c\/strong\u003e, pulls trending AI headlines from \u003cstrong\u003eReddit\u003c\/strong\u003e, \u003cstrong\u003eHacker News\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Trends\u003c\/strong\u003e, then uses the \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e API to generate \u003cstrong\u003efour platform-specific viral topic ideas\u003c\/strong\u003e—and appends them to your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules a daily run\u003c\/strong\u003e using an n8n Schedule Trigger set to \u003cstrong\u003e8:00 AM\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches trending AI items via RSS\u003c\/strong\u003e from:\n    \u003cul\u003e\n      \u003cli\u003eReddit \u003cem\u003er\/artificial\u003c\/em\u003e\n\u003c\/li\u003e\n      \u003cli\u003eReddit \u003cem\u003er\/ArtificialInteligence\u003c\/em\u003e\n\u003c\/li\u003e\n      \u003cli\u003eHacker News AI (items with \u003cstrong\u003e30+ points\u003c\/strong\u003e)\u003c\/li\u003e\n      \u003cli\u003eGoogle Trends (\u003cstrong\u003eIndia\u003c\/strong\u003e)\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges and formats up to 40 headlines\u003c\/strong\u003e into a single prompt.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Google Gemini (generateContent API)\u003c\/strong\u003e to return JSON with \u003cstrong\u003eone tailored topic each\u003c\/strong\u003e for:\n    \u003cstrong\u003eInstagram\u003c\/strong\u003e, \u003cstrong\u003eYouTube\u003c\/strong\u003e, \u003cstrong\u003eFacebook\u003c\/strong\u003e, and \u003cstrong\u003eLinkedIn\u003c\/strong\u003e.\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses Gemini’s JSON\u003c\/strong\u003e, adds \u003cstrong\u003etoday’s date\u003c\/strong\u003e, and writes rows to a Google Sheet (“Topics” tab) including fields such as \u003cstrong\u003etopic\u003c\/strong\u003e, \u003cstrong\u003ehook\u003c\/strong\u003e, \u003cstrong\u003eformat suggestion\u003c\/strong\u003e, \u003cstrong\u003eviral score\u003c\/strong\u003e, and \u003cstrong\u003ereasoning\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf parsing fails, it \u003cstrong\u003esurfaces an error row\u003c\/strong\u003e instead of silently breaking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS marketing teams generating \u003cstrong\u003edaily social content angles\u003c\/strong\u003e from fresh AI signals.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up an \u003cstrong\u003eAI content pipeline\u003c\/strong\u003e feeding a centralized \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e planner.\u003c\/li\u003e\n  \u003cli\u003eFounders monitoring trending AI narratives and quickly turning them into platform-ready posts.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/tech stack:\u003c\/strong\u003e Code, Merge, HTTP Request, RSS Feed Read, Google Sheets, Schedule Trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Reddit RSS, Hacker News AI RSS, Google Trends RSS (India), \u003cstrong\u003eGoogle Gemini API\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup:\u003c\/strong\u003e Configure Google Cloud OAuth for Google Sheets, set your \u003cem\u003eGoogle Sheet ID\u003c\/em\u003e, ensure a “\u003cstrong\u003eTopics\u003c\/strong\u003e” tab with matching headers, and insert your \u003cstrong\u003eGemini API key\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862237831347,"sku":"N8N-18336","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Gm_7ZZLleQKh75D6Md24s_Dhajhao3.png?v=1786957335","url":"https:\/\/buyflowscripts.com\/products\/daily-ai-viral-topic-generator-gemini-reddit-news-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}