I’m trying to automate emails for my job, my scenario is dependent on getting the email address of the person who edits the google spreadsheet. Usually detected under “User” with Nickname and email address.
It works when detecting my email address, but for other people editing the spreadsheet it just shows up blank.