AutomationDownload
Gift Voucher Tracker
Every gift voucher you have sold: its balance, a reminder to the holder before it expires, and the total you still owe in unused vouchers
£15.00£18.00reduced from £18.00
Download
No-Show & Deposit Tracker
Keeps a record of no-shows and late cancellations by client, flags repeat offenders for a deposit, and reminds deposit clients of your policy
£29.00
How you’ll receive this product
Available to download as soon as your payment is confirmed
This is delivered digitally. As soon as your payment is confirmed you will get a private link to your files on your order page. Keep the link to that page — it is where your purchase lives.
You receive
- No-Show & Deposit Tracker — no-show-deposit-tracker.zip
- Secure Stripe checkout — we never see your card details
- Your files appear on your order page the moment payment clears
About this product
No-shows cost you the whole slot. This shows you exactly who is doing it, so you can ask for a deposit - and gently reminds those clients of your policy before they are due.
Log each appointment and, afterwards, its outcome: Attended, No-show, Late cancel or Cancelled. Every day it rebuilds a No-show record tab with each client's history - matched by email, so name spellings do not matter - and marks anyone with 2 no-shows or late cancellations in the last 12 months as DEPOSIT. You get one email when someone is newly flagged.
Two days before an appointment, clients who paid a deposit or are flagged get a friendly reminder of your cancellation policy, in your own words.
Features
- A No-show record tab with every client's history
- Flags clients with 2 no-shows or late cancellations in 12 months
- Counts deposits kept
- A friendly policy reminder 2 days before, for deposit and flagged clients
- One email to you when someone is flagged
- Starts in test mode - everything comes to you until you say otherwise
- Keeps a record of every message it sends, so nothing goes twice
- The wording lives on a tab in the sheet, so you change it without touching code
- An Example tab in your own sheet shows a filled-in version, with made-up data
- Runs inside your own Google account. Nothing is sent to us or to anyone else
Product questions
A Google account - a free Gmail account works, and so does Google Workspace - and Google Sheets in your web browser. Nothing is installed on your computer.
Open a new Google Sheet, go to Extensions > Apps Script, paste in the script from your download and run install once. It builds the tabs, the settings and the daily schedule for you. The setup guide shows every click.
No. Test mode is on when you install it: every message comes to you first, marked [TEST], with a line saying who it would have gone to. You switch test mode off in the Settings tab when you are happy with it.
Google asks you to approve any script that reads your sheet or sends email from your account. Because the script runs in your own account rather than as a published app, Google shows its standard warning screen. The setup guide explains each button.
No. Everything stays inside your own Google account. The script cannot contact any other website, and we never see your sheet or your emails.
It stops at 50 a day unless you change that in Settings. Google's own limit is about 100 recipients a day on a free Gmail account and 1,500 on Google Workspace.
No. You pay once. It runs on Google's free Apps Script service in your own account, so there is nothing to renew.
Reviews
No reviews yet. If you have bought this product, yours could be the first.
You might also like
- Download
Lapsed Client Win-Back
Sends a friendly we-have-missed-you email to clients who have not been in for a while - only those who agreed to hear from you
£29.00 - AutomationDownload
Rebooking Reminders
Emails each client when they are due back - a cut at six weeks, colour at eight, nails at three - unless they have already booked
£29.00
