Custom functions that don’t thrash your sheetCustom functions look like spreadsheet superpowers until one volatile formula starts refetching an API on every edit. Use them for pure…
Cache JSON with a TTLHitting the same API or expensive sheet scan every trigger run burns quota. CacheService gives you a short-lived store (max ~6 hours…
