Need some help here.
I have a step that creates a new spreadsheet from a template. The problem is this newly created worksheet is set to private and inaccessible by other members of my team.
I have already set the template permission to literally anyone with the link can access as I thought the newly copied spreadsheet permission is copied from it.
Can someone help please? I only want the new created sheet write-accessible to anyone with the link.
Try adding this step to your Zap: GDrive - Add File Sharing Preference
Do you own the spreadsheet that is selected as Spreadsheet to Copy or was it shared with you where you have editor permissions?
Unfortunately, using the Google Sheets API, we cannot access shared sheets, only sheets that are in your account.
If you found a solution here, could you please share that with the Community?