I have linked Google Sheet app with Zapier to write a Google Sheet. When I click on the dropdown to select a Spreadsheet, it doesn’t show the Google Sheet that’s shared by my Client B. It shows Sheets that I own and shared by my other clients (Client A and Client C). I am assigned “Editor” right to all the Sheets. What can be the issue here? It’s not showing the Sheet shared by specific Client B.
Did you select the correct Drive?
Yes, I’ve selected the correct drive.
One thing that I’ve noticed is, the Google Sheet that Client B has shared with me shows that it belongs to a shared drive. That specific Google Sheet doesn’t show up on Zapier.
Sheets shared by other clients don’t show that icon on the sheets list. Could that be a problem? If yes, how to solve that?
Thanks for your response!
Here’s another SOLVED Community article that may be helpful:
Why can't I see my desired folder in the dropdown menu?
Google Drive requires you to be the owner of a given folder in order for you to be able to interact with this folder in Zapier, such as by uploading a file to the folder or triggering on a new file added to that folder.
Also, you cannot trigger or act upon a folder shared with you, so files added to folders you don't own will not trigger the zap. The connected account must be the owner.
Hi Troy, thanks for sharing this. But the problem is that only the Spreadsheet is shared with me by the client, not the entire “Shared drive”. Then how can I get the ID of the shared drive that the client uses?
I tried by entering the Spreadsheet id (copied from the Spreadsheet URL) into the Spreadsheet search dropdown, but it didn’t help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.