API Wrappers Simplified with Google Apps Script — Your Ultimate Guide 🕸️

Dmitry Kostyuk
Geek Culture
Published in
8 min readMar 20, 2022

--

No Google Apps Script SDK for your favorite API? No problem!

What’s an API Wrapper? Why You Might Want to Build One

Every developer at some point needs to make use of an external service to extend their code. APIs are built with this purpose in mind; they allow us to communicate with other services and applications over HTTP in a standardized way. Another option is to use NPM modules, so check out my previous article about this issue. Under the hood, Google Apps script makes use of various Google APIs, such as the Google Sheets API or the Google Drive API.

In this article, we will examine three different real-world APIs: Trello, ClickSend, and BigQuery. For reference, ClickSend and BigQuery require a credit card.

If you look at the docs for the Trello API, you will notice that their documentation has SDKs for a number of languages, namely Node.js, Java, Python, and PHP, but not Google Apps Script.

There is never an SDK for Google Apps Script

In fact, I’ve never seen a Google Apps Script SDK made available, as, surprise surprise, it’s not the most popular choice…

--

--