All templates

Automated Clover Employee Shift Sales Report

Every morning, WebRun opens Clover, reads yesterday's sales and transaction counts broken down by employee shift, and appends a performance row per employee to your Google Sheet so managers have a clear, daily record of who sold what.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Clover read shift sales and transaction counts per employee
2 Google Sheets log daily employee sales performance
In short

How do I automatically track Clover employee shift sales in Google Sheets?

WebRun opens Clover each morning, reads yesterday's sales and transaction counts for every employee shift, and appends a performance row per person to a Google Sheet. Managers track gross sales, average ticket, and refunds by employee each day without exporting reports manually from Clover.

  • Daily employee sales history built automatically with no manual exports
  • Managers spot top and low performers in seconds each morning
  • Commission and bonus calculations simplified by clean per-employee data

Built for restaurant managers · retail store managers · Clover merchants · HR and payroll teams

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 www.clover.com/dashboard in a real browser with your saved login - no setup, no API keys.

  2. 1
    Clover - read shift sales and transaction counts per employee
    clover.com
    WebRun in Clover: read shift sales and transaction counts per employee
    WebRun opens Clover to read shift sales and transaction counts per employee.
    • Open Clover Dashboard and navigate to Reporting
    • Select the Employee Sales report for yesterday's date
    • Capture each employee's gross sales, transaction count, average ticket, and refund total
    • Note shift start and end times where available

    Done when Sales and transaction data for each employee's shift yesterday is captured.

  3. 2
    Google Sheets - log daily employee sales performance
    google.com
    WebRun in Google Sheets: log daily employee sales performance
    WebRun opens Google Sheets to log daily employee sales performance.
    • Open the employee performance Google Sheet
    • Append one row per employee with date, name, gross sales, transaction count, average ticket, and refunds
    • Auto-calculate each employee's share of total daily sales

    Done when Yesterday's employee shift sales are logged in the Google Sheet.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.clover.com/dashboard
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Employee shift sales log · Google Sheets
OutputWhat each run produces - One row per employee in Google Sheets with gross sales, transaction count, average ticket size, and refund total for their shift.
Spreadsheet rows
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

Will employees see their own data in this sheet?

Only if you share the Google Sheet with them. By default the sheet is private to whoever you grant access, so you control whether employees can view their numbers.

Can I use this data to calculate commission?

Yes. The Google Sheet has each employee's gross sales, so you can add a commission formula column using your own rate to calculate payouts from the logged data.

What happens if an employee had no sales yesterday?

WebRun still logs a row for that employee with zero values, keeping the record complete and making it easy to spot who was scheduled but had no transactions.

Put this on autopilot.

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