Writing scripts is a boon for Google Workspace guys. You can add functionality to drive files that did not exist by default. Sending emails on a schedule (I wrote an article on it previously — https://www.linkedin.com/pulse/sending-emails-schedule-google-apps-script-akshit-baunthiyal/), sharing calendars out, changing user licenses, etc. are just some of the things you can do.

But where do you write this code? We are provided with a ‘platform’ for it. Simply going to script.google.com should sort us out.

The good thing about this is that we can write code online in the editor Google provides. This has recently been updated to give it…

Ever wondered how you would automate tasks in Google Workspace without using a tool developed by an external entity? Google has your back.

We have something called Apps Script that allows us to add functionality to drive files like sheets, forms, docs, etc.

In this article, we will see how one can send emails on a schedule. As an example, I have used an annual event. A birthday reminder script, if you will.

Let’s get into it. Here goes -

  • Open a new sheet
  • (Optional) Rename the first tab in the sheet. …

Recently, I came across an issue which I couldn’t figure the solution of. A user, even though was allowed to share data outside the domain, still could not add external users to a shared drive. Talking about Google Drive here.

Some things to note -

  • Data sharing outside the domain was limited to whitelisted domains over the root OU
  • The user had his permission to allow sharing stuff outside the domain through an access group (https://support.google.com/a/answer/9050643?hl=en). This group basically overrode the permission granted using the root OU settings.

The reason was simple enough although I couldn’t figure it out initially…

Akshit Baunthiyal

I'm a Google Workspace admin who sometimes dabbles in code.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store