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
-
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.
-
Nitrux 6.0 Now Ready to Rock Your World
The latest iteration of the Debian-based distribution includes all kinds of newness.
-
Linux Foundation Reports that Open Source Delivers Better ROI
In a report that may surprise no one in the Linux community, the Linux Foundation found that businesses are finding a 5X return on investment with open source software.