Convert your Google spreadsheets data in to JSON data.

You can do it using two methods.

(1) Using Google Apps Script
(2) Using Google Sheets API v4

This is an alternative to SaaS tools like sheetsu.com, sheetdb.io, sheety.co, sheet.best, sheet2api.com etc.

If you work with non-IT people, use Google Sheets as a database for your projects. Google Spreadsheet is a great CMS that everyone know how to use!

You can almost do everything which is possible using HTML, Javascript and JSON data. You can GET google sheets data as a json data, you can't POST json data to google sheets. 

Wide usage of this script is for converting google sheets to dynamic html table. So in this script we have included it as an example. You can check live demo here.

Here are some other use cases:

(1) Dynamic HTML content like FAQs, Opening hours, Live sports score etc.

(2) Dynamic restaurant food menu

(3) Dynamic Charts

(4) Dynamic List of Links / Products / Services

(5) Dynamic Event Calendar

(6) Dynamic Listings / Directory with search

• Method-1: Google Apps Script
• Method-2: Google Sheets API v4
• Javascript, jQuery & PHP code examples given.
• Dynamic HTML Table example included.
• PDF tutorials given.
• Well-commented professional code

One Google Account

Download a zip file and unzip it.

PDF tutorials are given in "Documentation" folder.
Script code is given in "Script" folder.
Dynamic HTML Table example code is given in "Examples" sub-folder.