Learn to use Data in a Google Sheet to output as JSON with AJAX you own this product

Laurence Svekis
  • Course duration: 1h 19m

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • share your subscription with another person
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!


5, 10 or 20 seats+ for your team - learn more

Look inside

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.


Experience with JavaScript, HTML and CSS

what you will learn

Learn to create a Google Sheets spreadsheet in your Google Account. Add some data and then output it as JSON, which can be retrieved via seamless fetch request to your web site.

  • Create a spreadsheet, add data, and make the JSON object dynamic
  • Restructure your JSON object with JavaScript object properties
  • Use JavaScript Fetch to get data, and JavaScript to output JSON data to web page
  • Use AJAX to create an endpoint for data requests
  • Add click event buttons to send info from web page to Google Sheet
  • Use Apps Script to add post data from web page to sheet
  • Use Google Apps Script IDE to debug and troubleshoot

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

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 product every time you renew
  • choose twelve free products per year
  • exclusive 50% discount on all purchases
  • Learn to use Data in a Google Sheet to output as JSON with AJAX liveVideo for free