Hey guys,
I am trieng to set up a zap which is triggered by “new spreadsheet row (Teamdrive) in Google Sheets.
But when I have to choose the “*Worksheet” field there comes the following message:
“We're having trouble loading 'Worksheet' data. The app returned "Requested entity was not found.".”
Im looking forward to your help. Thanks in advance
Robert
Best answer by Troy Tessalone
You can try using the Spreadsheet ID via the ‘Custom’ mapping option.
Same with the Worksheet ID.
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.
+14Hi
Good question.
Have you reviewed the available help articles for using GSheets in Zaps? https://zapier.com/apps/google-sheets/help
Hi
Good question.
Have you reviewed the available help articles for using GSheets in Zaps? https://zapier.com/apps/google-sheets/help
Hey Troy, yeah I’ve looked it up but couldnt find something like that in the database. Thanks for reaching out that fast tho.
+14Please post detailed screenshots with how your Zap steps are configured in order for us to have enough context, thanks.
+14You can try using the Spreadsheet ID via the ‘Custom’ mapping option.
Same with the Worksheet ID.
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.
The mapping didnt work, but the explanation helps, seems like I am going to use a half automatic workaround then.
Thank you!
Hi Robert, did you find a workaround this?
I’m using a google sheet (which I have full access too, even though it is shared from someone else), it is shared into my google drive (not google team drive). It is possible it is from the original author of the document. regardless I’ve tried the spreadsheet id in the worksheet id place, and still cannot pass the trigger test.
Would anyone have advice on next steps from here?
Cheers,
Zapier newbie
+6Hi there
I’m so sorry for the late response here.
Is your Spreadsheet an Excel file (.xlsx)? If so, I’m afraid Excel files are not able to get fetched by Google Sheets via Zap.
What you can do here is to save the Excel file as a Google Sheets file in Google Sheets. Like so:
After that, you should be able to fetch the spreadsheet.
Please let me know if this works.
I ran into this same issue and the ID wasnt working for me but I think I figured it out. Seems to be an issue with the team drive VS. personal drive.
Simply do not select an option for “Drive” Leave that empty and then it should pull in the worksheets.
Hope this helps anyone else dealing with the issue!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
