Apps Script Web App include Access Control via Sheet Data

Create a web app control access using your Spreadsheet include files in the web app all using Google Apps Script

4.50 (19 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
Apps Script Web App include Access Control via Sheet Data
1,557
students
1 hour
content
Feb 2023
last update
$49.99
regular price

What you will learn

How to create an Apps Script Web App and get a web URL

How to select content from spreadsheet and output to web app as data

How to include other files into client side code

How to connect spreadsheet data

Description

WebApp Access Control from Spreadsheet - Explore how to include CSS into client side pages of you webapp

Discover how to connect Spreadsheet data to output into a webapp with Google Apps Script

Find out more about using Session Class and other common Google Apps to connect G Suite Apps together to do some amazing things with code.

Create a Google Apps Script web app - control access to the web app url using Google Sheets as a list of allowed users to view the app. JavaScript and prior coding experience is REQUIRED DO NOT TAKE THIS COURSE WITHOUT JavaScript Experience

Source code is included - Best way to learn is to try the code and create your own version of this project

Taught by an instructor with over 20 years of web development experience ready to help you learn

Google Developer Expert - Laurence Svekis walks you through how to do some amazing functionality to save time and get the most out of Google Apps Script G Suite content

Fast friendly support is always available in the Q&A section

What are you waiting for - this could change everything - at least change the way you use Google Apps and G Suite Google Sheets and send emails.

Course covers how to include files in web app - creating include function to include css and js files on the client side.

Use session user to detect the active user and either allow or deny - show custom output to the user depending on the dynamic list within a spreadsheet

Use Google apps script and connect G Suite Apps to power up your Google G Suite Apps and do some amazing things.

Google Apps Script is like JavaScript written in the cloud.

Connect G Suite Apps together.

Content

Introduction to webapp project get sheet data into client side

Project Introduction Access WebApp URL
How to create WebApp WebApp with Google Apps Script.
How to Create WebApp Client Side code for the web url page
Source Code to create WebApp Client Side code snippet
How to Get Session User GSuite organization Accounts
Source Code to get session user email
Check for an email value in Sheet data Check for email in spreadsheet
How to check values in sheets using Apps Script Check for email in spreadsheet
Source Code to check spreadsheet data
How to Update Client Side template Google Apps Script Course
Source Code to create a client side templates
How to include files CSS JS into multiple pages Google Fonts and CSS stylesheet
Source Code to include files in web app client side pages
Explore more about Session Permissions GSuite
Resources Class Session using Google Apps Script limitations and permissions
How to create a webapp Access WebApp URL Project Conclusion

Reviews

Silvio
November 14, 2022
Enquanto um novato em google apps script, está superando minhas expectativas. Estou ansioso para aplica na prática.
Jacob
August 8, 2020
Did coding once, couldnt get the hang of it, but after seeing the const and getapp and codes of nature it comes back to me little by little
Paul
July 16, 2020
This course was key to helping build a project for work where I was able to build a web app and grant permissions to specific employees. It would have taken me a long time to figure out how to do this on my own. Thanks to Laurence always delivering real world solutions to problems. Great course with easy to follow instructions and code. I am sure I will be referring back to this course again soon. Excellent project based course.

Coupons

DateDiscountStatus
7/24/202380% OFF
expired

Charts

Price

Apps Script Web App include Access Control via Sheet Data - Price chart

Rating

Apps Script Web App include Access Control via Sheet Data - Ratings chart

Enrollment distribution

Apps Script Web App include Access Control via Sheet Data - Distribution chart
3263990
udemy ID
6/23/2020
course created date
7/6/2020
course indexed date
Angelcrc Seven
course submited by