Welcome! Just sharing some stuff I build with Apps Script, tips, tutorials, and whatever else I find useful
Copy-pasting big datasets manually into Google Sheets can quickly turn into a nightmare: slowdowns, crashes, weird formatting issues… you name it.
But guess what? With a little bit of Google Apps Script magic, you can automate the entire process, safely and efficiently.
In this guide, I’ll show you how to push large amounts of data into your sheet like a pro, without risking a browser meltdown.
(And don’t worry, I’ll keep it simple and copy-paste ready.)
Ever wished you could get an instant email when someone submits your Google Form complete with their answers and any files they uploaded? With a few lines of Apps Script, you can!
Let’s break it down
Why Use This Script?
This solution answers a common need: getting notified via email when someone submits a form response. Especially useful when:
In Google Apps Script, execution time matters. With quotas on simultaneous runs and total runtime, long or inconsistent function execution can cause failures or delays. This is especially important when using services like LockService, where you need to define realistic wait times.
This article shows how to track execution time and errors in your functions—helping you stay within limits and optimize performance as your scripts grow.
The Apps Script debugger lets you pause your code at any point and step through it line-by-line to see what’s really happening. You can inspect variables, monitor execution flow, and identify exactly where your script is misbehaving.
One of the most underrated (but powerful) features of Google Apps Script is its autocompletion system. Once you get used to it, you’ll barely need to open the official documentation ever again!
Apps Script is built on top of JavaScript, but its real strength comes from how it exposes Google services through method chaining. Whenever you type a dot (.) after an object—like SpreadsheetApp.getActiveSpreadsheet().—you instantly see a list of methods available to you. This isn’t just convenient; it’s essential for writing code quickly and confidently.
📌 Open the Command Palette with:
If you’ve been coding in Google Apps Script for a while, chances are you’ve clicked through menus or memorized toolbar icons to run functions, rename variables, or jump between files. But did you know there’s a faster, cleaner, and more efficient way to navigate the entire editor?
Say hello to the Command Palette, the productivity secret weapon borrowed from popular IDEs like VS Code, also available in the Apps Script editor. With just a simple keyboard shortcut, you unlock a searchable menu that puts hundreds of commands right at your fingertips.
We all know Apps Script is great for automating Google Workspace, but did you know the Script Editor itself is packed with subtle features that can seriously level up your scripting workflow?
Let’s dive into the lesser-known tools, panels, and tricks that make the Apps Script IDE more than just “a place to type code.”
Open it via the gear icon ⚙️ on the left sidebar. It’s small, but it hides some very useful toggles and project information: