Templates / Build a weekly content calendar from YouTube and Instagram comments with OpenAI

Build a weekly content calendar from YouTube and Instagram comments with OpenAI

Ready for 3.0

by Rahul Joshi ✓ · 45 views · created 2026-09-28 · Market Research, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Config (Edit Fields (Set)): sets 12 fields: creator_name, niche, audience…
  2. YouTube: Get Recent Uploads (HTTP Request): calls googleapis.com
  3. Instagram: Get Recent Media (HTTP Request): calls an HTTP API
  4. Split YouTube Videos (Code): runs custom JavaScript code
  5. Split Instagram Posts (Code): runs custom JavaScript code
  6. YouTube: Get Comments (HTTP Request): calls googleapis.com
  7. Instagram: Get Comments (HTTP Request): calls an HTTP API
  8. Flatten YouTube Comments (Code): runs custom JavaScript code
  9. Flatten Instagram Comments (Code): runs custom JavaScript code
  10. Merge: merges the data from its input branches

…plus 10 more steps. See the full node list below.

Services it uses

OpenAIGoogle SheetsSlack

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)

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…

Excerpt from Rahul Joshi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.