SpreadsheetWebUserInfo

The SpreadsheetWebUserInfo formula can be utilized to inject user-related information into your workbook, which can help you with tasks such as varying your logic based on the specific user.

The syntax for the SpreadsheetWebUserInfo formula is as follows:

=SpreadsheetWebUserInfo("ParameterName")

The available parameters that can be retrieved into your workbook are defined below.

  • Id – This is the unique identifier of the user.
  • FirstName – The first name of the user.
  • LastName – The last name of the user.
  • Email – The email address corresponding to the user.
  • PhoneNumber – The phone number corresponding to the user, if any was provided.
  • CompanyName – The company name of the user.
  • Country – The country of the user’s postal address.
  • AddressLine1 – The first address line of the user’s postal address.
  • AddressLine2 – The second address line of the user’s postal address.
  • City – The city of the user’s postal address.
  • PostalCode – The postal code of the user’s postal address.
  • State – The state of the user’s postal address.
  • AssociatedTags – A list of tags that the user is associated with. These will be provided in a format of {Text}: {Id};.
  • AssociatedTagNames – A list of tag names that the user is associated with. These will be provided in a format of {Text1}; {Text2}.
Previous SpreadsheetWebRecordInfo