My company uses Google Workspace (G-Suite), and all users have a Google Account identified by their company email address.
I have a Google Form that writes to a Google Sheets spreadsheet. It automatically collects the account email address of the user who submits the form, but I'd like to get the name of the user, which appears in the G-suite directory.
Has anyone done this or could anyone help me figure out if it's possible? I can write a script if needed, but I have no special privileges within the G-suite service.