How to convert Google Sheets data to JSON … in just 3 steps Below is a basic rundown on how I managed to get a Google Sheets to JSON solution in place to power part of my website without having to use an sort of CMS.