CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-docsgoogle-forms
Cathy
Cathy

Reputation: 63

Google doc generated by app script has unexpected owner

Beginner question – I have an app script in a Google Sheet (response sheet from a Google Form) generating Google Docs. It is unexpectedly making me the owner of those docs. The business owner is the owner of the form, sheet, doc template, and shared Google Drive folder where the docs are. She has given me edit access to all. She also is shown as the owner of the app script “project” in the sheet. The app script creates a copy of the template doc in the shared folder, and populates it with data from the form. I am the owner of these new documents, why is that? I am only editor of all the components involved. Can I fix it so that she is the default owner of the new docs?

Upvotes: 0

Views: 96

Answers (2)

doubleunary
doubleunary

Reputation: 19185

The newly created documents will be owned by the account that runs the script. This is clear enough when you run the script manually, but it also happens when you run it through an installable trigger. The trigger owner will own the files created while the function runs.

Upvotes: 3

Laura Dye
Laura Dye

Reputation: 284

Check who owns the 'formSubmit' trigger.
(From your script editor, view your triggers. The left most column will show who the trigger is owned by.) Since your name is appearing as owner, the trigger is most likely still owned by you.

Upvotes: 1

Related Questions