Skip to content
FREN
← All work

Ordering appNo. 01

Beaj Vad

A pre-order app for a mobile crêperie, run from Google Sheets, with no online payment

UX · UI · Google Apps Script development · Google Sheets

beajvad-commande.netlify.app

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

  1. 01

    Understand

    the services, the locations and the truck’s rhythm

  2. 02

    Design

    a short journey: the menu, the cart, the time slot

  3. 03

    Build

    the page and the Google Apps Script linked to the spreadsheet

  4. 04

    Hand over

    a spreadsheet the client updates on her own

Mockups of the Beaj Vad app
The Beaj Vad app on mobile
The Beaj Vad app on mobile, next steps of the journey

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

  1. 01

    The spreadsheet

    the client sets menu, locations and slots

  2. 02

    The page

    the customer builds their order

  3. 03

    The script

    checks the slot and saves it

  4. 04

    The spreadsheet

    the order comes in, ready to prepare

  5. 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

Let’s book 30 min

We’ll go over your project, no strings attached.

shall we talk?