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!

Hi there @IGI,

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:

(view larger)

After that, you should be able to fetch the spreadsheet.

Please let me know if this works.

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

Hi Robert, did you find a workaround this?

The mapping didnt work, but the explanation helps, seems like I am going to use a half automatic workaround then. 

Thank you!

@Robert -FM SALES 

You can try using the Spreadsheet ID via the ‘Custom’ mapping option.

Same with the Worksheet ID.

Triggering on new/updated rows in a sheet on another Team Drive

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.

@Troy Tessalone I made a short loom: 

@Robert -FM SALES 

Please post detailed screenshots with how your Zap steps are configured in order for us to have enough context, thanks.

Hey Troy, yeah I’ve looked it up but couldnt find something like that in the database. Thanks for reaching out that fast tho.

Hi @Robert -FM SALES 

Good question.

Have you reviewed the available help articles for using GSheets in Zaps? https://zapier.com/apps/google-sheets/help