Daily AI Viral Topic Generator (Gemini + Reddit/News) to Google Sheets

Turn daily AI trends into ready-to-post viral topics—automatically

The Daily AI Viral Topic Generator (Gemini + Reddit/News) to Google Sheets is an n8n automation that runs every morning at 8:00 AM, pulls trending AI headlines from Reddit, Hacker News, and Google Trends, then uses the Google Gemini API to generate four platform-specific viral topic ideas—and appends them to your Google Sheets tab.

What this workflow does

• Schedules a daily run using an n8n Schedule Trigger set to 8:00 AM.
• Fetches trending AI items via RSS from:
  • Reddit r/artificial
  • Reddit r/ArtificialInteligence
  • Hacker News AI (items with 30+ points)
  • Google Trends (India)
• Merges and formats up to 40 headlines into a single prompt.
• Calls Google Gemini (generateContent API) to return JSON with one tailored topic each for: Instagram, YouTube, Facebook, and LinkedIn.
• Parses Gemini’s JSON, adds today’s date, and writes rows to a Google Sheet (“Topics” tab) including fields such as topic, hook, format suggestion, viral score, and reasoning.
• If parsing fails, it surfaces an error row instead of silently breaking.

Use cases

• SaaS marketing teams generating daily social content angles from fresh AI signals.
• Automation engineers setting up an AI content pipeline feeding a centralized Google Sheets planner.
• Founders monitoring trending AI narratives and quickly turning them into platform-ready posts.

Technical details

• Nodes/tech stack: Code, Merge, HTTP Request, RSS Feed Read, Google Sheets, Schedule Trigger
• Integrations: Reddit RSS, Hacker News AI RSS, Google Trends RSS (India), Google Gemini API, Google Sheets
• Setup: Configure Google Cloud OAuth for Google Sheets, set your Google Sheet ID, ensure a “Topics” tab with matching headers, and insert your Gemini API key.