1

I have a google spreadsheet with the permission "anyone with the link can view" so that I'm the only one able to edit but people can look at it freely. I have also been giving people the https://docs.google.com/spreadsheets/d/spreadsheetID/copy link so that they automatically make their own copy of my spreadsheet and give me the link when they are done inputting. I naively assumed the permissions would be the same, but the copy is privated and requires me to request permissions to view.

How can I configure it so that they are creating a copy with the same permissions(allow anyone to view without logging in and they are the only ones able to edit)? Or if its not possible, then something like

creating a script in the parent spreadsheet that when run, creates a new copy of the spreadsheet in my google drive, and gives them or redirects them to the copy's link.

Improve this question

1 Answer 1

Reset to default
0

From the OP's question

How can I configure it so that they are creating a copy with the same permissions?

It's not possible.

Or if its not possible, then something like

creating a script in the parent spreadsheet that when run, creates a new copy of the spreadsheet in my google drive, and gives them or redirects them to the copy's link.

This is possible. You could use the Drive Service but to have more control about how the file permissions are handled you should use the Advanced Drive Service.

References

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.