Skip to main content

Overview

Sheet Best turns a Google Sheet (or uploaded spreadsheet) into a REST API. Use the spreadsheet as your backend: edit data in Sheets, read and write it over HTTP.

How it works​

  1. Prepare a sheet with column headers in the first row.
  2. Share the sheet (or use Connect with Drive for private sheets).
  3. Create a connection in the Sheet Best dashboard.
  4. Call the generated https://api.sheetbest.com/sheets/<id> endpoint from any HTTP client.

What you can do​

  • Read, create, update, and delete rows with GET, POST, PUT, PATCH, and DELETE.
  • Address other tabs with /tabs/<TabName>.
  • Filter rows by column with wildcard matching, or run typed comparisons with the /query endpoint and __eq, __ne, __lt, __lte, __gt, __gte operators.
  • Paginate with _limit / _offset, or with row-index shorthand (/2:4).
  • Aggregate columns with /agg/<op> (sum, max, min, mean, median, std, var, prod, any, all).
  • Pivot data with /pivot/<columns>.
  • Switch response shape with _format (records, dict, list, series, split, index).
  • Optionally protect the API with an X-Api-Key header, configured per connection.

Next steps​