Create Dynamic JavaScript Pages with AJAX, APIs, and JSON you own this product

Laurence Svekis
  • Course duration: 20h 16m

placing your order...

Don't refresh or navigate away from the page.
liveVideo liveVideo courses make it simple to learn complex concepts and technologies. Through quality lessons and short videos from expert programmers, you'll gain the skills you need to progress your career. $71.99 $79.99 you save $8 (10%)
Create Dynamic JavaScript Pages with AJAX, APIs, and JSON (liveVideo) added to cart
continue shopping
adding to cart

choose your plan


only $41.67 per month
  • five seats for your team
  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose another free eBook every time you renew
  • choose twelve free eBooks per year
  • exclusive 50% discount on all purchases
  • Create Dynamic JavaScript Pages with AJAX, APIs, and JSON eBook for free
Look inside

Learn to use JavaScript and Google Apps Script as the backend code to use a Google spreadsheet as a data source for your website. 

Create a Google Sheets spreadsheet in your Google account. Add some data and then output it as JSON that can be retrieved via fetch request to your website. The source code is included so you can build your own version of the application.   

This course includes

  • Creating a spreadsheet with data and making the JSON object dynamic
  • How to output your sheet data as an array in a web app endpoint doGet() method for your web app
  • Restructure your JSON object with JavaScript object properties values that come dynamically from the sheet headers
  • Iterate through the sheet rows of content and assign row values into the data object to output JSON for API endpoints
  • Use JavaScript Fetch to get data 
  • Use JavaScript Fetch to get JSON sheet data from a web app URL and output it in the console
  • Use JavaScript to output JSON data to a web page
  • Add click event buttons to interactive page buttons using JavaScript to send information from a web page to a Google Sheet
  • Use an Apps Script to POST data from a web page to a Google Sheet using the doPost() method
  • Use an Apps script to post data to a Google Sheet and connect the data with JSON
  • Explore how to use a Google Apps Script IDE to debug and troubleshoot the application
  • Use JavaScript Fetch and formData methods
  • Troubleshoot and debug common CORS issues with Google Apps Web Apps
  • Use Logger to log values and text functions to Google Apps Script


Distributed by Manning Publications


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


Working knowledge of JavaScript, HTML, and CSS

what you will learn

  • How to use data in a Google Sheet to output JSON for your website
  • Build a fun, interactive project from scratch
  • Explore options to use Google Services for web content
  • Create an endpoint to make data requests using AJAX
  • Practice and explore connecting to JSON data with JavaScript
  • How to use data in a Google Sheet to get output in JSON for your AJAX website

about the instructor

Laurence Svekis is an experienced Google developer who worked on multiple enterprise level applications, hundreds of websites and business solutions, and many unique and innovative web applications. He created his first computer application in 1990 and first website in 1998. Laurence has been providing web development courses and digital marketing strategy courses since 2002, teaching countless learners how to bring amazing things to life online.
what's a liveVideo?
Find out more