n8n Workflow: Weekly YouTube & Instagram Comment Calendar w/ OpenAI

Turn YouTube + Instagram comments into an actionable weekly content plan—automatically

This n8n workflow automatically pulls recent YouTube and Instagram comments every week, filters for real questions and requests, uses OpenAI to cluster recurring topics, then publishes a ranked “Question Bank” and next-week “Content Calendar” to Google Sheets—with a weekly digest posted to Slack.

What this workflow does

• Runs on a weekly schedule using a schedule trigger.
• Collects audience demand by fetching recent uploads from your configured YouTube channel and retrieving top-level comment threads for each video via the YouTube Data API.
• Surfaces engagement on Instagram by pulling recent media for your configured Instagram account and retrieving comments for those posts via the Instagram Graph API.
• Unifies and de-duplicates YouTube + Instagram comments, removing spam/duplicates and keeping the most relevant questions and requests ranked by engagement signals.
• Uses OpenAI for topic clustering to group repeated questions into themes, then scores clusters using mention counts, likes, and cross-platform demand.
• Updates Google Sheets: appends ranked clusters to the “Question Bank” tab, then uses OpenAI to generate a next-week content calendar from the top clusters and appends it to the “Content Calendar” tab.
• Posts a weekly digest to Slack so your team can review what the audience is asking and what you’ll publish next.

Use cases

• Creators and marketers who want content planning from real comments instead of guesswork
• SaaS operators building feedback loops across YouTube and Instagram
• Automation engineers who need an OpenAI-powered n8n workflow that writes structured outputs to Sheets and notifies Slack

Technical details

• n8n nodes/integration flow: Set, Code, Merge, HTTP Request, Slack, Sticky Note
• Credentials: YouTube Data API v3 key via “HTTP Query Auth”, Instagram Graph API long-lived access token, and OpenAI credentials for clustering + calendar generation
• Google Sheets: OAuth2 integration; append rows to “Question Bank” and “Content Calendar”