Casino PIN Code
Share this PIN with your dealers to register
Setup Status
System configuration complete.
My Earnings (This Month)
Recent Shifts
| Date | Hours | Rate | Total | Status |
|---|
Shift Calculator (Penny Perfect)
Quick-Add Templates
💰 Individual Dealer Earnings
🏦 Casino Cage Breakdown (Total Bills Needed)
🎯 Welcome to TokeTracker Pro Setup
Let's create your structured Google Sheets integration in 6 simple steps.
What you'll get:
- ✅ Fixed dealer positions in spreadsheet
- ✅ One-click shift population templates
- ✅ Alphabetical organization
- ✅ Long-term data tracking
⏰ Define Your Shift Hours
Set the time ranges for each shift. This helps auto-assign dealers based on their scheduled hours.
💡 Tip: Use 24-hour format. Shifts can span midnight (e.g., 18:00 to 02:00).
📝 Add Your Dealers
Add all your current dealers. We'll assign them fixed row numbers.
- No dealers added yet
⏰ Assign Shifts
Which shifts do your dealers typically work?
Day (6am-2pm)
Swing (2pm-10pm)
Grave (10pm-6am)
📅 Weekly Schedule
Set default shifts. This creates your one-click templates.
| Dealer | Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|
🚀 Review & Generate
Setup Complete!
Your TokeTracker Pro system is ready to use.
Next Steps:
- Copy the Google Apps Script code (in Settings)
- Create your Google Sheet
- Paste the script and deploy as Web App
- Add the Web App URL in Settings
Earnings Ledger
| Date | Shift ID | Dealer | Hours | Rate | Earnings | Status |
|---|
Employee Directory
| Row # | Name | Shifts | Status | Actions |
|---|
🤖 AI Report Generator
Let AI automatically generate and export your earnings reports
📧 Email Delivery Settings
If Google Sheets is configured, email delivery is optional. Otherwise, email is the primary delivery method.
Google Sheets Integration
Google Apps Script Code
Copy this code to your Google Sheet Script Editor
📋 Google Sheets Integration Setup
Follow these steps to connect TokeTracker Pro to your Google Sheet.
Part 1: Create Your Google Sheet
- Open your web browser and go to sheets.google.com
- Log in to your Google account if needed
- Click the "+" icon to create a Blank spreadsheet
- Click on "Untitled spreadsheet" at the top and name it (e.g., "TokeTracker Data" )
- Keep this browser tab open
Part 2: Get the Script Code
- Scroll up to the "Google Apps Script Code" section above
- Click the "Copy Code" button
- You should see "Script code copied to clipboard!" message
Part 3: Set Up the Google Apps Script
- Go back to your Google Sheet tab
- Click Extensions → Apps Script in the menu
- A new tab will open with a file called
Code.gs - Select all the default code (Ctrl+A or Cmd+A) and delete it
- Paste the code you copied (Ctrl+V or Cmd+V)
- Click the save icon (💾) at the top
- Name your project (e.g., "TokeTracker Integration") and click Rename
Part 4: Deploy as Web App (Most Important!)
- Click the blue "Deploy" button at the top right
- Select "New deployment"
- Click the gear icon (⚙️) next to "Select type"
- Choose "Web app"
- Configure settings:
- Description: "TokeTracker Integration"
- Execute as: "Me"
- Who has access: "Anyone"
- Click "Deploy"
- Click "Authorize access"
- Choose your Google account
- You'll see "Google hasn't verified this app" - this is normal
- Click "Advanced"
- Click "Go to TokeTracker Integration (unsafe)"
- Scroll down and click "Allow"
- Copy the Web App URL that appears (it looks like: https://script.google.com/macros/s/.../exec )
Part 5: Connect TokeTracker Pro
- Scroll up to the "Google Apps Script URL" field above
- Paste the Web App URL you just copied
- Click "Save URL"
- You should see "Settings saved successfully!" ✅
Part 6: Test It!
- Go to the Calculator page
- Submit a test shift
- Go back to your Google Sheet
- You should see a new tab called
Casino_[YourPIN] - Click on it to see your shift data!
💡 Tip: If you encounter any issues, check the Apps Script editor's Executions tab for error messages.