I added this script link to the google sheet, trying to save time by not having to manually enter the sheet name in the cell:
function sheetname() { return SpreadsheetApp.getActive().getName(); }
Then I realized that it was unstable, so I stopped calling it from inside the sheet =sheetname() . Then I forgot about it, continuing to duplicate my sheet (with this related script) with over 1000 new files.
Now I need to create a stand-alone script for another purpose, but when I save it to be able to run the script, I get this message:
"The service was used many times a day: the dev console project tried to create."
I managed to save the script project once, but then, when I tried to run it, I received this slightly different error message:
Error saving project: Too many scripts created in one day for this Google user account.
So, I realized: well, I have to wait one day and not duplicate the script-bound file during this time. But that did not work. So now I seem to be stuck here, unable to add a script from my account every time.
From what I understand, related scripts can only be accessed and disabled / deleted through each of the duplicated sheets of the Google script sheets.
Will I ever be able to add scripts again without opening 1000 duplicates and not deleting each of the related scripts? Or by removing 1000 duplicates and get started? If so, how?
I have already spent too many hours manually manually connecting each duplicate file to the master list using importrange .