Track top social media trends with Reddit, Twitter, and GPT-4o to SP/Drive
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and Microsoft SharePoint. It also calls oauth.reddit.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Config (Edit Fields (Set)): sets 2 fields: dateToday, topic
- Reddit API (HTTP Request): calls oauth.reddit.com
- Get Twitter Trends (HTTP Request): calls an HTTP API (POST)
- Merge: merges the data from its input branches
- Aggregate Content (Code): runs custom JavaScript code
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Prepare Excel (Code): runs custom JavaScript code
- Create Excel (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Microsoft SharePoint: upload
Services it uses
HTTP calls to: oauth.reddit.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Spreadsheet File (Create Excel): Convert to File / Extract from File.
Nodes used (9)
- HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Spreadsheet File
n8n-nodes-base.spreadsheetFile - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Manual Trigger
n8n-nodes-base.manualTrigger - Microsoft SharePoint
n8n-nodes-base.microsoftSharePoint - Edit Fields (Set)
n8n-nodes-base.set
From the author
Who’s it for Content creators, marketers, journalists, and product teams who need a quick, automated snapshot of what the internet is talking about—served as a ready-to-use spreadsheet every morning. How it works / What it does 1. Manual Trigger / Cron starts…