I have a template google sheet that I use as a registration form. It has a attached google apps script that, when the submit button is clicked, scrapes the data from the sheet and sends it to my BE. Each user should have his own registration form (google sheet) that is cloned from the template. This cloning is done by another google apps script that uses copyTo() to create this new copy. However, the script does not seem to be copied – when the user in his sheet clicks on the submit button, it just shows error that the target apps script function was not found.

What am I missing? Why is the script not copied? I even have it in a separate GCP project (the same project that my BE – cloud function and buckets – reside).