Virginia Tech® home

Google Sheet to JSON

This tool will convert a Google Sheet into static JSON object accessible from any URL. 

Authorization


The Google Sheet must be shared with the Google Account (pcob@vt.edu) with Editor capabilities for the script to work properly.

The script will pull the sheet with the lowest ID. The initial sheet is always set to "0". If you have multiple sheets, label the Sheets "data" and the script will pull that specific one.

https://docs.google.com/spreadsheets/d/
/edit#gid=0