I’m having trouble connecting google sheets that are in Team Drive, they do not appear as a sheet in the dropdown.
Zapier says to check a workaround but the link doesn’t lead me to the workaround
I’ve worked with another zap in another account where I’ve seen this work, but can’t find how on my own.
Does anyone knows how I can do this?
Best answer by Troy Tessalone
View original
+14
Hi
Good question.
Did you already review the help articles for using GSheets in Zaps?
Yes - I feel like I’ve clicked on every article that may be remotely close. I haven’t found the answer.
Someone had the same question a few months ago but when I clicked on the link in the answer - the page was no longer available.
+14
Can you link to that topic?
+14
The link that no longer works refers to this link now: https://zapier.com/help/create/basics/set-up-your-zap-action
This was the other link in the topic to reference:
Thank you so much for trying but that is about custom fields - not about connected a google team drive.
+14
To help us have more context, post screenshots with how your Zap steps are configured and which fields you are having issues with.
So I’m not having an issue with fields.
I’m having trouble connecting google sheets from a Team Drive, they do not appear as a sheet in the dropdown.
There is a text box that says to use a workaround but the link doesn’t lead me to the workaround, just the generic google sheets topic.
I’ve worked with another zap in another account where I’ve seen this work, but can’t find how on my own.
+14
Can you post screenshots of what you are referring to related to the workaround link?
+14
If you are trying to use GSheets as the Zap trigger, have you tried these options?
Zapier relies on Google Drive's notification system to identify when there are changes in a spreadsheet. This currently works well for Google Sheets in your own Google Drive, but can be a problem for spreadsheets within a Team Drive.
In order to help Google prioritize that issue, please visit Google’s issue tracker, and click on the "star" at the top, to indicate that you would like the problem to be fixed.
In the meantime, Zapier has created separate triggers that work with Team Drives. These are marked with (Team Drive) in the Event dropdown menu, in the Choose App & Event part of your trigger step.
That’s exactly what I need! How do I get those triggers? They don’t come up as an option for me.
These are marked with (Team Drive) in the Event dropdown menu, in the Choose App & Event part of your trigger step.
I feel like I’m crazy because this isn’t coming up as an option.
+14
The options for Team Drive are within the GSheet Zap app.
These are the available GSheet Zap app triggers/actions: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
YES! This is exactly what I needed! I couldn’t find it with any search I did. Thank you so much!
+6
That’s awesome
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
