Web Application With Google Apps Script

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

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

Requirements

HTML, CSS and Javascript is the prerequisite as we are creating Web Application

Description

IMPORTANT: HTML, CSS and Javascript knowledge is must to benefit from this courseThis 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 ElementsSetting up a development environment for Web ApplicationsBuilding user interfaces with HTML ServiceProcessing data with Forms and SheetsWorking with Google Drive and GmailAdvanced scripting techniquesThroughout 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 SidebarSend Templated Email from DialogCreate a dynamic Form that can be filled by anyoneFetch Data from Sheet without Reloading the Web ApplicationA system to add Notes in Deals in Pipedrive from Web AppMake a Punch-in and Punch-out System for Office AttendanceCreate a system for students to see their result on Web App with OTPCreate a Multi Level Marketing Dashboard showing Points and EarningsCreate a Feedback Collection System that allows user to submit feedback only OnceCreate a system where a user can check Quotation for Cargo Load by giving port and weight detailsBy 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

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Sidebar & Dialogs

Lecture 3 Web Application

Section 2: Sharing Data Between Front end and Back end

Lecture 4 Sending Data from Google Sheet (Back end) to Front End

Lecture 5 Sending Data from Front end to Google Sheet (Back end)

Lecture 6 Sending Data as an HTML Form

Section 3: Projects

Lecture 7 Project 1: Show Row Data from Sheet in Sidebar

Lecture 8 Project 2: Send Templated Email from Dialog

Lecture 9 Project 3: Create a dynamic Form

Lecture 10 Project 4: Fetch Data from Sheet without Reloading the Web Application

Lecture 11 Project 5: A system to add Notes in Deals in Pipedrive from Web App

Lecture 12 Project 6: Make a Punch-in and Punch-out System for Office Attendance

Lecture 13 Project 7: Create a system for students to see their result on Web App with OTP

Lecture 14 Project 8: Create a Multi Level Marketing Dashboard showing Points and Earnings

Lecture 15 Project 9: Create a Feedback Collection System

Lecture 16 Project 10: Create a system where a user can check Quotation for Freight Load

Section 4: Thank You

Lecture 17 Thank You for completing the course

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