Description
In this course, you will learn :
- How to use Google Sheets data to generate JSON for your website.
- Create a fun interactive project from the ground up.
- Investigate the possibilities for using Google Services for web content.
- Create an Endpoint to which you can send AJAX data requests.
- Experiment with connecting to JSON data with JavaScript.
Syllabus :
1. Introduction to sharing Google Sheets as JSON in a Web app with Apps Script Code
- Introduction to course content Google Sheet Data Update Introduction
- How to get started with Apps Script Setup Sheet and Script
- How to Output Sheet Data as WebApp as JSON data
- How to transform data in Object with rows included Rebuild Object Data
- Apps Script Get Source Code for WebApp JSON endpoint from Sheets
2. Connect to JSON from sheets data using JavaScript - Interactive Sheet data
- Use of JavaScript Fetch to get data JavaScript Connection using Fetch
- JavaScript Fetch JSON sheet data from web app URL and output it in the console.
- Use JavaScript to output JSON data to webpage JavaScript Output Data to Page.
- Adding click event buttons Interactive Page Buttons JavaScript
- Using Apps Script POST data from WebPage to Sheet
- Apps Script Add Post Data to Sheet connecting the data JSON
- Final Code Debugging JavaScript.
- Google Sheet Data Update Review.