Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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
English [Auto],

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

    Build a Google Apps Script web app that uses a spreadsheet to enforce permissions and render index or deny pages, with a shared stylesheet across multiple pages.

  • How to create WebApp WebApp with Google Apps Script.3:07

    Create access-controlled web apps by linking a Google Sheets staff list to a Google Apps Script web app, defining allowed emails, and using the spreadsheet ID to connect code.

  • How to Create WebApp Client Side code for the web url page4:17

    Learn to build a Google Apps Script web app with client-side code, using index and deny templates and a stylesheet, and publish with access control via sheet data.

  • Source Code to create WebApp Client Side code snippet0:02
  • How to Get Session User GSuite organization Accounts4:48

    Retrieve the session user with session.getActiveUser and getEmail, then pass the user data to the client via the HTML service. Display the email on the page using JavaScript and JSON.

  • Source Code to get session user email0:05
  • Check for an email value in Sheet data Check for email in spreadsheet5:50

    Connect to the spreadsheet by id, select the staff sheet, and fetch all rows as values. Check the email against the data and return the user information to the page.

  • How to check values in sheets using Apps Script Check for email in spreadsheet3:15

    Loop through sheet data with Apps Script to match an email in the first column, return a data object with role and headings, and handle found or not found outcomes.

  • Source Code to check spreadsheet data0:15
  • How to Update Client Side template Google Apps Script Course4:31

    Update the client-side template in a Google Apps Script web app to conditionally serve pages based on user presence in a sheet, using a default index template and error handling.

  • Source Code to create a client side templates0:17
  • How to include files CSS JS into multiple pages Google Fonts and CSS stylesheet4:10

    Learn how to include shared CSS and JS across multiple Google Apps Script HtmlService pages by creating an include function, inlining styles, and loading Google fonts.

  • Source Code to include files in web app client side pages0:13
  • Explore more about Session Permissions GSuite4:18

    Learn how the session class identifies the active user, resolves cross-domain access issues, and publishes and authorizes web apps so external users can access spreadsheets.

  • Resources Class Session using Google Apps Script limitations and permissions0:30
  • How to create a webapp Access WebApp URL Project Conclusion4:27

    Learn how to implement access control in a Google Apps Script web app using a spreadsheet of authorized users, session email checks, and dynamic page rendering with templated output.

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