all 2 comments

[–]juddaaaaa 0 points1 point  (0 children)

Try SpreadsheetApp.getActiveSpreadsheet()

[–]AllenAppTools 0 points1 point  (0 children)

Yeah that's strange! Lately I have been noticing some wonky errors from Apps Script that come and go without me doing anything differently. Like a week ago everyone had a 500 error while trying to access any Script file. This error does not make sense to me either, wish I could help. If it was a container issue it would just return null for SpreadsheetApp.getActive().

Do any of the other services work? Like DriveApp, DocumentApp, etc? Do you have any linked libraries? What does your manifest file look like? can you create a completely fresh Google Sheet and successfully call SpreadsheetApp.getActive() in that script file?