Google Spreadsheet Data API Apps Script Code JSON JavaScript

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.

Show more