Google Sheets as JSON data source for JavaScript
1h! Run Time
Employees
only
of Completion
Friendly
Access
Description
Turn a Google spreadsheet into a live JSON data source and pull it straight into your JavaScript application, with no database calls required.
What this course covers:
- Outputting multiple sheets from one spreadsheet as JSON data
- Accessing sheet contents with the JavaScript Fetch API
- Using that data directly inside your application
- Updating data in the sheet and seeing it update in your app
For anyone who wants to combine Google Sheets with a web app; a Google account and basic JavaScript, HTML, and CSS are needed.
System Requirements
See System Requirements in the Coggno Knowledge Base
Google Sheets as JSON data source for JavaScript
Google sheets provides 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 you 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 you application using JavaScript.
Step by step training showing you how to build an application just like the one in the course. Source Code is included to get you started quickly and easily. Make full use of you data, no more database calls just frontend code accessing your data contained within the Google Spreadsheet. Easily update your data within the sheet and see it being used within the JavaScript.
Who this course is for:
- Anyone who wants learn more about Googlesheets
- Anyone whos wants to combine the power of Google sheets and access it from a web application
- Use Google Spreadsheet as a data source
Requirements:
- Google account
- JavaScript and basic HTML and CSS knowledge
- Basic Web development understanding
Frequently Asked Questions
OSHA Compliance
- Bloodborne Pathogens Training (21)
- Electrical Safety (73)
- Fire Safety Training (50)
- First Aid Training (34)
- Forklift Training (45)
- HazCom (Hazard Communication) (51)
- Lockout/Tagout (LOTO) (24)
- OSHA 10 Hour Training (6)
- OSHA 30 Hour Training (2)
- PPE (Personal Protective Equipment) (65)
- Slips, Trips & Falls (72)
- Workplace Safety (1001)