All templates
For hospitality finance teams, bar owners & brewery controllers

Track your GoTab gift-card and open-tab liability every week

Every Monday, WebRun opens GoTab, pulls the total value of unredeemed gift cards and open tabs across all locations, logs the figures into a Google Sheet with a running weekly history, and posts a summary to the finance Slack channel.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 8:30 AM WebRun
1 GoTab pull gift-card balances and open-tab totals
2 Google Sheets log liability figures with weekly history
Run a sample
In short

How do I automatically track my GoTab gift-card and open-tab liability each week?

WebRun opens GoTab every Monday, pulls the total outstanding gift-card balances and open-tab values across all locations, and logs them into a Google Sheet with a running week-on-week trend. Your finance team always has a current view of liability exposure without any manual report-pulling.

  • Weekly gift-card and open-tab liability visible without manual GoTab reporting
  • Week-on-week trend tracked automatically in Google Sheets
  • Large individual balances flagged for finance team review

Built for hospitality finance teams · bar owners · brewery controllers · food hall operations managers

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

  2. 1
    GoTab - pull gift-card balances and open-tab totals
    gotab.com How to Automate GoTab
    WebRun in GoTab: pull gift-card balances and open-tab totals
    WebRun opens GoTab to pull gift-card balances and open-tab totals.
    • Open GoTab Operator Portal and navigate to the Gift Card report
    • Pull the total outstanding gift-card balance across all active cards
    • Navigate to open tabs and capture the total value of unclosed tabs by location
    • Note any unusually large individual balances for the finance team

    Done when Total gift-card liability and open-tab balance are captured for all locations.

  3. 2
    Google Sheets - log liability figures with weekly history
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log liability figures with weekly history
    WebRun opens Google Sheets to log liability figures with weekly history.
    • Append this week's gift-card balance and open-tab total to the liability tracking sheet
    • Update the running week-on-week trend chart in the sheet
    • Flag weeks where total liability has grown more than 10 percent over the prior week

    Done when This week's liability figures are logged and the trend row is updated in Google Sheets.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
gotab.com
ScheduleRuns automatically on this cadence
Every Monday at 8:30 AM
DeliveryHow each run's result reaches you
Liability log · Google Sheets
OutputWhat each run produces - A weekly log of GoTab gift-card and open-tab liability totals with a week-on-week trend in Google Sheets.
Spreadsheet
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 track gift cards and open tabs separately?

Yes. Gift-card liability and open-tab totals are captured and logged as separate line items each week so finance can see each exposure clearly.

Can it cover multiple GoTab locations?

Yes. WebRun pulls the liability figures per location and logs both a per-venue breakdown and the consolidated total in the same sheet.

What counts as an unusually large balance worth flagging?

You configure the threshold. Any individual gift-card or open-tab balance above your set amount is highlighted in the sheet for a closer look.

Put this on autopilot.

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