In this blog post I will be showcasing the power and convenience of Google App Scripts. In my previous role, as a Digital Marketing Analyst almost every day I had a new problem to solve, whether that be sorting, cleaning, or transforming data. These tasks were often very repetitive and for lack of a better term; boring. Coming from a software development background, my first instinct was how can I automate this?
As most data handling is done in a Spreadsheet, this will be the focus of our tutorial. Create a new Google Sheet
Basic Data, as tax time has just past lets work out some GST (For those of you not in Australia, GST is a Goods and Services Tax on all products sold in Australia)
Creating our function, which has an input and return value. This function basically just adds 10% of the initial input product price to the product price and returns the new GST inclusive product price.
So there you have it, a basic introduction of how to create your own custom functions in Google App Scripts! While I didn’t go into much depth as to what you can automate, I still hope this has given you a rough idea of the possibilities that Google App Scripts provides.
If you have any comments or ideas for future tutorials, feel free to connect with me on LinkedIn!