Get the Active Row as an ObjectMenu 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 ColumnFind 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 RowWhen 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 objectsToRowsSheet data is easiest as a 2D array. Business logic is easier as objects keyed by header. These two helpers convert back and forth without…
