Order the creation of a new sheet in google sheet from storyline

There are a few issues I can spot that may cause problems. First you're defining GoogleSheetURL from a variable and then you've got it in the code but not defined with "const". You should choose one method or the other.

Have you checked that the URL is the one you get when you deploy the apps script?

Also const sheetName = "Screen1"; should be the name of the the first sheet in the worksheet.

I'm not an expert on Javascript, a lot of this was developed with the help of ChatGPT - but those would be the first things I fixed/checked.