Digital Restaurant Menu Powered by Google Sheets

Your menu, live from a spreadsheet

Menus change constantly — seasonal items, price adjustments, dishes that sell out. Keeping a website or tablet kiosk in sync with those changes usually means logging into a CMS or waiting for a developer. With GKit SheetsAPI, your Google Sheet becomes the menu database. Staff edit the Sheet; every screen updates automatically.

Sheet structure

Create a sheet named Menu with these columns:

The available column lets staff take items on and off the menu without deleting rows — just flip the cell to false.

The API call

Fetch only available items in a specific category:

const res = await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Menu" +
  "?search=available:true&search=category:Pizza"
);
const { data } = await res.json();

To load the full menu grouped by category, fetch everything and group client-side:

const res = await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Menu?search=available:true&sort=category"
);
const { data } = await res.json();
 
const byCategory = data.reduce((acc, item) => {
  (acc[item.category] ||= []).push(item);
  return acc;
}, {});

Curl equivalent

curl "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Menu?search=available:true"

Real-world workflow

A staff member arrives and finds the soup of the day is gone. They open the Sheet on their phone, set available to false on that row, and save. The digital menu board refreshes on its next poll and the item disappears — no phone call to a developer, no login to a backend.

When the kitchen brings a seasonal dish back, staff add a new row with available: true. It appears immediately.

Why this works

A spreadsheet is the most approachable data-editing interface your staff will ever use. SheetsAPI removes the only missing piece: turning that spreadsheet into something your website or kiosk can actually read. No database to provision, no CMS license to pay for, no API server to maintain. The Google Sheet is your menu database, and SheetsAPI is the read layer.

Connect your menu Sheet and go live today.