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
Who this course is for:
- Advance Google Apps Script Developer who want to go a step further
Requirements
- HTML, CSS and Javascript is the prerequisite as we are creating Web Application