This is the code repository for Using Google Sheets as a JSON data source for JavaScript [Video], published by Packt. It contains all the supporting project files necessary to work through the video course from start to finish.
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.
- Learn how to setup the JSON URL of your Google Sheet
- Using Fetch get the URLs and bring the data into JavaScript
- Use promise to ensure your data is within your JavaScript
- Create an object on the fly using the data contained within the spreadsheet
- Use the new JavaScript object full of data within your JavaScript to output and use the content.
To fully benefit from the coverage included in this course, you will need:
- This course is for anyone who wants learn more about Googlesheets. Anyone who wants to combine the power of Google sheets and access it from a web application.
This course has the following software requirements:
N/A
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent