{"id":190,"date":"2022-04-11T20:41:51","date_gmt":"2022-04-11T20:41:51","guid":{"rendered":"http:\/\/duff.io\/?p=190"},"modified":"2022-04-11T20:41:51","modified_gmt":"2022-04-11T20:41:51","slug":"gam-google-sheets-calendars","status":"publish","type":"post","link":"https:\/\/duff.io\/?p=190","title":{"rendered":"GAM, Google Sheets & Calendars"},"content":{"rendered":"\n

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. <\/p>\n\n\n\n

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 data into commands I can paste into the terminal window of my Mac.\u00a0<\/p>\n\n\n\n

I use GAM-ADV-XTD3<\/a> (a more advanced version of GAM) that uses the Google Admin APIs<\/a> to mange my Google Workspace environment from the command line.<\/p>\n\n\n\n

In GAM-ADV-XTD3 you can create a calendar in a user account like so:<\/p>\n\n\n\n

gam user athletics-calendars<\/mark><\/strong> create calendar summary \"Sailing - Varsity<\/mark><\/strong>\"<\/pre>\n\n\n\n
In the example athletics-calendars<\/code><\/mark><\/strong> is the username of account I wish to create the account in and Sailing - Varsity<\/code><\/mark><\/strong> is the calendar name. <\/p>\n\n\n\n
If I have a Google sheet with a list of sports I need to create a calendars for, I can simply write a formula (like the one below) to generate the commands to create all those calendars. <\/p>\n\n\n\n
=\" gam user athletics-calendars create calendar summary \"\"\" & A1<\/mark><\/strong> &\"\"\"\"<\/pre>\n\n\n\n
This combines the text of the command with the contents of the cell A1<\/code><\/mark><\/strong> (which is where the sports team’s name is). To quote a quote is a little tricky but the formula above works. I then fill down for all the sports teams and now I have the commands to create all of the calendars. I can highlight all of the cells with these commands (B1:B17<\/code> in the example below) and paste them into terminal to run them.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
After a few seconds I now have 17 calendars created!<\/p>\n\n\n\n
Some other handy e GAM-ADV-XTD3<\/a> calendar related commands: <\/p>\n\n\n\n
Give a user access\/permission to a calendar:<\/h4>\n\n\n\n
gam calendar xyzzyasfda@group.calendar.google.com<\/mark><\/strong> add acls writer<\/mark><\/strong> user@exampledomain.com<\/mark><\/strong><\/pre>\n\n\n\n
xyzzyasfda@group.calendar.google.com<\/code><\/mark><\/strong> is the Calendar ID that you want to give access to user@exampledomain.com<\/code><\/mark><\/strong>. While writer<\/code><\/mark><\/strong> allows someone to edit a calendar, you need to assign owner<\/code><\/strong> in order for them to change sharing settings.<\/p>\n\n\n\n
Make a calendar public:<\/h4>\n\n\n\n
gam calendar xyzzyasfda@group.calendar.google.com<\/mark><\/strong> add acls reader<\/mark><\/strong> default<\/mark><\/strong><\/pre>\n\n\n\n
If you want to make a calendar public (so that anyone on the can access it) you use default<\/code><\/mark><\/strong> as the username. Using reader<\/code><\/mark><\/strong> provides read-only access.<\/p>\n\n\n\n
List all of the calendar in a users account:<\/h4>\n\n\n\n
gam user sample_user<\/mark><\/strong> print calendars showhidden todrive<\/mark><\/strong><\/pre>\n\n\n\n
This lists all of the calendars in sample_user<\/mark><\/strong>'s<\/code> account in a new Google Sheet (todrive<\/code><\/mark><\/strong>). This can be handy to find the Calendar ID of a specific calendar.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,21],"tags":[],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-gam","category-google-workspace"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/duff.io\/index.php?rest_route=\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/duff.io\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/duff.io\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/duff.io\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/duff.io\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=190"}],"version-history":[{"count":4,"href":"https:\/\/duff.io\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions"}],"predecessor-version":[{"id":196,"href":"https:\/\/duff.io\/index.php?rest_route=\/wp\/v2\/posts\/190\/revisions\/196"}],"wp:attachment":[{"href":"https:\/\/duff.io\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/duff.io\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/duff.io\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}