Tag: google apps script
-
How to use Google Apps Script to get data from a connected data sheet
Regular sheets are straightforward For a regular Google Sheets spreadsheet, it’s fairly easy to use Google Apps Script to get the data contained on a worksheet: var spreadsheet = SpreadsheetApp.getActive(); var regularsheet = spreadsheet.getSheets()[0]; var range = regularsheet.getDataRange(); var values = range.getValues(); for ( j = 0; j < values.length; j++ ){ Logger.log(values[j][0] + ':…
-
Changing ownership of files in Google Drive via Google Apps Script
This was a fun little exercise in Google Apps Script to essentially transfer ownership of Google Drive files from one user to another. Here’s a script that the old user should run to change ownership of those files to the new user: ChangeFileFolderOwnership.js And here’s a script that the new user user should run to…
-
Students unsubscribing from mailing lists within Google Apps for Education
GAM solution Apparently, there is a GAM solution to this, which is gam update group nameofgroup who_can_leave_group ALL_MANAGERS_CAN_LEAVE I did a quick test, and it appears to work. Users will still see the option to “unsubscribe,” but after they do, they’ll still be subscribed anyway. Thanks to Zack McCauley for the tip. What’s the problem?…