I am wondering if it is possible to anonymize user data stored in the sheet. I want to be able to see all the columns of data, but I don’t want to be able to see what email address it is associated with each row. However, I do want to be able to display data for the currently signed in user.
There wouldn’t be any way to do this currently.
You could do this in a very hacky way using Unique ID, but you would still need a cross reference sheet to link email to unique ID. Unfortunately it wouldn’t be a very smooth process and would probably require a list item based on email to a relation that uses unique ID to link to the rest of the app items.
If you don’t want to see the email, just hide the email column in the sheet so you can’t see it.