All templates
For tour operators, activity booking managers & multi-day tour companies

Chase outstanding balances before the tour date

Every morning, WebRun opens Checkfront and finds bookings where a balance is due within the next seven days, drafts a polite payment reminder for each guest with the amount due and a secure payment link, logs all open balances to a Google Sheet, and queues the drafts in Gmail for your review.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every morning at 8:30 AM WebRun
1 Checkfront find bookings with outstanding balances
2 Google Sheets log open balances
3 Gmail draft balance-due reminders
Run a sample
In short

How do I automatically remind tour guests about their outstanding balance?

Every morning, WebRun checks Checkfront for bookings with a balance due in the next seven days, drafts a polite payment reminder for each guest with the amount, due date, and a secure payment link, and logs all open balances to Google Sheets. Every draft is held in Gmail for operator approval before reaching any guest.

  • Outstanding balances are chased every morning without manual effort
  • Guests receive a polite reminder days before their tour, not a surprise at check-in
  • All open balances tracked in one sheet so nothing slips through

Built for tour operators · activity booking managers · multi-day tour companies · adventure tourism businesses

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

  2. 1
    Checkfront - find bookings with outstanding balances
    checkfront.com
    WebRun in Checkfront: find bookings with outstanding balances
    WebRun opens Checkfront to find bookings with outstanding balances.
    • Open Checkfront and filter bookings to those with an outstanding balance due in the next seven days
    • For each booking, capture guest name, email, tour date, tour name, balance amount, and due date
    • Skip any guests already reminded in the last three days to avoid over-messaging

    Done when All bookings with an imminent outstanding balance are listed with guest and payment details.

  3. 2
    Google Sheets - log open balances
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log open balances
    WebRun opens Google Sheets to log open balances.
    • Open the balance-due tracking sheet
    • Log each open balance with guest name, tour, balance amount, due date, and reminder status set to Pending
    • Highlight any balances overdue past their due date in a separate section

    Done when All open and overdue balances are logged with Pending reminder status.

  4. 3
    Gmail - draft balance-due reminders
    gmail.com How to Automate Gmail
    WebRun in Gmail: draft balance-due reminders
    WebRun opens Gmail to draft balance-due reminders.
    • Draft a polite, on-brand payment reminder for each guest stating the amount due and the due date
    • Include a secure payment link from Checkfront and the tour date as a friendly context
    • For overdue balances, add a note that the booking may not be guaranteed without payment
    • Leave all drafts unsent in Gmail for operator review before sending

    Done when One payment-reminder draft per guest is ready in Gmail for operator approval.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.checkfront.com
ScheduleRuns automatically on this cadence
Every morning at 8:30 AM
DeliveryHow each run's result reaches you
Balance-due drafts · Gmail
OutputWhat each run produces - One balance-due reminder draft per guest, plus a running open-balance log in Google Sheets showing all amounts and due dates.
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

Will it email guests about their balance without my approval?

No. Every reminder is drafted and held in Gmail for your review. You send the batch once you have checked the amounts, so no guest receives a payment request you have not approved.

What if a guest already paid after the reminder was drafted?

Because the drafts are held for your review, you can check Checkfront for any payments made since the draft was created and delete the draft for guests who have already settled their balance.

Can it send a second reminder if the first is ignored?

Yes. Run the workflow again the following day and it will detect the balance is still open and draft a follow-up, while the Google Sheets log prevents duplicate reminders within the same three-day window.

Put this on autopilot.

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