Web Application with Google Apps Script

Create 10 Web Applications using HTML, CSS, Javascript & Bootstrap

Ratings 4.62 / 5.00

What You Will Learn!

Create Sidebars and Dialogs in Google Spreadsheet
Create Web Application with Google Sheet as backend
Create Live Dadshboard
Host the Web Application and distribute it to users

Description

IMPORTANT: HTML, CSS and Javascript knowledge is must to benefit from this course

This course is designed to teach you how to develop web applications using Google Apps Script. Google Apps Script is a cloud-based scripting language that allows developers to create powerful applications and automate workflows using various Google services such as Google Sheets, Google Drive, and Gmail.

You will learn the fundamentals of web development. You will then explore how to use Google Apps Script to build dynamic web applications, including creating custom forms, processing data, and integrating with other services.

The course will cover the following topics:

Introduction to Google Apps Script UI Elements
Setting up a development environment for Web Applications
Building user interfaces with HTML Service
Processing data with Forms and Sheets
Working with Google Drive and Gmail
Advanced scripting techniques

Throughout the course, students will work on 10 high-level projects that will demonstrate their understanding of the concepts covered. These projects will include:

Show Row Data from Sheet in Sidebar
Send Templated Email from Dialog
Create a dynamic Form that can be filled by anyone
Fetch Data from Sheet without Reloading the Web Application
A system to add Notes in Deals in Pipedrive from Web App
Make a Punch-in and Punch-out System for Office Attendance
Create a system for students to see their result on Web App with OTP
Create a Multi Level Marketing Dashboard showing Points and Earnings
Create a Feedback Collection System that allows user to submit feedback only Once
Create a system where a user can check Quotation for Cargo Load by giving port and weight details

By the end of this course, students will have a strong understanding of web development principles, as well as the skills to build powerful web applications using Google Apps Script. They will also have a strong portfolio of projects to showcase their skills to potential employers or clients.

All the Best