01The context
Beaj Vad is a crêperie on wheels: the truck parks in a different spot depending on the day. Coralie wanted her customers to order ahead and pay at the truck. She also wanted to run everything herself, from Google Sheets
The challenge
A simple app for customers, and a tool the client runs on her own from a spreadsheet
02The approach
We started from the truck’s daily routine: locations that change, time slots with limited spots, payment at the counter
- 01
Understand
the services, the locations and the truck’s rhythm
- 02
Design
a short journey: the menu, the cart, the time slot
- 03
Build
the page and the Google Apps Script linked to the spreadsheet
- 04
Hand over
a spreadsheet the client updates on her own



03The system
Everything is set in Google Sheets: the menu, prices, locations, time slots and opening hours. The script reads the spreadsheet, checks the time slot and saves each order
- 01
The spreadsheet
the client sets menu, locations and slots
- 02
The page
the customer builds their order
- 03
The script
checks the slot and saves it
- 04
The spreadsheet
the order comes in, ready to prepare
- 05
The truck
pickup and payment on site
04The result
Customers order the day before and pick up at the truck at the time they chose. Time slots with limited spots, options and extras, data retention: it’s all covered. To change the menu or a location, Coralie edits her spreadsheet