lidia.calicia@gmail.com – Page 2

Automatically Email Google Form Submissions (Including File Uploads)

Posted on August 5, 2025by lidia.calicia@gmail.com

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:

You’re collecting job applications or portfolios.
You want to automate intake notifications.
Your form includes file uploads, and you want the file attached in the email.

Access Apps Script from your Google Forms
Insert the snippet
OnFormSubmit(e) trigger

Log Function Performance in Google Apps Script

Posted on August 5, 2025by lidia.calicia@gmail.com

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.

Build a Simple Performance Tracker
Choose Where to Store Your Metrics
Apply Tracking to Your Existing Functions

Debugging in Apps Script

Posted on August 3, 2025by lidia.calicia@gmail.com

What is the Debugger?

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.

Autocompletion in Google Apps Script

Posted on August 3, 2025by lidia.calicia@gmail.com

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.

Command Your Code

Posted on August 3, 2025by lidia.calicia@gmail.com

📌 Open the Command Palette with:

Mac: Cmd + Shift + P
Windows/Linux: Ctrl + Shift + P

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.

Editor & IDE Secrets

Posted on August 3, 2025by lidia.calicia@gmail.com

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.”

1. Project Settings Panel

Open it via the gear icon ⚙️ on the left sidebar. It’s small, but it hides some very useful toggles and project information:

Enable Chrome V8 runtime – Ensures you’re using the latest JavaScript engine (a must for modern features like let, const, arrow functions, Array.prototype.flat(), etc.).
Log uncaught exceptions to Cloud logs – Helps with error tracking, especially in production or when debugging failures over time.
Show appsscript.json manifest file in editor – Turn this on to view and edit your project’s configuration (add scopes, define libraries, change add-on settings, etc.).
IDs section – See your Script ID and your Google Cloud Project ID, both useful when linking APIs, deployments, or enabling advanced services.