Published
Edited
Feb 25, 2020
Insert cell
md`# Create an API

Now we know what APIs are let's create one that we can share.`
Insert cell
md`## Step 1: Create a New Google Sheet

[Create New Sheet](https://sheets.new)`
Insert cell
md`## Step 2: Create a Sheety Account

[Sheety](https://sheety.co)

Then give it the *URL* of your Google Sheet.`
Insert cell
md`## Step 3: Call Your API`
Insert cell
sheet1 = (await fetch(`https://v2-api.sheety.co/aa2636dc895c9773c84fc469416db677/denverCoffeeShops/sheet1`)).json()
Insert cell
md`## Step 4: Update your Sheet`

And call your API again.
Insert cell
sheet2 = (await fetch(`https://docs.google.com/spreadsheets/d/1fudRt15kcxGVlF7pRMpPejlFNUNiFDIFoFz7Gokv-qA/edit#gid=0`)).json()
Insert cell
md`## Ideas for Further Exploration

1. Create a Google Form and expose the data as an API.
2. Create a [Mobile App](https://www.glideapps.com/) from your API.
3. [Pull data in to your Sheet](https://mixedanalytics.com/api-connector/).
4. Create a [*Content Management System*](https://steinhq.com/).`
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more