Creating a Database for your site using Google Sheets FAST!

In our first Vlog post Brendan shows you how to get data from a Google Sheet sent to your front-end in JSON format. A useful trick for any site with data that needs to be edited by non-coders or quickly getting to your proof-of-concept without making a real database.

Follow these steps using Google Drive:

1) Create a Google Sheet

2) Delete blank rows and columns

3) File; Publish to Web; Publish

In your web page:

4) Send your JSON request to:

https://spreadsheets.google.com/feeds/list/  YOUR_API_KEY  /od6/public/values?alt=json

‍