by Laurence Svekis | Released September 2018 | ISBN: 9781789801743

Explore how you can setup your Google Spreadsheet to output as JSON and then Fetch the data using JavaScriptAbout This VideoOutput your Google Spreadsheet data as JSONAccess your Google spreadsheet from JavaScriptEasily update your data within the sheet and see it being used within the JavaScript. In DetailPlease 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. Show and hide more

1. Chapter 1 : Introduction to Google Sheets as JSON
   • Introduction spreadsheet as JSON introduction 00:02:08
   • Google SpreadSheet Setup 00:04:33
   • Google SpreadSheet as JSON 00:05:12
   • JavaScript Fetch JSON 00:05:49
   • Get JSON Promise all JavaScript Example 00:09:59
   • Code explained JavaScript Map 00:08:16
   • Code explained JavaScript Promise All 00:06:00
   • Spreadsheet Data Clean Up JSON 00:10:59
   • Build the object using Sheet name 00:04:20
   • Output Sheet data to HTML 00:05:03
Show and hide more