Get Daily Rate
Invoices in EUR, reports in USD. getDailyRate(from, to, date) returns the exchange rate for a given day, or the latest one if you leave out…
Get Daily Rate
Invoices in EUR, reports in USD. getDailyRate(from, to, date) returns the exchange rate for a given day, or the latest one if you leave out…
Geocode Cached
Geocoding a column of addresses one row at a time burns quota and time, and the same office address shows up forty times. geocodeCached…
Debounce onEdit so your sheet automation doesn’t thrash
Paste twenty status cells and watch your onEdit fan out twenty UrlFetch calls, twenty labeling passes, or twenty “send Slack” attempts. The…
Stay under someone else’s API rate limit
Third-party APIs rarely care that your nightly trigger "usually" fits. When five client files share one key — or one file fans out 200 GETs…
Hash String SHA-256
Cache keys and dedupe fingerprints should not log raw emails or IDs. hashStringSha256(text) runs Utilities.computeDigest(SHA_256, …, UTF_…
Debounce Or Skip
onEdit fires for every cell change — paste 40 rows and your automation thrashes. debounceOrSkip uses CacheService as a quiet window: if a…