Weekly channel performance digest, delivered automatically

Every Monday the scenario pulls fresh video stats, ranks top and weak performers, and sends the report to Google Chat, Google Sheets and AWS SES.

  • Fresh channel numbers without opening analytics by hand
  • Videos rank themselves: top, average, underperformers
  • Digest to Google Chat, log to Google Sheets, email to AWS SES
  • Runs itself every Monday
YouTube
Set it upScriptera

How it works

To pass leads from Google Chat to Google Sheets automatically, use a ready-made scenario — no manual copying, no lost leads.

  1. Starts when: Weekly Monday Trigger
  2. Then: Fetch Recent Channel Videos
  3. Then: Extract Video IDs
  4. Then: Fetch Video Statistics
  5. Then: Parse & Score Videos
  6. Then: Aggregate All Videos
  7. Then: Message a model
  8. Then: Prepare Digest Data
  9. Then: Post Digest to Slack
  10. Then: Split Videos for Logging
  11. Then: Log Videos to Sheet
  12. Then: Re-Aggregate for Email
  13. Then: Email Weekly Report

You can launch this Google Chat + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios