fbpx

Automate Google Workspace License Management Workflow

Automate Google Workspace License Management Workflow

October 8, 20210 Commentzenphi Use Cases

Onboarding and offboarding staff is a very common process in organizations. That’s why those are amongst the most used use cases in process automation. However, there are still companies which have not fully automated their offboarding process or there are situations where the offboarding does not cover revoking licenses assigned to users.That means the company ends up paying for the license fees of the users who are no longer working with them.
This is especially common in organizations with a lot of employees or the ones which have quite a few temporary contractors, etc.

Luckily using Zenphi with just a few steps you can automatically identify inactive users in your Google Directory, and revoke their licenses.
Of course, you may want to get approval from the inactive user’s manager (or someone else in the organization) before revoking the license and/or deleting the user.
You can also define various conditions on when to consider a user inactive. It could be the last login date, their last activity on Google Drive, or simply by querying your HR system to see if the employee’s contract is still valid. They can be done easily with Zenphi.

 

For this demo, we have configured a flow which

  • Runs, on a schedule
  • Gets all active Google Workspace licenses in our account
  • Checks if any of the those licenses has not been active in the past 30 days
  • Compiles a list of inactive accounts into a Google Sheet
  • Sends the Google Sheet for approval to a designated person in the company
  • The person marks the ones which need to be deleted (or whose license needs to be revoked) in the Google Sheet and responds to the task
  • Automatically delete/revokes the licenses for the marked accounts

Now, Let’s have a look at the steps.

First, we have configured our flow to run every three months. You can configure it to run on a different schedule, or on demand.

Getting a List of Active Google Workspace Licenses

The first step is to get all the active licenses in our Google Directory.

Find Inactive Users Activities in Google Workspace

For this demo, an inactive user is a user who has not done any activities on Google Drive in the last 30 days. So, first calculate the date for the 30 days ago, and then loop through the licenses. For each license we use the List Activities to query the license user’s activities in the last 30 days. If the number of activities is greater than zero, we consider the user active. Otherwise we add the account to the Google Sheet.

Revoke Inactive Users Google Workspace Licenses

We then send the Google Sheet to be reviewed by a designated person. That person receives a task, and needs to open the Sheet and mark the ones which need to be revoked/deleted as Yes in the column D. Once finished, the person clicks on the Done button.

The Flow then queries the Sheet for the rows which are marked Yes in column D, and starts deleting/revoking the license.

You can also see a short demo video, demonstrating this flow.

Hopefully, this flow helps you put managing your Google Workspace licenses on auto pilot, saving a lot of time and money. You can get started with Zenphi for free and start automate your processes.


Related post

Start small and finish big; the key to successful process automation

General , How-To, , , , , , , ,

We assume that you accept that, thanks to process automation, your employees need less time, make fewer mistakes, and your organization performs better.  Now, where do you start, and how do you finish process automation successfully?  Start small and finish big!  The pitfall of a big and bold challenge! No doubt you have read that …

Read more
Resolve your Staff Shortages with No-Code Process Automation

General, , , , , ,

“Colleague Wanted” is a common refrain among employers today.  At the end of Q3 2021, there were 126 jobs for every 100 job seekers in the European Union! In other words, there is an apparent labour shortage in almost all business sectors.  While this may be good news for job seekers, it certainly creates problems.  …

Read more

Leave A Comment

Your email is safe with us.