Duplicate google script attached to a google sheet

Hello,

I’m trying to duplicate a template google sheets including an App Script Project. The problem is when I duplicate file through the widget google drive, I cannot have the script automaticaly duplicated as well.

It looks like I need to create as well another step with Custom Code to do so.

But the problem is to duplicate a script it needs an OAuth authorization that I cannot have. It seems very complex to have it.

So 2 questions :
1 - Did anyone solved the issue to duplicate a file with its script ?
2 - How to connect my Cloud Console project with a script knowing that I’m not using pro version of Google Drive.

I tried and used these scopes
scopes: [
https://www.googleapis.com/auth/drive’,
https://www.googleapis.com/auth/script.projects

But it always require OAuth connexion.

Thanks for your help.