Weekly channel performance digest, delivered automatically

Every Monday the scenario pulls fresh video stats, ranks top and weak performers, and sends the report to WhatsApp Business Cloud, Google Sheets and devino.

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

How it works

To pass leads from WhatsApp Business Cloud 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 WhatsApp Business Cloud + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios