User's email to load customer specific Gsheet API

Trying to use the signed-in user’s email to add to a google API to pull data from a specific sheet. I don’t have much technical experience but if someone could help me get sheetName to equal the logged-in user’s email that would be great. I know this isn’t secure but for my use case this works good.

Hi Adam,

I can’t debug your Google sheets access script, as I’m not familiar with the current API. However assuming it works and you are just needing to set the sheetName variable to the current user’s email, you’d do that inside of the callback.