I have a Google Sheet on a teams drive that I have linked to a Google Form. Every time a Form is filled out, this Google Sheet autopopulates with the information inputted on the Form.
Once this happens, I am looking for Zapier to help me create a new Google Sheet on the teams drive using the information from the first sheet.
This issue: Zapier isn’t letting me create the new Sheet within the teams drive. It is only letting me add the sheet to my personal drive. Is it possible to add the new sheet to the teams drive?
Best answer by christina.d
Thanks for reaching out,
That said, there is an open feature request for this that I’ve added your vote to it! I’m not able to offer a time line but in the event this does get implemented we’ll be sure to shoot you an email and update the thread as well.
In the meantime, I don’t know if this fits your use case but a workaround my teammate Nick offered in a similar thread was to use the Google Drive integration instead. The thread is closed but specifically this bit might be useful:
Depending what you’re trying to do you could consider using Google Drive instead (like the Create File from Text action, for example).
You can see in my Zap that this is an option:
And it’s one of the drives that shared with me:I’m not sure if your particular workflows would be able to take advantage of this workaround, but Team Drives are definitely supported in Google Drive.
I hope this helps!