Learn how to Connect Data to Web Pages with JSON and JavaScript Fetch

Improve and enhance your web site’s functionality by connecting your web pages directly to your data. User requests and queries will go to the data stored in your Google Sheets and get results returned in real time.

Learn how to connect to Google Sheets with JavaScript Fetch, and return queries in JSON. See how to use the data directly on your web pages and within your web applications. Making data requests using fetch provides a seamless experience to the user without page reload. The user interacts with the web page, triggering the events that call to the data source to return the results. Using Google Sheets provides a serverless way—without a database—to query a web data source.

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.

Distributed by Manning Publications

This course was created independently by Laurence Svekis and is distributed by Manning through our exclusive liveVideo platform.

• How to setup your Google Sheet to output data as a web endpoint
• Connect to a Google Sheet from JavaScript frontend code using Fetch
• Get Sheet data as JSON format so it can be used for JavaScript
• Output Sheet data into your webpages
• Create a URL generator website from scratch with HTML, CSS, and JavaScript