I like to fire off Salesforce to make a copy of a Master google spreadsheet that is shared with several people. I am able to make a copy of the Master spreadsheet, but I am not able to keep ‘share it with the same people’ functionality.
Does anybody have a solution for this?
Best answer by firstname.lastname@example.orgView original
You can use a “Google Drive->Add File Sharing Preference” step to set a sharing scope of any file in your drive and create a share link for it. Does that get you there?
Thanks for the tip I will set this up and see if it works for us.
It seems I needed another step in between
Coming back to this sharing of the file option, to share the new file with people I can use ‘Anyone at your organization with the link can edit’ which works fine.
Is there also a possibility that keeps the ‘Share it with the same people’ option? I can’t find it in the zap possibilities.
When you make manually a copy of an existing Google sheet you have this option. I am hoping that I can also do this with my Zap
Would you like me to flag this so someone from the Zapier team can create this as a feature request for you?
That would be nice.
@email@example.com - Thanks for the request. You’ve been added and will be contacted via email should we have any updates to share. Thank you!