Google Workspace
Calamari vs BambooHR vs Factorial: Best Leave Management for Google Workspace
Compare Calamari, BambooHR, and Factorial for leave management with Google Workspace. Calendar sync, attendance tracking, AUD pricing for Australian SMBs.
Ash Ganda
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.
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.