Apps Script - Google Workspace Insights

Google Workspace

Time-Based Triggers in Google Apps Script: Schedule Automations to Run on Autopilot

Learn how to use time-based triggers in Google Apps Script to schedule automations that run without any manual intervention — daily reports, weekly cleanups, hourly data syncs, and more.

Google Sheets

Sync Data Between Two Google Sheets with Apps Script: Keep Spreadsheets in Sync Automatically

Learn how to sync data between two Google Sheets using Apps Script. One-way and two-way sync, conflict handling, time-based triggers, and real-world examples for Australian businesses.

Google Workspace

Build a Sidebar App in Google Sheets with Apps Script and HTML

Learn how to build a sidebar app in Google Sheets using Apps Script and HtmlService. Covers HTML templates, showSidebar(), google.script.run, CSS styling, and three practical examples.

Google Sheets

Send Emails from Google Sheets with Apps Script: Step-by-Step Guide

Learn how to send emails directly from Google Sheets using Apps Script. Covers MailApp vs GmailApp, HTML templates, reading recipient data, attachments, quota limits, error handling, and tracking sent status.

Google Workspace

onEdit and onOpen Triggers in Google Apps Script: Automate Sheets Without Clicking a Button

Learn how to use onEdit and onOpen triggers in Google Apps Script to automate Google Sheets in real time — no manual button clicks required. Covers simple vs installable triggers, event objects, custom menus, auto-timestamps, data validation, and email notifications.

Apps Script

Apps Script Error Handling and Debugging: Fix Broken Scripts Like a Pro

Master Google Apps Script error handling and debugging. Learn try/catch blocks, Logger.log vs console.log, the Execution Transcript, breakpoints, common error types, and how to log errors to Sheets and Cloud Logging.

Google Sheets

How to Build Custom Menus in Google Sheets with Apps Script

Learn how to build custom menus in Google Sheets using Apps Script. Step-by-step tutorial covering onOpen(), menu items, submenus, dynamic menus, and UI dialogs for Australian businesses.

Google Sheets

Custom Functions in Google Sheets: Build Your Own Formulas with Apps Script

Learn how to write custom functions in Google Sheets using Apps Script. Build a GST calculator, ABN validator, and AU date formatter — with JSDoc, array support, and CacheService.

Google Calendar

Create Google Calendar Events from Sheets with Apps Script: Automate Your Scheduling

Learn how to create Google Calendar events automatically from Google Sheets using Apps Script. Practical tutorial covering timed events, all-day events, reminders, guests, Australian date formats, duplicate prevention, colour coding, and real-world use cases.

Google Workspace

Google Apps Script for Beginners: Your First Script in Google Sheets

Learn Google Apps Script from scratch. Open the editor, write your first script, and automate Google Sheets — no coding experience needed.

Gmail

Auto-Archive Gmail Emails with Apps Script: Keep Your Inbox Clean Automatically

Learn how to auto-archive Gmail emails using Google Apps Script. Step-by-step tutorial covering GmailApp.search(), time-based triggers, label-based archiving, and logging actions to Google Sheets for a clean inbox on autopilot.

Apps Script

Apps Script Cloud Projects for Advanced Automation

Learn how to link Apps Script to a Google Cloud project for Cloud Logging, IAM, and APIs that go far beyond what default projects support.