O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Google Sheets as a JSON data source for JavaScript

Video Description

Explore how you can setup your Google Spreadsheet to output as JSON and then Fetch the data using JavaScript

About This Video

  • Output your Google Spreadsheet data as JSON
  • Access your Google spreadsheet from JavaScript
  • Easily update your data within the sheet and see it being used within the JavaScript.

In Detail

Please note this is an intermediate level course with prerequisites of JavaScript knowledge. Google sheets provide an easy way to work with data online, did you know you can also output it as JSON. This course will show you how you can output multiple sheets from one spreadsheet as JSON data and then using JavaScript Fetch access the contents contained within the Sheet. Use the data within your JavaScript application.

You will be amazed at how easy it is to output a JSON formatted data file from your Google Sheets and then bring that data directly into your application using JavaScript. The source code is always included to help you code exactly what is presented within the lessons. Taught by a knowledgeable instructor with many years of web development experience, ready to help you learn. Join now and use your own Google spreadsheet data within your JavaScript applications.