This session covers the Contact Record Keeper script, synchronizing Google Contacts with a Google Sheet. Attendees will see how to retrieve and manage contact information, clear existing sheet data, and update the sheet with the latest details, ensuring an up-to-date contact database through automation

This presentation delves into the Login Authentication System, which uses Google Apps Script to authenticate users based on credentials stored in a Google Sheet. Attendees will gain insights into creating a secure login system, validating credentials, and managing user sessions securely.

This presentation introduces the Task Scheduler script, which automates capturing task details from Google Form submissions and logging them into a Google Sheet. Participants will learn how to handle form submissions, extract responses, and update a Google Sheet dynamically, enhancing data collection and task management efficiency.

The presentation explores the Email Generator script, designed to send personalized emails using data from a Google Sheet. Participants will learn how to read sheet data, loop through it to send emails, and use MailApp for automation, improving communication efficiency.