Google Workspace Admins is an IT admin driven series of live and pre-recorded technical talks covering any and all topics that a Google Workspace Admin would find useful. We’ll cover topics that would benefit the Tier 1 IT help desk admin on up to the super admin and the CIO. Signup to get invited to all future events.
I’ve been a Google Workspace Admin for over a decade, mostly working on small domains. More recently my role requires me to support larger domains, often with enhanced security needs and the requirement to generally do everything on a bigger scale. This is where tools like GAM and Google Apps Script become essential to help with the heavy lifting.
Broadening the range of Google Workspace domains I support has also required me to broaden the channels and communities where I can learn and keep up-to-date. Recently, I was pointed to the Google Workspace Admins YouTube channel. Whilst this channel is relatively new it’s bursting with a wide range of technical focused solutions and discussions. Follow the link to subscribe to the channel and there is a form to get invited to all future events.
Welcome to the Google Workspace Developers YouTube Channel, where developers of all types can learn about building solutions with Google Workspace. Explore the full range of the Google Workspace Platform from Apps Script to Chat Apps to Workspace APIs and more. Leverage Google Workspace’s products such as Gmail, Docs, Sheets, Slides, Drive, and many more to customize, integrate, or extend these products with our developer tools. Visit our website → developers.google.com/workspace
Google has just launched a new YouTube channel dedicated to Google Workspace developers. Google Apps Script community members might recognise the first featured video series on the ‘Anatomy of Google Chat apps’, which is presented by Chanel Greco who recently joined the Google Workspace Developer Relations team. As well as featuring a curated collection of previous Google content on topics from no to low code solutions the channel also includes content from the wider community.
Forms History is a Google Workspace Add-on that allows you to monitor your version history and store copies in Google Forms
Not just talking the talk, but also walking the walk. Shortly before taking a new role at CTS, the largest dedicated Google Cloud Partner in Europe, I published Forms History an add-on to enable revision history functionality in Google Forms.
Fellow Google Developers Expert, Scott Donald, has picked this up in the latest episode of GWAOw! his dedicated to Google Workspace Add-on review show. You can follow the source link for the YouTube clip and more. As part of the episode Scott rightly highlights the creative work of Alice Keeler, which hasn’t just included artwork but Alice has also provided a huge amount of support in promo and usability.
Crop Google Sheet Data to the data range or a selection in 2 button click with Crop Sheet. Full Walkthrough
Does this Google Workspace Add-on developer story sound familiar? You are able quickly write the code that executes your add-on functionality, but then you spend days buried in HTML or Card Service making the UI. The Crop Sheet add-on by Eric Koleda highlighted in this latest GWAOw! episode is a great example of what is possible just by using custom menus. For what it is worth the source code (all 73 lines including comments!!!) is on GitHub. Follow the source link for the video demo from Scott Donald and links including the GitHub repo.
In this video you will learn how to access an API with Google Apps Script.
Chanel Greco has created this video tutorial which walks through some different ways you can interact with other sites with Google Apps Script to get data into Google Sheets. For the tutorial Chanel uses the Weather API and by coincidence Luxman Ravindrakumar has also shared a similar tutorial on Medium explaining how to use the OpenWeather API. So if you prefer learning by watching or reading you’ve no excuses :). Check the sources links below for both tutorials.
In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at ImportFromWeb by NoDataNoBusiness.
ImportFromWeb is a powerful web scraping tool for Google Sheets that allows you to grab data from any website. The creators call it IMPORTXML on steroids.
The latest episode from Scott Donald’s GWAOw! is now available. As explained by Scott ImportFromWeb is a Google Sheets add-on which allows users to use the custom function to import data from other websites into Google Sheets.
Even though this add-on is primarily used to add a custom function to Google Sheets the developers, NoDataNoBusiness, have taken the time to use the sidebar with some useful UI elements to help users get started.
GWAOw! is a YouTube series that explores the best Google Workspace Add Ons in the Google Marketplace to help you learn what is out there.
This new YouTube series from Scott Donald at yagisanatode.com will hopefully be a great way to see and learn how other developers have implemented Google Workspace Add-ons, picking up UI tips and tricks. For the first episode Scott takes a look at Workbook Statistics by Sourabh Choraria. Scott is planning one/two episodes a month and if you have published your own add-ons you can find out about getting it featured in GWAOw!.
With this reusable script you can create multiple labels in Gmail whenever you need to do so. All you have to do is create the script as shown in the video and then use it to create multiple Gmail labels in one go.
Continuing the Gmail label theme in this latest video tutorial from Chanel Greco you can learn how to batch create Gmail labels from data in a Google Sheet.
In this video you will see how you can use Google Apps Script to export a Google Sheets document as a PDF
It’s been a while since we featured a video tutorial from Chanel Greco, but that doesn’t mean she hasn’t been busy. In this recent tutorial from Chanel you can learn how to use Google Apps Script to export a Google Sheet as a PDF Document. You can watch this and other videos from Chanel on the saperis YouTube channel.
As part of our last episode of Totally Unscripted we spoke to former Google Workspace DevRel Eric Koleda about his new role supporting the Coda community.
Coda provides word-processing, spreadsheet, and database functions. It’s a canvas that blends spreadsheets, presentations, apps, and documents together. The software can integrate with third-party services like Slack and Gmail.
Eric gave a fantastic overview of the Coda platform highlighting opportunities for developers to integrate with services like Google Apps Script via the Coda REST API and the new Coda Packs, which are currently in beta.
The clip is an excerpt from the full show where we get to see these features in action and some additional resources referenced are linked below: