Apps Script Web App include Access Control via Sheet Data
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
- Preview03:26
- Preview03:07
- 04:17How to Create WebApp Client Side code for the web url page
- 00:02Source Code to create WebApp Client Side code snippet
- 04:48How to Get Session User GSuite organization Accounts
- 00:05Source Code to get session user email
- 05:50Check for an email value in Sheet data Check for email in spreadsheet
- 03:15How to check values in sheets using Apps Script Check for email in spreadsheet
- 00:15Source Code to check spreadsheet data
- 04:31How to Update Client Side template Google Apps Script Course
- 00:17Source Code to create a client side templates
- 04:10How to include files CSS JS into multiple pages Google Fonts and CSS stylesheet
- 00:13Source Code to include files in web app client side pages
- 04:18Explore more about Session Permissions GSuite
- 00:30Resources Class Session using Google Apps Script limitations and permissions
- 04:27How to create a webapp Access WebApp URL Project Conclusion
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
Instructor
![Laurence Svekis](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 40,008 Reviews
- 682,223 Students
- 365 Courses
I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today
Google Developers Expert - GSuite
Providing Web development courses and digital marketing strategy courses since 2002.
Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.
"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998. I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."
"Learning, understanding with a strong passion for education. The internet has provided us with new opportunities to expand and share knowledge."
Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online. Technology connects us all in many ways. It opens up doors to those who embrace it and learn how to make those connections real.
"My courses are designed to help you achieve your goals, learn and update skills"
Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO.
"Understanding technology provides a means to better connect with users. It also opens so many doors. Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"