-
Deleting accidental or dangerous emails in Google Workspace
As Google Workspace admins, sometimes, we are asked to delete emails from other users accounts when the messages are sent in error or contain malware/phishing/etc. This is not something we do lightly and should only be done in the most extreme cases. If the message went outside your Google Workspace domain, there is almost nothing…
-
My process to programming with Blackbaud Sky API (and really any API)
In preparing for the panel session “APIs and the Art of the Possible” for the 2024 ATLIS Conference, I spent some time thinking about my process for developing solutions using APIs. I have recently been working on something to send gift acknowledgment letters via Google based on data in Blackbaud Raiser’s Edge and thought it…
-
Using Google Apps Scripts to distribute files to users
While it is easiest to use Google Classroom or your LMS to distribute files to users, sometimes I need to handle it myself via Apps Script as part of a larger solution. The challenge: I have a folder full of PDFs that I generated for each student. I’d need to place these unique files in…
-
Moving Google Drive Docs/Sheets/Forms between workspaces/organizations
Recently, I needed to move a complicated Google Form and an associated Google Sheet that stored the responses to another account. Within an organization, this is pretty easy to do, but moving between workspaces doesn’t appear possible. There is a workaround by using a Google Shared Drive in the target account and adding the source…
-
Onboarding new users with GAM with an assist from CloudHQ
When someone is hired at my school, our HR system sends tech support an automated message with some basic information (first name, last name, start date, personal email address, job title, supervisor, etc.). Unfortunately, this isn’t formatted the best and I used to copy/paste the information from this email into an onboarding Google Sheet I…
-
GAM, Google Sheets & Calendars
While web interfaces make things easier, it is often much faster to do things on the command line, especially if you are trying to make changes in bulk. My school recently added Google Calendars for all our sports teams. One trick to make this easier is to use Google Sheets (or Excel) to convert spreadsheet…