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
-
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.
-
System76 Retools Thelio Desktop
The new Thelio Mira has landed with improved performance, repairability, and front-facing ports alongside a high-quality tempered glass facade.
-
Some Linux Distros Skirt Age Verification Laws
After California introduced an age verification law recently, open source operating system developers have had to get creative with how they deal with it.
-
UN Creates Open Source Portal
In a quest to strengthen open source collaboration, the United Nations Office of Information and Communications Technology has created a new portal.
-
Latest Linux Kernel RC Contains Changes Galore
Linux kernel 7.0-rc3 includes more changes than have been made in a single release in recent history.