Library / Content Writing & Generation
Content Writing & Generation
Analyze Reddit Social Trends into Excel with OpenAI
When you run it, the workflow pulls hot Reddit posts, has an OpenAI agent summarize trends for creators and saves an Excel file to SharePoint.
What it does
### Data Sources Branch What it does • Calls Reddit “hot” endpoint for the chosen subreddit. • Calls a custom Twitter (X) trends endpoint. • You can insert additional HTTP/API nodes (YouTube, TikTok, etc.) before Merge Data. Credentials needed • Reddit OAuth2 • Any keys/tokens for extra APIs you add User tweaks • Change the subreddit in Reddit API (e.g., /r/tech/hot). • Replace or extend the Twitter-trends HTTP node. • Add more sources and connect them to Merge Data.
The steps
- Reddit API
- Merge Data
- Aggregate Content
- Prepare Excel
- Create Excel
- AI Agent
- OpenAI Chat Model
- When clicking ‘Execute workflow’
- Microsoft SharePoint
- Get Twitter Trends
- Set Config
Similar automations
Content Writing & GenerationTurn a Trends Spreadsheet into SEO Newsletters with Approval42 stepsSocial Media PublishingCreate Trend-Based Social Content with OpenAI36 stepsContent Writing & GenerationGenerate MVP Ideas from Reddit Posts with OpenRouter23 stepsContent Writing & GenerationFind Business Opportunities in Reddit Posts with OpenAI24 steps