Google Apps Script: Fun API And JSON Data Spreadsheet

No Rating(0)
See all reviews

This course is designed for those interested to learn the basics of Google Apps Script, Google Web Apps, their features and uses, and how to create a simple endpoint of JSON data.

Watch Free For 30 Days

start free access


buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This Courseintermediate

If you’ve been looking to get started with Google Web Apps – this course is for you.

One of the most common questions I get is how to use Spreadsheet data in a web application. This course will cover how to set up a web app and output sheet data as JSON to a web URL endpoint, which can then be used to display and use the data within any web application or web site.

In this course, you will learn: 

  • How to use HtmlService to output HTML page contents
  • How to set up web app for web URL 
  • Create a WebApp
  • About WebApp Client side – Server Side Code
  • About client side Google Script option
  • How to output from a file
  • Getting spreadsheet data
  • Getting data as JSON output
  • About SheetData as JSON Output
  • About WebPage Connection Fetch
  • About e parameters in request URI
  • About conditions with parameters


  • JavaScript 
  • Programming knowledge  

Please note that the scope of this course is creating a simple endpoint of JSON data and will not cover complex commands and everything about javascript. This is a simple how to get started course. If you are looking at more detailed google script content, this is not for you.

Our Promise to You

By the end of this course, you will have learned about setting up a web app and output sheet data.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about JSON data spreadsheet.

Course Curriculum

Course Sections

Sheet Data As JSON API Introduction

Downloadable Materials – Course Guide And Source Codes

Create Google Script

Use HtmlService createHtmlOutput

Parameters In The URL

Client Side – Server Side Code

Output From A File

Spreadsheet Data

Spreadsheet Data 2

Data As JSON Output

SheetData as JSON Output

WebPage Connection Fetch

Request Parameters

Request Parameters 2

Sheet Data As JSON API Conclusion


No Reviews found for this course.