Tutorialspoint

Apps Script Web App FUN API and JSON Data Spreadsheet

Output Spreadsheet data as a web app URL with JSON feed of contents of the Spreadsheet. Run code and customize endpoint

  Laurence Svekis

   Development, Web Development, Web Development Other

Language - English Published on 06/2020

  • Sheet Data as JSON API Introduction
    03:17
    Preview
  • Course resource Guide and lesson helper
  • Course Resources
  • Create Google Script
    03:52
    Preview
  • Use HtmlService createHtmlOutput
    08:26
    Preview
  • Parameters in the URL
    06:28
  • Client side - Server Side Code
    05:31
  • Output from a file
    08:30
  • Spreadsheet Data
    08:21
  • Spreadsheet Data 2
    02:33
  • Data as JSON Output
    05:09
  • SheetData as JSON Output
    02:37
  • WebPage Connection Fetch
    06:10
  • Request parameters
    03:18
  • Request parameters 2
    04:52
  • Sheet Data as JSON API Conclusion
    01:19

Description

Bonus free PDF guide packed full of resources and code snippets to help you learn - follow the lessons using the guide!  Learning made easy :)

One of the most common questions I get is how to use Spreadsheet data in a web application.  This course will cover how to setup 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.

Please note that the scope of this course is creating a WEB APP with Google Apps Script code, JavaScript and previous programming knowledge is an essential prerequisite to this course. 

YOU MUST HAVE JAVASCRIPT KNOWLEDGE TO TAKE THIS COURSE

Course covers

  • Use of HtmlService to output HTML page contents

  • Setup of web app for web URL Create a WebApp

  • WebApp Client side - Server Side Code

  • Client side Google Script option

  • Output from a file

  • Getting Spreadsheet Data

  • Data as JSON Output

  • SheetData as JSON Output

  • WebPage Connection Fetch

  • E Parameters in request URI

  • Conditions with parameters

Taught by an instructor with over 20 years of Web Development experience.

If you've been looking to get started with Google Web Apps -  THIS COURSE IS FOR YOU!!!!

Who this course is for:

  • Web developers
  • Web designers
  • Web application developers
  • WebMasters
  • Anyone who wants to learn more about Google Apps Script
  • Anyone who wants to use Spreadsheet data in an application

What Will I Get ?

  • How to use Google Script to create WebApps
  • How to select content from Spreadsheets
  • How to output API JSON endpoint

Requirements

  • JavaScript and HTML
  • Internet Access
  • Programming experience

    Feedbacks (0)

  • No Feedbacks Posted Yet..!

We make use of cookies to improve our user experience. By using this website, you agree with our Cookies Policy.