Play Video

Find Google Consumer Accounts

Hello and thank you for joining in, this is Goldy again, welcome to the Google Conflicting Accounts video series. 

In the last couple of videos we discussed, what are conflicting accounts, how you can fix them, our options to resolve these conflicting accounts, pros and cons of each of the options that’s available to us, and which option should we consider depending on our scenario.

In this video, I want to show you how you can find Google conflicting accounts (or Google consumer accounts that you users have created with your corporate email domain address).

1.Lets see the Google Conflicting Accounts Resolution Journey

As we discussed in the last post that the journey from unmanaged or consumer account to a work account or managed account goes something like this where you will register your domain, verify your domain, then you will find conflicting accounts, and then we will be able to take actions on them. 

So in this video, we will be focusing on finding conflicting accounts in your Google cloud identity or google workspace domain.

So there are essentially three requirements that you must met to be able to find or identify Google conflicting accounts in your google workspace or identity domain. 

2. So there are Three logistics requirments

(1) The first one is that your domain must be registered with Google. It can be Google Cloud Identity or Google Workspace.

3. 1st is your domain must be registered with google

(2) Now, once you register your domain, of course, Google will only tell you private information like who has the email account created or consumer account created with that email address once you verify your domain ownership to Google.

There are multiple ways to verify your domain ownership to Google such as creating a TXT or Cname in your DNS, upload a html file in your website root, or verifying via Google Analytics property etc.

Now, once you register your domain, of course, Google will only tell you that private information that who has the email account created or consumer account created with that email address.

(3) You should also have super admin role granted as there is no delegated administration privilege for accessing the transfer tool utility that will show us these consumer accounts.

5. Meet the 3rd conduition is Super admin role is granted.

Once you complete these three requirements, you are all set to see and export the list of Google consumer accounts created with your corporate domain email address.

Let me show you a live demonstration on how you can view those consumer accounts.

6. Lets share live demonstration .

I will first log in to my Google Workspace (or Cloud Identity) admin console. I’m a super admin as this is required to use this utility, which will show us the consumer accounts.

8. Lets login to super admin .

Now, once you’re here, you have two options to access Transfer Tool utility, either you can either access from from the dashboard in Admin console, as you see the utility in the screenshot below (on the right hand side).

Now, once you're here, you have two options. Like once you're in your home screen on your Google admin dashboard, you can either click on this transfer tool for unmanaged users.

or you can go to Directory –> Users –> click on “More” –> Transfer Tool as you see in the screenshot below.

you will be able to see a transfer tool for unmanaged users too. When you click on that,

It will take you to the following page where you will see all the consumer accounts that have been created which are ending up in your company domain email address. As you see here, I just have this small demo account, so I just see a few of them.

But in case, if you’re a large corporation, don’t be surprised if you see literally hundreds and thousands of users here.

15.. When you click on you will see this page where you'll see all the consumers account that have been created which ending up

If we have thousands of users instead of scrolling through a page by page, you have flexibility to download them by clicking on this bulk update, unmanaged users.

17. Click on dis bulk update unmanaged user .

When you click on that, it will give you an option to download all unmanaged users in a CSV file.

18.. Click on that it will give you a download option .

Let me click on that and you will see that it’s happening right here. It’s preparing the file.

19.. Now you will see that it's preparing file here let's click on download .

Let me click on Download now. I have downloaded file here. I will better go to Google Drive and simply upload this CSV file i exported from Google Admin console.

22. Take this file and upload it here .

OK, so now there are a few columns and I’ll explain you one by one, what are we supposed to do.

(i) The first one is user email, so this is the email of the consumer account that’s being created with your corporate e-mail address.

(ii) Second one is whether you want to send (resend) account transfer request.

(iii) Third column is whether you want to cancel the account transfer request that you made in the past to this user account.

(iv) Fourth columns shows you the status of the request (e.g whether user took any action, accepted the request, rejected it etc).

(iv) Fifth column shows the number of requests that have been sent to respective user.

(vi) Sixth column shows you the last modified date (e.g the date when you sent the transfer account request).

Notes -: 

Column 1st, 2nd, and 3rd are writable, which means you can change these properties and upload the file back to Google Admin console for bulk actions.

Column 4th, 5th, and 6th are read only, you may either keep them or delete them while uploading the csv file back to Admin console.

25. These three coloumns are writeable.

This is how you can leverage the CSV file for bulk sending the account transfer requests in case if you have lots of conflicting accounts.

In case if you’re a super large organization Google has also launched an API which will help you get all this information like listing all the users who have created consumer accounts with corporate email address along with option to bulk processing (e.g bulk send invite).

I will talk about that, hopefully in some other video on how you can leverage this API. 

I hope it was helpful for you to understand what are the requirements for you to be able to see consumer accounts created with your corporate email address with into your Google admin console, and also download them in a CSV file.

 

RECOMMENDED READING

As you just read Easily find Google consumer accounts created with your corporate email address, I would recommend following as complimentary reading.
Google Workspace to Office 365 SSO & Provisioning Guide
AdminGoogle WorkspaceSecuritySSO

Google Workspace to Office 365 SSO and Provisioning Guide

Read More →
Okta - Google - Integration - Guide
AdminGoogle WorkspaceSecuritySSO

Definitive Guide to Okta & Google Integration

Read More →
Google Workspace Password Vaulted Apps
AdminGoogle WorkspaceSecuritySSO

Securely login to any app with Google Workspace Password Vaulted Apps

Read More →

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top