Working with Google Sheets and Apps Script

, Software Pundits
This post was originally published on this site

Toptal

Spreadsheets are one of the most common tools of the current business world. There are multiple implementations of spreadsheet software, with some differences among them all, but no matter which one is being used, for those whose work depends on them, they are absolutely indispensable.

“Spreadsheets: Easy to learn, hard to master”

It’s easy to start working with a spreadsheet, but it also takes time to master your skills to use all the powerful features it provides. When you start feeling comfortable with formulas, functions, pivot tables, etc., there is still one more level which allows you to achieve even more—custom extensions. Different products provide different interfaces for creating extensions. In this article, I’m going to focus on Google Spreadsheets, which provides a friendly interface to interact with the document called Google Apps Script. It’s written in a subset of JavaScript and allows integrations with other Google apps and services.

To read the full article click on the 'post' link at the top.