All templates

Automated ClearTEQ Best Seller Report

Every Monday, WebRun opens ClearTEQ POS, ranks last week's blends by units sold and revenue across every location, emails you the full ranked report in Gmail, and posts the top 5 to Slack so the whole team sees what's working.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 ClearTEQ POS rank last week's blends
2 Gmail email the full report
3 Slack post the top-line summary
In short

How do I get a weekly report of my best-selling tea blends?

WebRun ranks every blend you sold last week by units and revenue straight from ClearTEQ POS, across all your locations. It emails you the full ranked report in Gmail every Monday morning and posts the top 5 blends to Slack so the whole team can see what is working, without anyone building a spreadsheet by hand.

  • You know your top 5 blends before Monday's first customer
  • Week over week movers get flagged automatically
  • No one builds a ranking spreadsheet by hand

Built for tea house owners · multi-location tea retailers · tea shop managers · specialty tea buyers

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

  2. 1
    ClearTEQ POS - rank last week's blends
    clearteq.com
    WebRun in ClearTEQ POS: rank last week's blends
    WebRun opens ClearTEQ POS to rank last week's blends.
    • Open ClearTEQ POS and pull last week's sales by blend
    • Rank every blend by units sold and by revenue
    • Note any blend that jumped or dropped sharply versus the prior week

    Done when Every blend sold last week is ranked by units and revenue.

  3. 2
    Gmail - email the full report
    gmail.com
    WebRun in Gmail: email the full report
    WebRun opens Gmail to email the full report.
    • Email the full ranked report to you with both units and revenue columns
    • Include the week over week movers
    • Keep last week's report attached for comparison

    Done when The full report is sitting in your inbox.

  4. 3
    Slack - post the top-line summary
    slack.com
    WebRun in Slack: post the top-line summary
    WebRun opens Slack to post the top-line summary.
    • Post the top 5 blends by revenue to the team channel
    • Call out the biggest mover of the week
    • Link to the full report in Gmail for detail

    Done when The team has the top-line summary in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
clearteq.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Best seller report · Slack
OutputWhat each run produces - A full ranked best-seller report by units and revenue, plus a top-5 summary posted for the team.
Text
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

Does it include every location or just one counter?

It ranks blends across every location you run in ClearTEQ POS, and can also break the ranking out location by location if you ask.

Can it compare against the prior week?

Yes. Every report calls out which blends moved up or down sharply compared to the week before.

Who gets the full report versus the Slack summary?

The full ranked report with every blend goes to your Gmail inbox. Slack only gets the top 5 so the team can scan it fast.

Keep going

Related templates

Automated ClearTEQ Tea Sales Digest
Every night, WebRun tallies the day's sales in ClearTEQ POS by blend and category, logs the totals to Google Sheets, and posts the recap to Slack so you always know how the day went.
ClearTEQ POS›Google Sheets›Slack
Automated Seasonal Tea Markdown Alerts
Every Monday, WebRun checks Google Calendar for each seasonal blend's season-end date, checks remaining stock in ClearTEQ POS, and emails you a markdown recommendation while there's still time to sell through.
Google Calendar›ClearTEQ POS›Gmail
Automated ClearTEQ Tin Reorder Alerts
Every morning, WebRun checks tin-level stock for every loose-leaf blend in ClearTEQ POS, logs what's running low to Google Sheets, and drafts a reorder email to your supplier in Gmail for you to review and send.
ClearTEQ POS›Google Sheets›Gmail

Put this on autopilot.

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

Deploy this workflow Talk to us