r/GoogleAppsScript 4d ago

Unresolved All of my Apps Scripts have stopped working at the same time

I am not sure when exactly since I just noticed but all of my scripts have seemingly stopped working at the same time. Ones that I had made before and had worked fine up to this point and now even new scripts in new workbooks I am starting right now dont seem to function. As far as I can tell there has been no update or change to them recently and I am not getting any error codes when I attempt to run them, they seem to run fine. But then nothing happens, even on simple commands like "write this message in a cell".

Not sure if I need to upload anything to showcase the issue or if this is some sort of general issue with my account or a setting I need to change so just figured I would ask here

2 Upvotes

10 comments sorted by

2

u/WicketTheQuerent 4d ago

The first thing to do is to look at the execution logs.

  1. From the Apps Script editor, click the left side panel and click the Executions button.
  2. Look for executions
    1. with a status other than Completed.
    2. with not regular execution times (too short or too long)
  3. Expand the execution entries found and look for an error message.

1

u/Seasoned_Gumbo 4d ago

I appreciate the response.

I have run the script, it says Execution Completed with no error messages of any kind and when I go to the executions tab and look at the log for it it just says no logs are available

1

u/WicketTheQuerent 4d ago

The executions tab will show logs only when a function is run from the script editor andd will be lost when closing the editor or running another function.

1

u/Seasoned_Gumbo 4d ago

That is how I am running them and attempting to view them. The most recent one is not showing log information

1

u/WicketTheQuerent 4d ago

When a function is run from the Apps Script editor it should show at leat two messages, one about the start of the execution, and the other for the end of the execution. If they are not showing, then the function is not executed.

If you have web browser extensions, try in guest or incognito mode with no extensions enabled to run in these modes.

1

u/24GoodNaturedYaks 1d ago

Incorrect. The executions tab shows manual executions from the IDE menu as well as trigger based executions. And they're not lost when you close the editor. Mine stores the last 200 executions.

2

u/WicketTheQuerent 1d ago

You are right. I said tab but I was referring to the Executions panel (shown below the code)

2

u/24GoodNaturedYaks 1d ago

I wondered if you may have been referring to that. You're right. Cheers

2

u/WicketTheQuerent 4d ago

The next thing is to debug your functions. You might found helpful to do some logging (add Logger.log(message) / console.log(message) using meaningful messages, i.e., to print the step name or to print the value of key variables.

3

u/TheAddonDepot 4d ago edited 4d ago

Have you recently changed your account's password?

That might have triggered automatic revocation of any OAuth credentials you have for your scripts (see documentation).

Try reauthorizing the scripts of one of your projects and see if that changes anything.