I'm trying to write a script to process data from a Google Sheets spreadsheet. I have Google Advanced Protection enabled and it seems to be blocking my script even though I wrote it for my own data.
The FAQ says:
If you're enrolled in Advanced Protection, Apps Script can be used. If scripts request access to certain data in your account, like emails, documents, or photos, they may be blocked.
However, I can't find any details about which functions are actually blocked or if there's any acceptable way to read my sheets data. Right now it seems like any function that tries to actually read data such as SpreadsheetApp.getCurrentCell or getActiveSpreadsheet prompts me for authorization (which is then blocked by advanced protection).
Is there a way around this without disabling advanced protection or will I just have to export my data and process it elsewhere?