Learn to use Data in a Google Sheet to output as JSON with AJAX

Improve and speed up the functionality of your web site by connecting your web pages directly to your data, using Google Sheets as a serverless way to access your data without a database. User requests and queries will go to the data stored in your Google Sheets and get results returned in real time—without waiting for the page to reload.
Learn how to create a Google Sheets spreadsheet, connect to Google Sheets with jаvascript Fetch, and return queries in JSON. See how to use the data directly on your web pages and within your web applications. Get practical experience building a sample dynamic web app. The example app creates a URL generator for your website that uses a simple input field to specify the appropriate Google Sheet, and then returns the results from interactive web input fields specific to each request.
Learn by doing: build a fun, interactive project from scratch. Learn by repeating: Practice connecting to JSON data with jаvascript. Learn by exploring: Investigate options for using Google Services for web content.
Screenshots

#