Cloud scripting with Google Apps Script
Staying On Script
© Olga Yastremska, 123rf.com
Spreadsheet scripting with Google Apps Script is made possible by server-side JavaScript.
Most people are familiar with spreadsheets because most people use them for some purpose. Google, among others, brought spreadsheets to the browser with Google Docs, which took them up a notch in terms of utility, ubiquity, and sharing. With a new service called Google Apps Script (GS), you can do even more interesting and useful things with your spreadsheets.
In this article, I'll take a look at how you can take a "master" list, such as a list of company employees, and break it down into consumable sublists, such as a list of employees by office location. Next, I'll take that data and publish it to a series of web pages in Google Sites. Because access to data often is dependent on role or authority, I will also touch on permissioning. This same recipe could be useful in a thousand scenarios, such as providing football team rosters from a master list of all the players in the league.
Google Apps Script is basically JavaScript run on the server (see "Déjà Vu All Over Again"). Google provides a complete development environment in the browser and does all the code versioning and hosting for you. Google also provides a library of functionality, with APIs for other Google services, from email to documents to sites. For this tutorial, I'll assume you have a Google account and some familiarity with JavaScript. If you're a total beginner, see the GS tutorial [3].
[...]
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Framework Laptop 13 Pro Competes with the Best
Framework has released what might be considered the MacBook of Linux devices.
-
The Latest CachyOS Features Supercharged Kernel
The latest release of CachyOS brings with it an enhanced version of the latest Linux kernel.
-
Kernel 7.0 Is a Bit More Rusty
Linux kernel 7.0 has been released for general availability, with Rust finally getting its due.
-
France Says "Au Revoir" to Microsoft
In a move that should surprise no one, France announced plans to reduce its reliance on US technology, and Microsoft Windows is the first to get the boot.
-
CIQ Releases Compatibility Catalog for Rocky Linux
The company behind Rocky Linux is making an open catalog available to developers, hobbyists, and other contributors, so they can verify and publish compatibility with the CIQ lineup.
-
KDE Gets Some Resuscitation
KDE is bringing back two themes that vanished a few years ago, putting a bit more air under its wings.
-
Ubuntu 26.04 Beta Arrives with Some Surprises
Ubuntu 26.04 is almost here, but the beta version has been released, and it might surprise some people.
-
Ubuntu MATE Dev Leaving After 12 years
Martin Wimpress, the maintainer of Ubuntu MATE, is now searching for his successor. Are you the next in line?
-
Kali Linux Waxes Nostalgic with BackTrack Mode
For those who've used Kali Linux since its inception, the changes with the new release are sure to put a smile on your face.
-
Gnome 50 Smooths Out NVIDIA GPU Issues
Gamers rejoice, your favorite pastime just got better with Gnome 50 and NVIDIA GPUs.