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.
- 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
Course Curriculum
- Start
9_SheetData_as_JSON_Output (2:37)
- Start
5_Output_from_a_file (8:30)
- Start
11_Request_parameters (3:18)
- Start
7_Spreadsheet_Data_2 (2:33)
- Start
10_WebPage_Connection_Fetch (6:10)
- Start
2_Use_HtmlService_createHtmlOutput (8:26)
- Start
6_Spreadsheet_Data (8:21)
- Start
3_parameters_in_the_URL (6:28)
- Start
4_Client_side_-_Server_Side_Code (5:31)
- Start
12_Request_parameters_2 (4:52)
- Start
8_Data_as_JSON_Output (5:09)
- Start
1_Create_Google_Script (3:52)
- Start
13_Sheet_Data_as_JSON_API_Conclusion (1:19)
- Start
0_Sheet_Data_as_JSON_API_Introduction (3:17)