Adding a new test user is not possible

[Camille974]

Hello,

I'm an assistant casting director and I know absolutely nothing about coding, and I'm even more circumspect in Google Cloud Console. Thanks to ChatGPT, I was able to create an input form via Apps Script, integrated in sidebar on Gmail, which transmits information to a Google Sheet (with a functionality to search and edit data present in the sheet). It's very handy for my work.

It works perfectly on the Gmail account where I created the project (Tigger), but I can't seem to add new users (free Gmail accounts).

I've tried everything to no avail, but I always get the same result: I share the Google Sheet and the script, the user authorizes the application, then tries to deploy the application in his own script, but he gets an error message saying he needs to refresh the page. Then the application seems to freeze and stops responding.

I've been stuck on this problem for several days without finding a solution, even with the help of ChatGPT. I'm ready to provide all the necessary information so that you can help me find a solution!

Many thanks to the community.