Apps Script Web App FUN API and JSON Data Spreadsheet

4.1 ★★★★ ★

Apps Script Web App FUN API and JSON Data Spreadsheet

Name: Apps Script Web App FUN API and JSON Data Spreadsheet
Rating: 4.1 (155 reviews)
Author: Laurence Svekis

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

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Laurence Svekis

English [CC]

category icon Development,Web Development

Lectures -17

Resources -2

Duration -1 hours

4.1 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course 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

Goals

What will you learn in this course:

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

Prerequisites

What are the prerequisites for this course?

JavaScript and HTML
Internet Access
Programming experience

Apps Script Web App FUN API and JSON Data Spreadsheet

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
16 Lectures

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

Instructor Details

Laurence Svekis

Course Certificate

Use your certificate to make a career change or to advance in your current career.