Google Sheets Automation with Macros Flashcards

What is a key limitation of the macro recorder compared to writing Apps Script manually?

Answer: It cannot capture conditional logic or custom functions

The recorder captures literal actions but not logic like if-statements or custom functions.

Google Apps Script execution is subject to which type of constraint?

Answer: Daily quotas and maximum runtime limits

Apps Script enforces quotas and per-execution runtime limits.

To show a custom menu of macros to users, an onOpen() function typically uses:

Answer: SpreadsheetApp.getUi().createMenu()

getUi().createMenu() builds a custom menu shown when the sheet opens.

Which best describes an 'installable trigger' versus a 'simple trigger'?

Answer: Installable triggers can access services requiring authorization and run on schedules

Installable triggers support authorization-dependent services and time-based scheduling that simple triggers cannot.

If two macros are assigned the same keyboard shortcut, Google Sheets will:

Answer: Prevent the duplicate and require a different shortcut

Sheets does not allow two macros to share the same shortcut and prompts for a unique one.

A good practice when a macro must process thousands of cells is to:

Answer: Minimize calls to the Sheets service by batching reads and writes

Batching reads and writes reduces slow service calls and speeds execution.

Where is a spreadsheet's macro/Apps Script code physically stored?

Answer: In a bound Apps Script project attached to that spreadsheet

Recorded macros live in an Apps Script project bound to the spreadsheet.