Web Application with Google Apps Script

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

Ratings: 4.62 / 5.00




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:

  1. Show Row Data from Sheet in Sidebar

  2. Send Templated Email from Dialog

  3. Create a dynamic Form that can be filled by anyone

  4. Fetch Data from Sheet without Reloading the Web Application

  5. A system to add Notes in Deals in Pipedrive from Web App

  6. Make a Punch-in and Punch-out System for Office Attendance

  7. Create a system for students to see their result on Web App with OTP

  8. Create a Multi Level Marketing Dashboard showing Points and Earnings

  9. Create a Feedback Collection System that allows user to submit feedback only Once

  10. 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

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

Who Should Attend!

  • Advance Google Apps Script Developer who want to go a step further