January, 2022


Year in review: the Google Workspace Platform 2021

2021 was a big year for Platform milestones. Google Workspace grew to more than 3 billion users globally, we reached more than 5,300 public apps in the Google Workspace Marketplace, and we crossed over 4.8 billion apps installed (up from 1 billion in 2020)! We were also busy bringing Platform innovations and improving our developer experience to help building for Google Workspace easier and faster. Here’s a look at some of the key enhancements the Google Workspace Platform brought to the developer community.



Developer News


How to build a facility inspections tracker with AppSheet

Our AppSheet video series spotlights app ideas and Google Workspace integrations for common use cases, like inventory management, visitor check-in, & more. In this latest example, building a custom facility inspections app to track audits and automate reporting is quick and easy with AppSheet, Google’s no-code development platform. 



Tune in


Build a Google Workspace Add-on with Node.js and Cloud Run

Google Workspace Add-ons are customized applications that integrate with Google Workspace applications such as Gmail, Docs, Sheets, and Slides. They enable developers to create customized user interfaces that are directly integrated into Google Workspace. In this lab, you'll learn how to build and deploy a simple task list add-on using Node.js, Cloud Run, and Datastore.


Learn more



Community Spotlight



Merging sheets from multiple sources and encrypting selected columns

This community post comes from Desktop Liberation by @brucemcpherson. Learn how to only make certain columns visible to people with the correct credentials, but not go to the trouble of creating different versions of the summary sheet for different groups. 



Publishing a Google Workspace Add-on to the Marketplace

In this episode of Totally Unscripted, Elena Kingbo, Program Manager on the Google Workspace Platform Team, describes the Google Workspace Add-on publication process with advice and tips on getting your add-on verified.




Meet Martin Hawksey, Google Cloud Champion Innovator, Google Workspace @mhawksey

Martin is based out of Scotland, UK and produces the Totally Unscripted show and manages the Apps Script Pulse blog. In this video, Martin speaks to why Google Apps Script is a great tool for exploring new ideas for well-seasoned and novice programmers alike. 




Solutions Spotlight


Swit

Swit provides seamless workflows coupling chat and tasks in one convenient place. A powerful alternative for a heavy collection of single-function tools.




Folgo for Google Drive

Copy an entire folder structure, transfer ownership of subfolders and files, list your Google Drive files in a Google Sheets, and import all your metadata in a Data Studio report.