Do you like Google Apps Script(GAS)? Me too! 👍
I’ve written a lot of GASs to run system processes and maintain data. Most of them are run b

GAS-Terminal: Environment for smart execution of Google Apps Script

submited by

Style Pass

2021-07-07 23:30:05

Do you like Google Apps Script(GAS)? Me too! 👍 I’ve written a lot of GASs to run system processes and maintain data. Most of them are run by various triggers automatically, but sometimes I need to run some scripts by hand. Then I’ll be reminded that “Running GAS is a pain!” Why? Because there is no smart way to run it and check the results.😓

This may be the most familiar method. You write some code, and click the Run button. That’s all. But it’s a pain to open the Script Editor every time, and you should change the code when you want to change the function’s parameter.

Another way is to place buttons on your spreadsheet and associate your functions with those buttons. This article explains how to do it. This method is a little easier than opening the Script Editor to execute functions. However, as the number of functions increases, the number of buttons also increases, and it tends to get harder to organize. Also, there is still the problem of not being able to change function parameters. Moreover, if you want to know the result of the script execution, you still have to open the Script Editor, unless you have implemented output to a sheet.

So I created a tool to make it easier to manage and run GASs. Its name is GAS-Terminal (The name Terminal is because you can switch between various commands (i.e. functions) as if you were in Terminal.) This tool is implemented in Google Sheets, which allows you to execute functions in scripts associated with this sheet.