Google Spreadsheet API Apps Script and JavaScript

Google Spreadsheet API Apps Script and JavaScript, available at $59.99, has an average rating of 4.55, with 23 lectures, based on 97 reviews, and has 2483 subscribers.

You will learn about How to apply JavaScript AJAX and JSON Google Apps Script how to setup a web app This course is ideal for individuals who are Web developers or JavaScript Coders or Application Developers It is particularly useful for Web developers or JavaScript Coders or Application Developers.

Enroll now: Google Spreadsheet API Apps Script and JavaScript

Summary

Title: Google Spreadsheet API Apps Script and JavaScript

Price: $59.99

Average Rating: 4.55

Number of Lectures: 23

Number of Published Lectures: 23

Number of Curriculum Items: 23

Number of Published Curriculum Objects: 23

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

How to apply JavaScript AJAX and JSON

Google Apps Script how to setup a web app

Who Should Attend

Web developers

JavaScript Coders

Application Developers

Target Audiences

Web developers

JavaScript Coders

Application Developers

Explore how you can setup a simple application that can output your Spreadsheet content as JSON data to be used within your websites.   Using Google Apps Script your can setup a web app URL that can receive GET and POST requests.  The GET requests can be set to output spreadsheet object data as JSON.

Additionally explore how you can send input data to your spreadsheet from your website.  Using Google Apps Script POST web app, you can get data requests and add them to your Spreadsheet

You will be amazed at how easy it can be to setup this powerful application.

Source Code is included to get you started quickly

Course Covers :

Basics to web editor for writing Google Apps Script

Setup of Bound script for Spreadsheet Data

Creation of web app

Output of Spreadsheet data as JSON in web app format

Use of fetch to connect to API web app endpoint to get JSON data

JavaScript to loop through content in JSON JavaScript Object

Creating elements using the document object

Styling and debugging of webapp application

Taught by an instructor with over 20 years of web development experience ready to help you learn.

You Have nothing to lose – create your own version of the app TODAY.

Course Curriculum

Chapter 1: Introduction to AJAX connections to Google Spreadsheet API

Lecture 1: Google Get Post Web API Introduction

Lecture 2: Web Developer Setup.

Lecture 3: Source

Lecture 4: Write Google Apps Script

Lecture 5: Get Spreadsheet Data

Lecture 6: Source

Lecture 7: Web App Content

Lecture 8: Source

Lecture 9: Connect to WebApp URL.

Lecture 10: Source

Lecture 11: Post Data to Sheet.

Lecture 12: source

Lecture 13: WebApp POST.

Lecture 14: SOURCE

Lecture 15: Add POST to Spreadsheet

Lecture 16: Source Code

Lecture 17: DeBug and Clean Code

Lecture 18: Source Code

Lecture 19: Application Conclusion Code review

Lecture 20: Project Source Code

Chapter 2: Google Apps Script sample code

Lecture 1: How to get all files from Folder with Google Apps Script DriveApp

Lecture 2: JavaScript xhr vs fetch for JSON

Lecture 3: Apps Script Guide and sample code

Instructors

Laurence Svekis
Instructor, GDE, Application Developer

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 9 votes

4 stars: 33 votes

5 stars: 53 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!