Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Apps Script Web App include Access Control via Sheet Data
Rating: 4.7 out of 5(20 ratings)
1,562 students

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
Created byLaurence Svekis
Last updated 6/2025
English

What you'll 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

Course content

2 sections • 20 lectures • 54m total length

  • Project Introduction Access WebApp URL3:26
  • How to create WebApp WebApp with Google Apps Script.3:07
  • How to Create WebApp Client Side code for the web url page4:17
  • Source Code to create WebApp Client Side code snippet0:02
  • How to Get Session User GSuite organization Accounts4:48
  • Source Code to get session user email0:05
  • Check for an email value in Sheet data Check for email in spreadsheet5:50
  • How to check values in sheets using Apps Script Check for email in spreadsheet3:15
  • Source Code to check spreadsheet data0:15
  • How to Update Client Side template Google Apps Script Course4:31
  • Source Code to create a client side templates0:17
  • How to include files CSS JS into multiple pages Google Fonts and CSS stylesheet4:10
  • Source Code to include files in web app client side pages0:13
  • Explore more about Session Permissions GSuite4:18
  • Resources Class Session using Google Apps Script limitations and permissions0:30
  • How to create a webapp Access WebApp URL Project Conclusion4:27

Requirements

  • Coding experience required
  • JavaScript HTML and CSS
  • Google Account

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.

Who this course is for:

  • Web Developers
  • JavaScript coders
  • Anyone who wants to learn more about creating applications with Apps Script

Report abuse