Google Sheets - Google Workspace Insights

Google Apps Script

Build a Web App with Google Apps Script: doGet, doPost, and HTML Service

Learn how to build and deploy a web app using Google Apps Script. Covers doGet, doPost, HtmlService, URL parameters, form submissions to Sheets, JSON APIs, templated HTML, and deployment permissions.

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.

Google Apps Script

Generate Google Docs from Sheets Data with Apps Script: Automated Document Templates

Learn how to use Google Apps Script to automatically generate Google Docs from Sheets data. Step-by-step tutorial covering templates, merge fields, PDF export, Drive filing, and batch document generation for invoices, offer letters, and client reports.

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.

Google Sheets

ARRAYFORMULA and LAMBDA for Array Calculations

Learn how to use ARRAYFORMULA and LAMBDA in Google Sheets to automate array calculations. A practical tutorial for Australian SMB power users.