Welcome to GW Manager. 

In this video, I'll show you how you can update your Google Workspace users' licenses in Google Sheets with GW Manager.

For that, I'll go to my Google sheet and then click on Extensions, here you should see GW Manager. 

If you need help with installation, please visit our GW Manager installation guide here.

I'll click on launch to launch GW Manager in the sidebar. 

Once it's launched, we first need to insert a sheet where we can tell GW Manager which licenses we want to update for which users.

For that we can either go to Manage Utilities and then click on run, insert all sheets, execute.

which will insert all the sheets at once so that you can deal with any of these modules.

For now, I'll go to manage licenses and go to update licenses. 

GW Manager recognizes that we don't have an update license sheet inserted yet and it is asking us to insert one.

so we'll click on execute to do that. 

GW Manager has now inserted a sheet called update licenses.

You can provide the user's primary email, the user's old license name that you want to remove, and the user's new license name. 

If you need to learn about which license names you need to put in the old and new license, you can hover on the header field and you will see possible values.

You can also expand this box to look at the license names to copy and paste them. 

If this view does not work out well for you, you can also go to the license name utility and insert that sheet.

You will see all the license names in this sheet. You can copy and paste the license names from here.

For instance, I copied the license name Google Workspace Business Standard and pasted in our update license sheet.

So these two users currently have Google Workspace business starter license, which I'm going to remove and I'm adding a new license, which is business standard.

When you do that, they will not lose any data because we are upgrading their license which comes with even additional features.

Once you have provided this information, you can select run update licenses, and then click on Execute.

Which will change the users' licenses to the new ones and will write the status back here. 

This is how you can update multiple Google Workspace licenses in your Google Sheet with GW Manager. 

You can do much more with GW Manager and we are constantly adding new features based on customers feedback. 

Please visit our website, gwmanager.com to learn more. 

Thank you for reading.