Tip Fair › Install

Install Tip Fair in two minutes

You paste two files into your spreadsheet’s Apps Script, and Tip Fair appears under Extensions. Free for up to 5 staff, with no account to create.

You need a computer. Google Sheets only shows Apps Script and add-ons in a computer browser, not in the phone app.

On your phone now? Send yourself this page and open it later on your computer.

  1. Open Apps Script from your spreadsheet

    On a computer, open the Google spreadsheet for your venue (a new blank one is fine: one spreadsheet per venue). Click Extensions › Apps Script. A new tab opens with the editor.

  2. Show the manifest file

    In Apps Script, open Project Settings (the gear on the left) and tick “Show “appsscript.json” manifest file in editor”.

  3. Paste the code

    Go back to the Editor (the < > icon), open Code.gs, delete what is there and paste the Tip Fair code.

    Download Code.gsView

  4. Paste the manifest

    Open appsscript.json, delete what is there and paste this file.

    Download appsscript.jsonView

  5. Name it and save

    Click Untitled project at the top and rename it Tip Fair. Save with Ctrl + S, then go back to the spreadsheet tab and reload it.

  6. Open Tip Fair

    In the spreadsheet, click Extensions › Tip Fair › Open Tip Fair. The panel opens on the right, and asks your country and venue name.

  7. Allow it once

    The first time, Google asks for a one-time permission. These are the screens you will see:

    1Click OK and pick your Google account.
    2Click Advanced, then Go to Tip Fair (unsafe).
    3Tick Select all and click Continue. Done.

    Why “unverified”? Because it is your own copy: you pasted the code into your spreadsheet, and it runs only there, in your Google account. Google shows this warning for any code pasted by hand, and asks only once. Tip Fair can read and edit only the spreadsheet it is installed in.

Next: your staff, tips and hours

Tip Fair adds the Staff, Tips, Hours and Record sheets. Type your staff once, import the tips, paste the hours, and press Split.

Have a Pro key?

Open Tip Fair, go to Settings and paste your key. Unlimited staff, every statement and the letters unlock at once. Get Pro

Stuck on a step? Write to us and we will help you.

Not ready to install? Try the free tip split calculator.