A simple inventory tracker with GKit SheetsAPI

Track stock in a Google Sheet your team already uses

Inventory often lives in a spreadsheet, and that is fine. The friction shows up when you want a small internal tool - a stock dashboard, a reorder alert, a barcode lookup - to read and write the same data. GKit SheetsAPI turns any Google Sheet into a REST endpoint so your ops team keeps editing in the Sheet while your app talks to it over HTTP.

Set up the sheet

Make a tab called Inventory and put your field names in the first row, since that row defines the JSON keys:

Your ops team edits quantities directly in Google Sheets. No new admin screen to build or train anyone on.

Read and search stock from your tool

List rows, or search by a field. Search is a case-insensitive substring match, so search=name:cable finds every matching item:

const res = await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Inventory?search=name:cable&sort=-quantity&limit=50",
);
const items = await res.json();

You can sort (prefix - for descending), page with limit and offset, and trim the payload with fields=sku,quantity. That is enough to power a live stock view or a low-stock report.

Update a count when stock moves

When an order ships or a shipment arrives, update that row by its 1-based row number with a PUT:

await fetch(
  "https://sheetsapi.gkit.mreshank.com/api/spreadsheets/{userKey}/Inventory/7",
  {
    method: "PUT",
    headers: { "Content-Type": "application/json" },
    body: JSON.stringify({ quantity: 12 }),
  },
);

Need to add new SKUs in bulk? POST to the same Inventory collection with a single object or an array of them, and each becomes a new row.

Why it fits a small business

• No database to run - your source of truth stays in Google Sheets.
• Ops edits, app reads - non-technical staff manage stock in a tool they know while your code uses the REST API.
• Public to start, locked down later - the API is public until you create an API key, then send Authorization: Bearer sk_... with each request.
• Free while in beta - SheetsAPI is currently in beta and free to use.

Connect your inventory sheet and wire up your tracker today.