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
Digital Autonomy
• The Answer Was Already on the Shelf
• Changing the Chip Industry: How Public Investment Has Grown Open Silicon
• United Nations Open Source Portal Goes Live
• EU Open Source Strategy Plays Key Role in Tech Sovereignty Package
• France Says “Au Revoir” to Microsoft
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
-
Linux May Soon Work on Snapdragon X2-Based PCs
If you're thinking about buying a Snapdragon X2-based desktop or laptop, Linux may soon be an option.
-
KDE for People Initiative Calls for AI Ban in Plasma
A new community of KDE wants the project to adopt a strict no-AI policy for KDE Plasma.
-
KDE Sets Ambitious Goals for 2026 and Beyond
KDE Connect reveals the goals for the Linux desktop darling, with one of those goals long overdue.
-
It’s Time to Test Fedora 45 Beta
Fedora 45 beta has been released with updated Gnome, KDE Plasma, and kernel.
-
Ubuntu Stonking Stingray Gets Even Rustier
Ubuntu 26.10 has completed its migration to the Rust-based coreutils.
-
AI Fixes Linux Bottlenecks Using “Hideous” Code
A Linux developer used AI to fix bottlenecks that caused problems when building the kernel. The resulting AI-generated code needed a lot of work.
-
Advanced Video Coding Still Under Patent
Brazilian patent BRPI0109962B1 has expired, which means that DivX and Xvid are no longer problematic for Linux, but it doesn’t mean that video is all of a sudden fully unleashed.
-
2,000 Vulnerabilities per Linux Release
Thanks to AI bug hunters, the Linux kernel is seeing record numbers of vulnerabilities, and it's overwhelming developers.
-
Linux Exempt from California’s Age Verification Law
So long as Linux is distributed under the GPL, MIT, BSD, and Apache licenses, the OS is exempt from being required to verify the age of its users in California.
-
Roll Out the Cake: Linux Turns 35
35 years ago, a Finnish student began a humble project that would forever change the course of technology.