Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • Web developers
  • Webmasters
  • Anyone who wants to practice JavaScript with API connection

What you’ll learn: 

  • How to connect to a web API
  • How to use JavaScript DOM to create page elements
  • Loop through JSON data
  • Explore Google Web App data from spreadsheet


  • JavaScript, HTML, and CSS
  • Programming experience

Welcome to the course that will show you how you can apply JavaScript to connect to a web API – get JSON data and build a JavaScript Quiz game from scratch using the data coming from a Google Spreadsheet. As a bonus the course will also show you how you can set up your own spreadsheet web app using Google Script so that you can customize the content and have your very own version of the questions in your application.

Source code is included – please try the code as you work through the lessons.

The course will cover:

  • How to setup the basic Project shell with HTML and CSS
  • How to use JavaScript query selector to select page elements as JavaScript objects
  • Use fetch to connect to the web app URL for data source
  • JSON data and how to prepare it in JavaScript
  • Creating a function to display data content in the web application
  • Logic to approach game design and building of the web application
  • Next steps for player and using game data
  • Debugging and advancing game design
  • Applying styling for a better looking game
  • Concluding the game quiz
  • Creating a Google Script web app using Google Spreadsheet data
  • Structuring JSON from an array object
  • Connecting sheet data to your web application

Our Promise to You

By the end of this course, you will have learned how to create an API quiz game.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about using sheet data for JavaScript.

Course Curriculum

Section 1- Introduction To Connecting To A Web API With Google Sheet Data
Introduction Dynamic Quiz Introduction 00:00:00
Web Development Environment Setup 00:00:00
Source Code Download 00:00:00
Project Setup HTML And CSS 00:00:00
JavaScript Select Page Elements 00:00:00
Get JSON Data Request Spreadsheet Data 00:00:00
JavaScript Elements Create Question 00:00:00
Check Answer Next Question 00:00:00
Bug Fixes Updates To Game 00:00:00
Random Order Array 00:00:00
Make It look Nice CSS 00:00:00
Get Google Web App Data 00:00:00
Google Web App Data 2 00:00:00
Dynamic Quiz Conclusion 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel