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

> 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 posts a summary digest to Slack. How it works 1. Runs weekly on a schedule trigger. 2. Fetches recent uploads from the configured YouTube channel and pulls top-level comment threads for each recent video via the YouTube Data API. 3. Fetches recent Instagram media for the configured account and pulls comments for recent posts via the Instagram Graph API. 4. Merges YouTube and Instagram comments, removes spam/duplicates, and keeps the most relevant questions and requests ranked by engagement. 5. Sends the curated comment set to OpenAI to cluster repeated questions into themes and then scores clusters using mention counts, likes, and cross-platform demand. 6. Appends the ranked clusters as rows to a Google Sheets “Question Bank” tab. 7.

- **Domain**: `n8n-workflow-20033.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20033
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20033.n8n.io
- Documentation: https://n8n.io/workflows/20033