Web Application with Google Apps Script

Learn to send data from Google Sheets back end to the front end using templates in Google Apps Script, including name and company, and render dynamic tables with loops.

Send front-end form data: name, email, phone, hobby to a Google Sheet via Apps Script, writing to the sheet. Leverage google.script.run with success and failure handlers to handle errors.

Show row data from a sheet in a sidebar using Google Apps Script by retrieving the active row and passing the header and data to an HTML service template.

Build a Google Apps Script web app to send templated emails from a dialog, using a templates sheet, placeholder replacement, and Gmail integration for dynamic subject, body, and recipient.

Build a dynamic web form with Google Apps Script and Bootstrap 4, collecting name, age, date of birth, email, gender, and file uploads into a Google Sheet.

Build a Google Apps Script web app to fetch sales data from a sheet and refresh the display without reloading the page, creating a dashboard that auto-updates every five seconds.

Create a Google Apps Script web app that fetches deals from Pipedrive and adds notes to a selected deal via the api.

Build a punch-in and punch-out system for office attendance with Google Apps Script, mapping employee ID to name and recording timestamps in an attendance sheet.

Create a Bootstrap web app with Google Apps Script where students enter their ID and email to receive and verify an OTP, then view their English, math, and science results.

Create a Google Apps Script web app that delivers a multi-level marketing dashboard for each user, showing self and team points and earnings while safeguarding data privacy.

Create a Google Apps Script based feedback system that emails a unique link for users to rate and comment, prevents duplicate submissions, and stores results in a sheet.

Develop a customer-facing freight quotation system using Google Apps Script, HTML service, and Bootstrap to compute port-to-port quotes from weight-based pricing rules.

Celebrate completing the course and share feedback on what you liked or found missing. Explain how you apply this knowledge in your personal life or in your organization.