Track Top Social Media Trends: Reddit, Twitter & GPT-4o to Drive

This workflow provides content creators, marketers, journalists, and product teams with an automated daily snapshot of top social media trends. It starts with a manual trigger or cron schedule, sets the current date and a customizable topic (default: 'Artificial Intelligence'), then pulls hot posts from Reddit's subreddit (e.g., /r/artificial) and trends from Twitter via API. Data is merged, aggregated, and fed into a GPT-4o AI agent that extracts and ranks the top 5 trends in structured JSON format.

The trends are then formatted into rows, converted to a professional .xlsx spreadsheet named 'social-media-trends.xlsx', and uploaded to your SharePoint folder (easily swappable for Google Drive, Dropbox, etc.). This eliminates manual monitoring, saving hours of research time and delivering actionable insights ready for sharing or analysis.

Ideal for staying ahead in fast-paced fields like marketing and journalism, it supports expansion with more sources like Instagram or YouTube. Setup requires n8n 1.33+, Reddit OAuth2, OpenAI credentials, and a storage provider. Activate for morning reports that keep your team informed on what's buzzing online.