Bootstrapping Tools

Cache JSON with a TTL

Hitting the same API or expensive sheet scan every trigger run burns quota. CacheService gives you a short-lived store (max ~6 hours…

Script Properties are great for small config blobs — tokens, last-run watermarks, feature flags. These helpers wrap JSON.stringify / JSON…

This code snippet helps you convert an object into a flat array that you can use to import into a Google Sheet. Important Note: This snippet…

This code snippet helps you convert an array of objects into a flat array that you can use to import into a Google Sheet. This is pretty…

This how-to guide will cover making a POST request to an API using JSON data. For retrieving JSON data from an API and parsing it out, check…

This is a basic REST API call that parses out JSON data and returns it back to you. To do a POST request using JSON data, check out the…