API Specific
Convert any file with Apps Script
Apps Script library to convert between file types, including OCR for image to documents, with a huge repertoire of conversion combinations. […]
superfetch
Caching, property stores and pre-caching
I’ve written many times about various Apps Script caching techniques such as how to deal with size limits and use different back ends for more persistent caching. In this article, I’ll bring together a few […]
State management across CardService, HtmlService and Server side Add-ons
Motivation I’ve been working on a CardService Add-on lately which also uses HtmlService, and also runs quite a few things Server side. All of these modes need to share state, and it always ends up […]
Apps Script
SuperFetch Plugin: Cloud Manager Secrets and Apps Script
Smg is a SuperFetch plugin to access the Google Cloud Secrets API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it […]
Apps Script
SuperFetch caching: How does it work?
SuperFetch is a proxy for UrlFetchApp with additional features such as built-in caching – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works and what it does. This is another […]
Apps Script
SuperFetch plugins: Tank events and appending
Tank and Drv are SuperFetch plugins to emulate streaming and use the Drive REST API with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps […]
Apps Script
SuperFetch Plugins: Apps Script streaming with Tank and Drive
Tank and Drv are SuperFetch plugins to emulate streaming and use the Drive REST API with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to […]
Apps Script
SuperFetch Tank Plugin: Streaming for Apps Script
Tank is a SuperFetch plugin to emulate streaming with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works […]
API Specific
SuperFetch plugin – Google Drive client for Apps Script – Part 1
Drv is a SuperFetch plugin to access the Google Drive API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works […]
API Specific
SuperFetch – Twitter plugin for Apps Script – Get Follows, Mutes and blocks
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Apps Script
SuperFetch plugin – Twitter client for Apps Script – Counts
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Apps Script
OAuth2 and Twitter API – App only flow for Apps Script
I covered how to handle the somewhat more complex OAUTH2 authorization flow for the Twitter v2 API (OAuth 2.0 Authorization Code Flow with PKCE) using my Goa library in this article. The purpose of that […]
Apps Script
SuperFetch plugin – Twitter client for Apps Script – Search and Get
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Apps Script & Java Script
Apps Script Oauth2 library Goa: tips, tricks and hacks
Motivation Goa is a library to support OAuth2 for Apps Script connecting to a variety of services, using a variety of Authentication flows and processes. There are plenty of other articles on Goa on this […]
Add-ons
Apps Script Oauth2 – a Goa Library refresher
It’s been a few years since I first created the Goa library. Initially it was mainly to provide OAuth2 authorization and authentication to be able to access Google APIS and services unavailable via App Script. […]
Apps Script
SuperFetch plugin – Firebase client for Apps Script
Frb is a SuperFetch plugin to easily access a Firebase Real time database. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it […]
Apps Script
SuperFetch plugin – iam – how to authenticate to Cloud Run from Apps Script
SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works and what it does. In this article I’ll cover how to use […]
Apps Script
SuperFetch – a proxy enhancement to Apps Script UrlFetch
I’ve written a few articles about JavaScript proxying on here, and I’m a big fan. I also use a lot of APIS, and it can be time consuming to keep on checking the REST documentation […]
Apps Script & Java Script
Apps script caching with compression and enhanced size limitations
Motivation Caching is a great way to improve performance, avoid rate limit problems and even save money if you are accessing a paid for API from Apps Script. A big limitation though is that cache […]
Apps Script & Java Script
Simple but powerful Apps Script Unit Test library
Why unit testing? There are many test packages for Node (my favorite is ava) and there are also a few for Apps Script but I couldn’t find one that was exactly what I was after, […]