Track competitor YouTube uploads every week and send them to Slack or Google Sheets

Описание и применение

Автоматический еженедельный сбор новых видео конкурентов с YouTube, извлечение метрик и отправка результатов в Slack или Google Sheets.

Задача

Competitor tracking is often skipped because manually checking many channels is tedious and error‑prone.

Результат

A lightweight, cost‑efficient weekly pipeline that retrieves only new uploads, avoids re‑billing for old videos, and produces actionable metrics for competitor analysis.

Рабочий процесс

• 1. Create Apify task using the provided JSON input with channel URLs and "publishedAfter": "7 days".
• 2. Set "maxResults": 0 to let the date filter limit results.
• 3. Schedule the task to run weekly in Apify.
• 4. (Optional) Use the curl command to trigger the task from a cron job and save the JSON output.
• 5. Run the provided Python compare.py script on the two latest JSON files to compute per‑channel statistics such as uploads, median length, title length, age, and median views.
• 6. Send the summary to Slack or import into Google Sheets for further analysis.

Доказательства

Once a week, fetch only the videos each channel published in the last seven days, store them, and compare with last week.

Источник

Reading uploads costs about 1 quota unit per 50 videos. A search page costs 100, so do not build this on search.

Источник

Best Damn YouTube Scraper does that through its publishedAfter input. Paging stops as soon as older videos appear, and billing is per delivered video, so the back catalogue is never delivered and never billed.

Источник