• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Google Drive - making a copy of a Google Sheet it is not sharing the same permissions and protections of the sheets and ranges with the other editors

Action: Google Drive
Event: Copy A File

---

When a Google Sheets file is copied the copy is missing the permissions and protections of the original

--

In this scenario, I am looking at the original document that I am trying to copy.

If I open and view the protected sheets and ranges, I have selected certain range editing permissions.
See: screenshot-2023-12-14-150102-png.35295

When I open the google sheet and share it I have the option to "share it with the same people". By doing so all the functionality of the sheet remains intact and as intended.
See: screenshot-2023-12-14-150150-png.35297

When a copy of the file in Pabbly is made using the

Action: Google Drive
Event: Copy A File

The sheet is still shared with the same people, but they are no longer able to edit the protected ranges. Their permissions are gone.
See: screenshot-2023-12-14-145856-png.35296

If they try to edit anything, they receive this message.
See: screenshot-docs-google-com-2023-12-14-14_50_45-png.35294

How do I ensure all the permissions and protections of the original sheet are applied to the copy?
 

Attachments

  • screenshot-docs.google.com-2023.12.14-14_50_45.png
    screenshot-docs.google.com-2023.12.14-14_50_45.png
    67.5 KB · Views: 30
  • Screenshot 2023-12-14 150102.png
    Screenshot 2023-12-14 150102.png
    285.5 KB · Views: 25
  • Screenshot 2023-12-14 145856.png
    Screenshot 2023-12-14 145856.png
    260.3 KB · Views: 31
  • Screenshot 2023-12-14 150150.png
    Screenshot 2023-12-14 150150.png
    228 KB · Views: 31

ArshilAhmad

Moderator
Staff member
Hi @J.B. Murdock,

Currently, there is no action event in the Google Drive action step that could help you apply the original permissions and protections to a copy of a file. If you would like this endpoint to be added to Google Drive, you can submit your request on our dedicated platform: https://pabbly.featureos.app/b/Integration-Request

Our integrations team will review your request and, if possible, add the desired endpoint/feature to the Google Drive action step.

For now, you can try using the 'Google Drive: Share a File' action event as a workaround to grant editing permissions. Please note that you won't be able to specify an editable range using this action event. This is just a workaround and not the exact solution for your concern.
1702593094950.png
 
Top