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

Laurence Svekis
  • Course duration: 1h 19m
filed under

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. $20.99 $29.99 you save $9 (30%)
Learn to use Data in a Google Sheet to output as JSON with AJAX (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
  • Learn to use Data in a Google Sheet to output as JSON with AJAX eBook for free
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