GAS Lab

GAS Lab

[GAS Beginner Series #34] Get All Emails in a Thread: How to Use GmailThread.getMessages() and Handle Arrays

In the previous tutorial (#33 on GmailApp.search()), we lear...
GAS Lab

[GAS Beginner Series #33] Search Gmail Automatically: How to Use GmailApp.search() & Search Queries

Sifting through a mountain of emails every day to manually f...
GAS Lab

[GAS Beginner Series #32] Send HTML Formatted Business Trip Reports Automatically: How to Use GmailApp.sendEmail() with CC and BCC

In the previous post (Episode #31), we learned how to read b...
GAS Lab

[GAS Beginner Series #31] Create HTML Business Trip Report Drafts in Gmail: GmailApp.createDraft() Tutorial

Whether it's attending a tech conference in Tokyo or conduct...
GAS Lab

[GAS Beginner Series #30] Prevent Script Crashes: Master try…catch Error Handling in Google Apps Script

Have you ever built an automation tool in Google Apps Script...
GAS Lab

[GAS Beginner Series #29] Format Dates and Times Easily: How to Use Utilities.formatDate() and Format Patterns

Have you ever run into this frustrating issue while working ...
GAS Lab

[GAS Beginner Series #28] Build Custom Sidebars in Google Sheets: Ui.showSidebar() Complete Guide

When working in Google Sheets, have you ever thought, "I wis...
GAS Lab

[GAS Beginner Series #27] Display Custom HTML Dialogs in Google Sheets: How to Use Ui.showModalDialog()

In our previous articles (Parts 25 and 26), we kicked off th...
GAS Lab

[GAS Beginner Series #26] Prompt User Input: How to Use Ui.prompt(), Retrieve Input Values, and Handle Conditional Branching

Have you ever thought, "When my program runs, I wish I could...
GAS Lab

[GAS Beginner Series #25] Display Popup Messages: Create Yes/No Confirmation Dialogs with Ui.alert()

As you get more comfortable building automation scripts and ...