Apps Script Web App FUN API and JSON Data Spreadsheet
5.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,026 students enrolled

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
5.0 (2 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,026 students enrolled
Created by Laurence Svekis
Last updated 1/2020
English
English [Auto]
Current price: $64.99 Original price: $99.99 Discount: 35% off
8 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 13 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to use Google Script to create WebApps
  • How to select content from Spreadsheets
  • How to output API JSON endpoint
Course content
Expand 27 lectures 01:14:59
+ Introduction Apps Script Web App FUN API and JSON Data Spreadsheet
27 lectures 01:14:58
Course resource Guide and lesson helper
00:04
Source Code
00:04
parameters in the URL
06:28
Source Code
00:04
Client side - Server Side Code
05:31
Source Code
00:05
Output from a file.
08:31
Source Code
00:05
Spreadsheet Data
08:22
Source Code
00:07
Spreadsheet Data 2.
02:33
Source Code
00:11
Data as JSON Output.
05:09
Source Code
00:04
SheetData as JSON Output
02:38
Source Code
00:10
WebPage Connection Fetch
06:10
Source Code
00:03
Request parameters.
03:18
Source Code
00:04
Request parameters 2
04:52
Source Code
00:06
Sheet Data as JSON API Conclusion.
01:19
PDF Guide and source code in text
03:19
Requirements
  • JavaScript and HTML
  • Internet Access
  • Programming experience
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!!!!

Nothing to lose - Fast friendly support is always available to help if you need it.

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, JSON its a simple HOW TO GET STARTED COURSE - if you are looking at more detailed Google Script content this is not 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