Question

Cannot find Google Sheet to use in Zap

  • 18 September 2020
  • 3 replies
  • 96 views

Userlevel 1

Hi
I am trying to locate a Google Sheet in a Shared Drive and cannot find it.
I have moved the file out of the Shared Drive as a shortcut as well as moved into my own Drive and still I cannot see it.

I have made the file editable for anyone with the link.

‘New Spreadsheet Row (Team Drive)’ which I found out about in your help notes is not available to me.

Not sure what to do next - thsi file needs to be accessed by the team but to get the process going happy to have it in my own Drive but where is the file???


What is strange is for G Sheets, you go from Drive level to file - what about folders in the middle?

Thanks for your help!

JM


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +10

Hi @JM28 

Really sorry we missed this! Did you get sorted in the end?

Userlevel 1

I have now made the file public / editor - anyone with the link can edit.
kind of defeats the purpose of connecting Zapier to Sheets though?
Anyway I still cannot see it.
 

Userlevel 1

What is annoying is I see a tone of other files but not the one I need.
I have tried moving my file to the folders where these other files show up but nothing.
I have copied their sharing settings and again nothing.

I have disconnected and reconnected Drive and Sheets as well.