All templates

Automated Yoco Peak Hour Sales Heatmap

Every night, WebRun opens Yoco, breaks today's takings down by hour, adds the row to a running heatmap in Google Sheets covering every hour of every day, and once a week posts a Telegram digest of which hours and days are actually your busiest, so staffing follows real demand.

Runs on WebRun · Strict Lockdown policy
Every night at 10:00 PM WebRunorchestrates each step
1 Yoco break down today's takings by hour
2 Google Sheets add today's row to the heatmap
3 Telegram post the weekly busiest hours digest
In short

How do I find my actual busiest hours from Yoco sales data?

WebRun builds a running heatmap of your busiest hours from Yoco takings. Every night it adds the day's hourly totals to a Google Sheets grid covering every hour and day of the week, and once a week it posts a Telegram digest of which times are genuinely busiest, so staffing and stock decisions follow real demand instead of a guess.

  • Busiest hours are based on your own data, not a guess
  • The pattern gets more reliable every week it runs
  • A shifting busy hour shows up before it changes your staffing

Built for cafes and restaurants · retail stores · salons · multi shift operations

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.yoco.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Yoco - break down today's takings by hour
    yoco.com
    WebRun in Yoco: break down today's takings by hour
    WebRun opens Yoco to break down today's takings by hour.
    • Open Yoco and pull today's card takings broken down by hour
    • Note the transaction count for each hour, not just the value
    • Carry the day of the week so hours can be compared across weeks

    Done when Today's takings are broken down hour by hour.

  3. 2
    Google Sheets - add today's row to the heatmap
    google.com
    WebRun in Google Sheets: add today's row to the heatmap
    WebRun opens Google Sheets to add today's row to the heatmap.
    • Add today's hourly figures to the running heatmap grid
    • Recalculate the average for each hour and day of week combination
    • Color the busiest hours so the pattern is visible at a glance

    Done when The heatmap includes today's hours and its averages are current.

  4. 3
    Telegram - post the weekly busiest hours digest
    telegram.org
    WebRun in Telegram: post the weekly busiest hours digest
    WebRun opens Telegram to post the weekly busiest hours digest.
    • Once a week, post a digest of the busiest hours and days from the current heatmap
    • Call out any hour that has shifted busier or quieter recently
    • Keep the digest short enough to read on a phone

    Done when The team has a weekly Telegram digest of the actual busiest hours.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.yoco.com
ScheduleRuns automatically on this cadence
Every night at 10:00 PM
DeliveryHow each run's result reaches you
Weekly busiest hours digest · Telegram
OutputWhat each run produces - A running hour by hour heatmap of Yoco takings in Google Sheets, plus a weekly Telegram digest of your busiest hours and days.
Spreadsheet + digest
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

How long until the heatmap is useful?

It updates every night, so you will see a rough pattern within a couple of weeks and a reliable one after a full month of trading, since more nights make the averages more accurate.

Does it recommend staffing levels?

No, it shows which hours and days are genuinely busiest based on your own Yoco data. Deciding how many staff to schedule against that pattern is still your call.

Can it show a single day's pattern instead of the whole week?

Yes. The underlying heatmap in Google Sheets breaks every day down by hour, the Telegram digest just summarizes the week, so you can open the sheet for a single day's detail.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.