| userLogin | string | The user’s unique Google Workspace login identifier (primary username). Used across Google Sheets and all Google services for authentication and resource ownership. | False | [email protected] |
| firstName | string | The user’s legal first name as displayed in Google Sheets, comments, sharing dialogs, and Google Workspace profile. | True | John |
| lastName | string | The user’s legal last name (surname) used in Google Sheets and across Workspace identity records. | False | Doe |
| email | string | The primary email address of the user. Used for signing in, sharing Sheets documents, sending notifications, and ownership of Google Drive files. | True | [email protected] |
| status | string | Indicates whether the user’s Google Workspace account is active, suspended, or archived. Controls access to Google Sheets and other Workspace services. | True | ACTIVE |
| createdAt | dateTime | Timestamp representing when the user account was created in Google Workspace. Displayed in Admin console audit logs and indirectly affects file ownership timestamps. | False | 2024-05-14T10:23:45Z |
| lastUpdated | dateTime | Timestamp showing the most recent update to the user’s profile information within Google Workspace Directory (e.g., name, email, status). | False | 2024-10-02T18:12:00Z |
| companyName | string | The organization or company name associated with the user, displayed in the Google Workspace user directory and editable in the admin profile. | False | Example Corporation |
| department | string | The department to which the user belongs, shown in user profiles and available for organizational reporting inside Google Workspace. | False | Information Technology |
| displayName | string | The full formatted name displayed across Google Sheets—such as in comments, sharing dialogs, version history, and real-time collaboration presence. | False | John Doe |
| employeeId | string | The employee identifier assigned by the organization. Often used for HR integration and displayed in Google Workspace Admin Directory. | False | E12345 |
| employeeType | string | The type of employment (e.g., Employee, Contractor), used for organizational metadata and sometimes filtered in Sheets-based workflows. | False | Employee |
| timezone | dateTime | The user’s preferred timezone, used across Google Workspace to show timestamps in Google Sheets revisions, comments, and activity tracking. | False | America/Los_Angeles |
| jobTitle | string | The user’s job title as displayed in Google Workspace Directory and visible to collaborators in Google Sheets when viewing profile information. | False | Senior Data Analyst |
| mobilePhone | string | The user’s mobile phone number associated with their Google Workspace profile. Used for security verification and internal contact directories. | False | +1 206 555 0198 |
| streetAddress | string | The user’s primary street address as listed in the Google Workspace Directory profile. | False | 123 Main St |
| city | string | The city component of the user’s physical address stored in the Google Workspace user profile. | False | Seattle |
| state | string | The US state or province for the user’s location as stored in the Google Workspace Directory. | False | Washington |
| postalCode | string | The ZIP or postal code associated with the user’s address in the Google Workspace profile metadata. | False | 98109 |
| country | string | The country associated with the user’s address, displayed in the Google Workspace Directory and used in regional preferences. | False | United States |