Premium Chauffeur Service

Reserve Your Journey

Select Vehicle & Service

Choose Your Vehicle & Service

Select vehicle class

Economy

Toyota

Comfortable & reliable

Half Day Rental

6 hours · start times: 6am – 4pm

—

Full Day Rental

12 hours · start times: 6am – 10am

—

Airport Pickup / Drop-off

Per trip

—

Interstate Travel

Premium & Luxury only · Book via WhatsApp →

The Night Shift

Starts 10pm – 2am · 4hr min, 8hr max · per hour

—

Add-ons (optional)

Extension

Per hour past your service window

—

Hours: hr(s)

Trip Details

Start Date *

End Date (multi-day)

Is this a day's booking?

⏰ Ends: —

Pickup Time *

Service Direction *

🛫 Quick fill — tap an airport:

Will you be travelling from an airport? *

Flight Number *

Pickup Location *

Drop-off Location

Special Requests / Notes

Your Details

Full Name *

Phone Number *

Email Address *

Date of Birth *

Booking Type

Company / Organisation

Discount Code (if you have one)

How did you hear about us? *

✓

Thank You for Your Booking

Thank you for your provisional booking with The Alt Garage. We will be in touch to confirm your reservation and arrange next steps.

REF: ALT-000000

Booking Summary

Please save your reference number. Our team will contact you within 2 hours.

WhatsApp Us

Booking Summary

Select a vehicle and service to see your quote.

Note: Prices shown are estimates. Final quote confirmed by our team. Extension & Night Shift calculated per hour selected.

Contact us: WhatsApp: 0913 500 6180 · altgaragerentals@gmail.com

Bookings Dashboard

Real-time overview of all bookings and business insights

📊 Google Sheets Integration

To auto-save every booking to Google Sheets, follow these steps:

1. Go to script.google.com → New Project
2. Paste the Apps Script code below → Deploy as Web App (Anyone can access)
3. Copy your Web App URL and paste it here:

Apps Script code is shown below the table. Copy and paste into Google Apps Script.

Total Bookings

All time

Total Revenue Est.

₦0

Sum of quoted prices

Bookings by Service

Bookings by Vehicle Tier

All Bookings

Ref	Date	Customer	Phone	Vehicle	Core Service	Add-ons	Pickup	Passengers	Est. Total	Source	Payment	Booked At
No bookings yet. Complete a booking to see it here.

📝 Google Form REF Validation Script

To restrict your feedback form to customers with a valid booking REF, go to your Google Form → ⋮ menu → Script editor, and paste this code:

function validateBookingRef(e) {
  var ss = SpreadsheetApp.openById('YOUR_GOOGLE_SHEET_ID');
  var sheet = ss.getSheetByName('Bookings');
  var refs = sheet.getRange(2, 1, sheet.getLastRow()-1, 1).getValues().flat();
  var submittedRef = e.response.getItemResponses()
    .find(r => r.getItem().getTitle().toLowerCase().includes('booking ref'))
    .getResponse().trim().toUpperCase();
  if (!refs.includes(submittedRef)) {
    e.response.getItemResponses().forEach(r => r.getResponse());
    throw new Error('Invalid booking reference. Only verified customers can submit feedback.');
  }
}

function setupTrigger() {
  var form = FormApp.getActiveForm();
  ScriptApp.newTrigger('validateBookingRef')
    .forForm(form)
    .onFormSubmit()
    .create();
}

Replace YOUR_GOOGLE_SHEET_ID with your sheet ID from the URL. Run setupTrigger() once to activate. Make sure your form has a question titled "Booking Reference".

📋 Google Apps Script Code

Create a new Google Sheet, then go to Extensions → Apps Script and paste this code:

