Stein Docs

Stein Docs

  • Docs
  • GitHub

›Getting Started

Getting Started

  • Introduction & Core Concepts
  • Create an API
  • Read Data from Sheet
  • Search for Data
  • Add Rows to Sheet
  • Update Rows
  • Delete Rows
  • Authentication
  • Using Client Libraries

Hosting

  • Introduction
  • Manual Installation & Setup

Stein Expedite

  • Introduction
  • Installation
  • Display Data from Sheet
  • Search for Data
  • Connect HTML Forms to Sheet

Creating an API from a Google Sheet

Start by creating an API.

Prepare your sheet

Populate the first row of your sheet with the columns names. Think of these as the field names of your sheet-powered database. There are no restrictions on what you can name them.

The following rows should contain the corresponding data.

Here's an example sheet with a list of blog post summaries.

Prepared Sheet

Copy your sheet's URL

Find your spreadsheet's URL in your browser's address bar.

Sheet URL

Example sheet URL:
https://docs.google.com/spreadsheets/d/13Bc-RY9pOviWvZ7V7CHvuC8QjCqW73guBPk2WxXT0DM/edit?ouid=106603351395721144148&usp=sheets_home&ths=true

Create an API

Start by signing up for Stein.

After you sign up, you'll be prompted for your sheet's URL. The sheet will be used for creating your first API. Paste the URL to get started with Stein.

The interface will then provide you the URL for your spreadsheet's API, in the format https://api.steinhq.com/v1/storages/[your-api-id]. This URL is common for all the sheets in your spreadsheet.

Remember to append your sheet's name to access your API

You need to append the name of the specific sheet you want to access through the Stein API. If you want to access Sheet1 from your spreadsheet, your API URL will now be https://api.steinhq.com/v1/storages/[your-api-id]/Sheet1

You can later create more APIs from your dashboard.

← Introduction & Core ConceptsRead Data from Sheet →
  • Prepare your sheet
  • Copy your sheet's URL
  • Create an API
Stein Logo
DocumentationOpen SourcePricingPartners

Privacy PolicyTerms of Service
© 2021 Stein