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 JavaScript 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 JavaScript. Learn by exploring: Investigate options for using Google Services for web content.

Distributed by Manning Publications

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