function doPost(e) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var data = JSON.parse(e.postData.contents);
  var tripDays = data.tripDays || 1;
  var driverCost = 10000 * tripDays;
  var revenue = data.total || 0;

  // ── SHEET 1: Bookings ──
  var bookingsSheet = ss.getSheetByName('Bookings') || ss.insertSheet('Bookings', 0);
  if (bookingsSheet.getLastRow() === 0) {
    bookingsSheet.appendRow([
      'Ref','Booked At','Customer Name','Phone','Email','Date of Birth','Company',
      'Vehicle','Core Service','Add-ons','Start Date','End Date','Trip Days','Pickup Time',
      'Pickup Location','Drop-off','Flight Number','Notes',
      'Booking Type','Referral Source','Discount Code','Discount %',
      'Original Total (NGN)','Estimated Total (NGN)','Customer Type'
    ]);
    var bookHeader = bookingsSheet.getRange(1, 1, 1, 25);
    bookHeader.setBackground('#0A0A0A').setFontColor('#D4A825').setFontWeight('bold');
    bookingsSheet.setFrozenRows(1);
  }
  // ── CHECK FOR REPEAT CUSTOMER ──
  var allData = bookingsSheet.getDataRange().getValues();
  var isReturning = false;
  for (var r = 2; r <= allData.length; r++) {
    var rowPhone = allData[r-1][3]; // Phone column
    var rowEmail = allData[r-1][4]; // Email column
    if ((rowPhone && rowPhone == data.phone) || (rowEmail && rowEmail == data.email)) {
      isReturning = true;
      break;
    }
  }
  var customerType = isReturning ? 'Returning' : 'New';

  bookingsSheet.appendRow([
    data.ref, data.bookedAt, data.name, data.phone, data.email,
    data.dob, data.company, data.vehicle, data.coreService, data.addons,
    data.date, data.dateEnd, data.tripDays, data.time, data.pickup, data.dropoff,
    data.flightNum, data.notes,
    data.bookingType, data.referral, data.discountCode, data.discountPct,
    data.originalTotal, data.total, customerType
  ]);

  // ── SHEET 2: Profit Tracker ──
  var profitSheet = ss.getSheetByName('Profit Tracker') || ss.insertSheet('Profit Tracker', 1);
  if (profitSheet.getLastRow() === 0) {
    profitSheet.appendRow([
      'Ref','Booked At','Customer Name','Vehicle','Core Service',
      'Start Date','End Date','Trip Days',
      'Estimated Revenue (₦)','Driver Cost (₦)','Fuel Cost (₦)',
      'Total Direct Cost (₦)','Estimated Profit (₦)','Margin (%)','Notes'
    ]);
    var profitHeader = profitSheet.getRange(1, 1, 1, 15);
    profitHeader.setBackground('#0A0A0A').setFontColor('#D4A825').setFontWeight('bold');
    profitSheet.setFrozenRows(1);
  }
  var profitRow = profitSheet.getLastRow() + 1;
  profitSheet.appendRow([
    data.ref, data.bookedAt, data.name, data.vehicle, data.coreService,
    data.date, data.dateEnd, tripDays, revenue, driverCost,
    '', '', '', '', ''
  ]);
  profitSheet.getRange(profitRow, 12).setFormula('=IF(K'+profitRow+'="",J'+profitRow+',J'+profitRow+'+K'+profitRow+')');
  profitSheet.getRange(profitRow, 13).setFormula('=IF(L'+profitRow+'="","",I'+profitRow+'-L'+profitRow+')');
  profitSheet.getRange(profitRow, 14).setFormula('=IF(AND(M'+profitRow+'<>"",I'+profitRow+'>0),TEXT(M'+profitRow+'/I'+profitRow+',"0.0%"),"")');
  var profitVal = revenue - driverCost;
  profitSheet.getRange(profitRow, 13).setFontColor(profitVal > 0 ? '#34A853' : '#EA4335');

  // ── SHEET 3: Cost Analysis ──
  var costSheet = ss.getSheetByName('Cost Analysis') || ss.insertSheet('Cost Analysis', 2);
  if (costSheet.getLastRow() === 0) {
    // Row 1: Fuel price config cell
    costSheet.getRange('A1').setValue('⛽ FUEL PRICE PER LITRE (₦) — Update this cell when price changes:');
    costSheet.getRange('A1').setFontWeight('bold').setFontColor('#D4A825').setBackground('#0A0A0A');
    costSheet.getRange('B1').setValue(1330);
    costSheet.getRange('B1').setBackground('#FFFF00').setFontColor('#0000FF').setFontWeight('bold')
      .setNumberFormat('₦#,##0');
    costSheet.getRange('C1').setValue('← Change this number when fuel price changes. All rows update automatically.');
    costSheet.getRange('C1').setFontStyle('italic').setFontColor('#888888');

    // Row 2: blank spacer
    costSheet.getRange('A2').setValue('');

    // Row 3: Headers
    costSheet.appendRow([
      'Booking REF','Date','Vehicle','Service','Trip Days',
      'Predicted Fuel Cost (₦)','Driver Cost (₦)','Predicted Total Cost (₦)',
      'Actual Fuel Cost (₦)','Actual Driver Cost (₦)','Actual Total Cost (₦)',
      'Fuel Variance (₦)','Total Variance (₦)','Notes'
    ]);
    var costHeader = costSheet.getRange(3, 1, 1, 14);
    costHeader.setBackground('#0A0A0A').setFontColor('#D4A825').setFontWeight('bold');
    costSheet.setFrozenRows(3);

    // Column widths
    costSheet.setColumnWidth(1, 200);
    costSheet.setColumnWidth(2, 110);
    costSheet.setColumnWidth(3, 160);
    costSheet.setColumnWidth(4, 160);
    costSheet.setColumnWidth(5, 80);
    for (var c = 6; c <= 13; c++) costSheet.setColumnWidth(c, 170);
    costSheet.setColumnWidth(14, 160);
  }

  // Tank sizes (litres) × 50% × fuel price per day
  var tankLexus = 87;
  var tankMerc = 93;
  var usageFraction = 0.5;

  var costRow = costSheet.getLastRow() + 1;
  var isLexus = data.vehicle.toLowerCase().indexOf('lexus') > -1;
  var tankSize = isLexus ? tankLexus : tankMerc;

  // Predicted fuel uses live fuel price from B1
  var predictedFuelFormula = '=$B$1*' + tankSize + '*' + usageFraction + '*E' + costRow;
  var driverFormula = '=10000*E' + costRow;
  var predictedTotalFormula = '=F' + costRow + '+G' + costRow;
  var actualTotalFormula = '=IF(AND(I' + costRow + '<>"",J' + costRow + '<>""),I' + costRow + '+J' + costRow + ',"")';
  var fuelVarianceFormula = '=IF(I' + costRow + '<>"",I' + costRow + '-F' + costRow + ',"")';
  var totalVarianceFormula = '=IF(K' + costRow + '<>"",K' + costRow + '-H' + costRow + ',"")';

  costSheet.appendRow([
    data.ref, data.date, data.vehicle, data.coreService, tripDays,
    '', '', '',   // formulas added below
    '', '',       // Actual Fuel & Driver — manual entry (yellow)
    '', '', '', '' // formulas added below
  ]);

  // Set formulas
  costSheet.getRange(costRow, 6).setFormula(predictedFuelFormula).setNumberFormat('₦#,##0');
  costSheet.getRange(costRow, 7).setFormula(driverFormula).setNumberFormat('₦#,##0');
  costSheet.getRange(costRow, 8).setFormula(predictedTotalFormula).setNumberFormat('₦#,##0');
  costSheet.getRange(costRow, 9).setNumberFormat('₦#,##0');  // Actual Fuel — manual
  costSheet.getRange(costRow, 10).setNumberFormat('₦#,##0'); // Actual Driver — manual
  costSheet.getRange(costRow, 11).setFormula(actualTotalFormula).setNumberFormat('₦#,##0');
  costSheet.getRange(costRow, 12).setFormula(fuelVarianceFormula).setNumberFormat('₦#,##0');
  costSheet.getRange(costRow, 13).setFormula(totalVarianceFormula).setNumberFormat('₦#,##0');

  // Yellow input cells for actual costs
  costSheet.getRange(costRow, 9).setBackground('#FFFF00').setFontColor('#0000FF');
  costSheet.getRange(costRow, 10).setBackground('#FFFF00').setFontColor('#0000FF');

  // ── EMAIL NOTIFICATION ──
  var emailBody = '🖤 New Booking on The Alt Garage!\n\n' +
    'REF: ' + data.ref + '\n' +
    'Booked At: ' + data.bookedAt + '\n\n' +
    '── CUSTOMER ──\n' +
    'Name: ' + data.name + '\n' +
    'Phone: ' + data.phone + '\n' +
    'Email: ' + data.email + '\n\n' +
    '── BOOKING ──\n' +
    'Vehicle: ' + data.vehicle + '\n' +
    'Service: ' + data.coreService + '\n' +
    'Start Date: ' + data.date + '\n' +
    'End Date: ' + data.dateEnd + '\n' +
    'Total Days: ' + tripDays + '\n' +
    'Start Time: ' + data.time + '\n' +
    'Pickup: ' + data.pickup + '\n' +
    'Add-ons: ' + (data.addons || 'None') + '\n\n' +
    '── FINANCIALS ──\n' +
    'Estimated Total: ₦' + Number(revenue).toLocaleString() + '\n' +
    'Driver Cost: ₦' + Number(driverCost).toLocaleString() + '\n' +
    '50% Deposit Due: ₦' + Number(revenue / 2).toLocaleString() + '\n\n' +
    'View full details in your Google Sheet.';

  MailApp.sendEmail({
    to: 'altgaragerentals@gmail.com',
    subject: '🖤 New Booking — ' + data.ref + ' — ' + data.name,
    body: emailBody
  });

  return ContentService
    .createTextOutput(JSON.stringify({status:'success'}))
    .setMimeType(ContentService.MimeType.JSON);
}

function doGet(e) {
  return ContentService
    .createTextOutput(JSON.stringify({status:'ok'}))
    .setMimeType(ContentService.MimeType.JSON);
}

Reserve Your Journey

Choose Your Vehicle & Service

Half Day Rental

Full Day Rental

Airport Pickup / Drop-off

Interstate Travel

The Night Shift

Extension

Trip Details

Your Details

Thank You for Your Booking

Booking Summary

Bookings Dashboard

📊 Google Sheets Integration

Bookings by Service

Bookings by Vehicle Tier

All Bookings Export CSV

📝 Google Form REF Validation Script

📋 Google Apps Script Code

All Bookings