How To collect all user information?

To collect all the user information in a single sheet

Steps to collect user information

1. Sign in to the Google Admin Console.
2. Click on "Users" to view the list of users in your organization.
3. To view a particular user's information, click on their name in the list.
   
   
   
   
4. You can view the user's basic information, such as their email address, name, and organizational unit.
   
      
   
   
5. Click on the "User Information" button to view additional information such as contact information, group memberships, and device details.
6. You can also export user information to a CSV file by clicking on the "Download users" button.
   
                
   • Select the option for all users.
   • Select the columns (for the column click “All user info columns and currently selected columns/”)
   • Select the file type to download the information.                 
               1.  Google Sheets
               2. Comma-separated values (.csv)

                     
NOTE: Remember to follow proper data privacy and security protocols when handling user information to protect their privacy and prevent unauthorized access or misuse of their data.

  For further reference please refer to the article