The following is my problem and how I anticipate getting around it.
My trigger is Airtable, and my integration is with Google Docs and Google Drive.
I want to do the following:
- Make a folder in a shared drive
- Create a document in that folder based upon a template that lives in my shared drive
- In a zap later on, make a copy of this file and place it in that same folder
I cannot do steps 2 and 3 here, as it seems like you cannot retrieve a file from a shared drive.
I could change step 2 to: Create a document in that folder based upon a template that lives in my personal drive.
However, step 3 does require that file being copied is in a personal drive, not a shared drive.
So here is what I’m going to do instead.
- Make a folder in my personal drive
- Shortcut that folder into the location I want in the shared drive
All steps of the zap will now act within that folder, which is in the personal drive.
For context, the google account I will be using is the admin@ account for the organisation, so it should still work if I ever leave the organisation.
I wish Zapier would either:
- Add in the ability to retrieve a template from a shared drive, or
- Publish an article about why this is not possible/tricky (maybe for security reasons?), which would provide some clarity