Named Values To Object
Form submit events hand you e.namedValues: each question maps to an array of strings, even for a single answer. namedValuesToObject…
Named Values To Object
Form submit events hand you e.namedValues: each question maps to an array of strings, even for a single answer. namedValuesToObject…
Pick Columns
You've turned rows into objects, and now you only need four of the twenty fields, in a set order, for an export, an email, or another tab…
Get the Active Row as an Object
Menu actions and sidebar handoffs usually care about the row you're on, not the whole grid. getActiveRowAsObject reads the header row plus…
Upsert a Row by Key Column
Find a row by a key column (email, order ID, SKU) and update it — or append if it's new. Header-aware, so you pass a plain object instead of…
Append an Object as a Sheet Row
When your data is already a plain object (API payload, form values), aligning it to row-1 headers beats hand-building arrays. Missing keys…
rowsToObjects and objectsToRows
Sheet data is easiest as a 2D array. Business logic is easier as objects keyed by header. These two helpers convert back and forth without…