Build a weekly content calendar from YouTube and Instagram comments with OpenAI
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on a schedule (every week at 09:00). Along the way it connects OpenAI, Google Sheets and Slack. It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every week at 09:00).
- Config (Edit Fields (Set)): sets 12 fields: creator_name, niche, audience…
- YouTube: Get Recent Uploads (HTTP Request): calls googleapis.com
- Instagram: Get Recent Media (HTTP Request): calls an HTTP API
- Split YouTube Videos (Code): runs custom JavaScript code
- Split Instagram Posts (Code): runs custom JavaScript code
- YouTube: Get Comments (HTTP Request): calls googleapis.com
- Instagram: Get Comments (HTTP Request): calls an HTTP API
- Flatten YouTube Comments (Code): runs custom JavaScript code
- Flatten Instagram Comments (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
…plus 10 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.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.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack
From the author
Quick overview This weekly workflow pulls recent comments from YouTube and Instagram, filters for real questions and requests, uses OpenAI to cluster and rank recurring topics, then writes a question bank and next-week content calendar to Google Sheets and…