Featured

If You Use Clasp With Google Apps Script, You Need This Utility Right Now

When working in a team and/or with a client, you want to have multiple environments. At minimum, you probably want a dev environment (or multiple ones) in which you are working, and a test environment in which the client or your team can run acceptance tests before production. Of course, they must both be separate from the production environment. To push your code to the correct environment, you need to either update the .clasp.json file manually or keep multiple copies of your script with different .clasp.json files.

Fortunately, things have just become significantly easier, as I recently built an app for this purpose called clasp-env, which is available on NPM.

Read

Latest

                          
How I Programmed the Game of Life in a Google Sheet with Google Apps ScriptAccording to Wikipedia, the Game of Life “is a cellular automaton devised by the British mathematician John Horton Conway in 1970.”
Read

How to Build an API Wrapper in Google Apps ScriptEvery 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.
Read

The ULTIMATE Guide to NPM Modules in Google Apps ScriptOne thing that Google Apps Script is missing is modules. Of course, in Apps Script we have libraries, but the selection is extremely limited and there is no marketplace for those. But what if I told you that there actually is a way to use some NPM modules in Apps Script?
Read

How to Write Google Apps Script Code Locally in VS Code and Deploy It With claspYou get all the functionality of the online IDE and much more more: autocomplete, custom themes, installation of modules, linting, snippets, etc.
Read

How to Use Service Accounts and OAuth2 in Google Apps ScriptIn 99% of all cases, authorizations in Google Apps Script are extremely straightforward. When a user executes their script, they run it as themselves with their respective authorization scopes. However, what if you need to give more rights to your app beyond what your intended users will have?
Read

How to Build Custom Functions in Google Sheets with Google Apps ScriptIf you use any kind of spreadsheet, you know that they contain built-in functions that help you work with your data. For example, the function SUM(A1:A5) will print the sum of the values in the first five rows of the first column. But what if you need a function that your spreadsheet doesn’t have? That’s where the custom functions come in: in Google Sheets you can write your own ones with Google Apps Script.
Read

Bypassing the Maximum Script Runtime in Google Apps ScriptGoogle Apps Script is an amazing language that can automate a lot of your work. However, working with GAS also means that you have to learn to live with its built-in limitations and quotas. One such quota is the total script runtime. It’s limited to six minutes on free accounts and thirty minutes on corporate accounts.
Read

Tracking Google Sheet Opens with Google Apps ScriptThe basic principle behind tracking Google Sheet opens is the same as the one behind email tracking with a transparent pixel. In a Google Sheet, we will use the IMAGE()function, which will call a deployed Google Apps Script web app URL with some parameters in the query string.
Read

Taking Away the Pain From Unit Testing in Google Apps ScriptThere are numerous libraries that exist for unit testing in JavaScript, including Jest and Mocha; however, they aren’t necessarily well-adapted to run under the Google Apps Script environment. A few solutions do exist for GAS, but they’re nothing crazy either.
Read

Using Design Patterns in Google Apps ScriptA lot of users try and quickly learn GAS and use it to make their lives easier. It’s all great, however the code we sometimes tend to come across on StackOverflow and other sites lacks best practices, hence I thought it was time to start bringing them up and I will start today with design patterns.
Read

Schedule a meeting