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!
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