How One Shared Sheet Link Leaks Company Data
How one shared Google Sheet link can leak company data through permissions, copies, and forgotten access.
All tags Tags
#Sheets
7 posts
Spreadsheet Inventory Numbers Do Not Match for a Reason
Why spreadsheet inventory numbers drift, from missing stock logs to concurrent edits, cancellations, and returns.
The Permission Trap in Spreadsheet Approval Systems
The permission, approval-history, and audit-log risks that appear when a spreadsheet becomes an approval workflow.
Sheets Turns Your Text Into a Date: When '2026-06' Blocks Completion Forever
Google Sheets silently coerces strings like '2026-06' into a Date. When save, read, and compare each compute the month differently, completion is rejected forever. What gets coerced, how to pin cells to text and guard on read, plus batch writes and formula injection.
An App Where Many Write to One Sheet: Concurrency, Duplicates, and Export Design
The places I actually got stuck building the CheckReport Demo, with the code. Concurrent saves to a shared sheet are blocked with ScriptLock + an idempotency key, cells hold only metadata, and exports are cut off with a time budget. Good code and bad code, side by side.
Don't Read Cells One at a Time: Service Calls Are the Real Cost
In GAS the slow part isn't JavaScript, it's service calls to Sheets and Drive. Swap in-loop getValue/setValue for batched getValues/setValues and it's tens of times faster.
Stuffing JSON or Images into a Sheet Cell Will Break It
A Google Sheets cell caps at 50,000 characters. Put a photo or signature in a record row as a data URL and the save breaks. Keep only metadata in the cell.