10-Day Google Apps Script Learning Guide

Day 1 – Introduction to Google Apps Script Goals: Topics: Code Example: Practice: Quiz (3 questions): Day 2 – Working with Google Sheets Goals: Topics: Code Example: Practice: Quiz (2 questions): Day 3 – Reading and Writing Ranges Goals: Code Example: Practice: Quiz (2 questions): Day 4 – Loops and Logic in Apps Script Goals: … Read more

Build a Simple Likert-Scale Quiz Web App with Google Apps Script + Sheets

This post walks through what the provided code does and how to set up the Google Sheet it expects. When you’re done, you’ll have a lightweight web app that: What the Code Does (at a glance) 1) doGet(e) — serve the web app 💡 Note about getActiveUser()This returns a non-empty email when your script runs … Read more

4-Day Flash Sale Udemy Course Coupons

4-Day Flash Sale: Use AUGA25 for the BEST PRICE POSSIBLE (Aug 27–30, 2025) Did you miss any deals? Now’s your chance to jump back in and start learning today! For the next 4 days, use promo code AUGA25 on my courses to unlock the best price possible. How it works:Click any course link below—the code … Read more

100 high impact copy pasteable Google Sheets Apps Script snippets

100 high-impact, copy-pasteable Google Sheets Apps Script snippets  How to use A. Setup & Quality-of-Life 1) Add a Custom Menu Creates a “Sheet Tools” menu with quick actions. function onOpen() {   SpreadsheetApp.getUi()     .createMenu(‘Sheet Tools’)     .addItem(‘Clear Selected Range’, ‘clearSelectedRange’)     .addItem(‘Timestamp Selected Cells’, ‘timestampSelection’)     .addToUi(); } function clearSelectedRange() {   const range = SpreadsheetApp.getActiveRange();   if (range) range.clearContent(); } … Read more

JavaScript Code Snippet Reference 100 Essential Snippets

1. DOM Selection & Manipulation 1. Select an Element by ID const element = document.getElementById(‘myId’); Explanation: Selects a single DOM element with the ID myId. 2. Select Elements by Class Name const elements = document.getElementsByClassName(‘myClass’); Explanation: Returns a live HTMLCollection of all elements with the class myClass. 3. Select Elements by Tag Name const elements … Read more

Useful JavaScript Snippets for Web Developers

Useful JavaScript Snippets for Web Developers A curated collection of essential vanilla JavaScript code snippets, organized into categories for easy reference. Each snippet includes a practical example and a detailed explanation. 📂 1. DOM Manipulation Working with the Document Object Model is a cornerstone of front-end development. 1.1. Select a Single Element Select the first … Read more

Send Custom Emails from Google Sheets Using Apps Script

📧 Send Custom Emails from Google Sheets Using Apps Script If you’ve ever needed to send personalized emails to multiple recipients—such as confirmation emails, reminders, or announcements—Google Apps Script offers a powerful way to automate this process using data from a Google Sheet. In this post, you’ll learn how to create a simple mail merge … Read more

Automatically Timestamp Data Entries with Google Apps Script

📊 Automatically Timestamp Data Entries with Google Apps Script When working with Google Sheets, it’s often helpful to automatically add timestamps whenever data is entered or updated. Whether you’re tracking form submissions, logging status updates, or managing tasks, having an automatic “last modified” or “created on” column can boost clarity and accountability. In this blog … Read more

10 Practical Google Apps Script Tips to Supercharge Your Workflow

Google Apps Script is a powerful tool that helps you automate and extend Google Workspace apps like Sheets, Docs, Gmail, and Drive. Whether you’re a beginner or a seasoned scripter, these tips will help you write cleaner, faster, and more reliable code. ✅ 1. Use getActive() Sparingly While SpreadsheetApp.getActiveSpreadsheet() and DocumentApp.getActiveDocument() are convenient, they rely … Read more

Fixing the Empty First Row When Creating a New Sheet in Google Apps Script

When using Google Apps Script to copy data from one sheet to a log sheet, a common issue arises: the new sheet ends up with an empty first row. This typically happens when the data insertion starts from getLastRow() + 1, even when the sheet is brand new and completely empty. Here’s how we fix … Read more