My Zap can't find shared Google Sheets when triggering from a Shared drive to a Personal drive.

  • 9 October 2023
  • 1 reply

Hi team!


I’m trying to create a Google Sheets dashboard on my personal drive that tracks multiple KPIs. The data for the dashboard would be pulled from different sheets from a shared drive. What I want the Zap to do is pull specific data from a shared drive spreadsheet into a spreadsheet in my personal drive, but I can’t seem to find the sheet in the shared drive to start the trigger.

When setting up the Zap,

  1. I select Google Sheets as the starting App
  2. Then I select the account associated with the shared drive.
  3. The issue I’m running into is when selecting the “Trigger”, in this case the specific google sheet. The sheet that I want it to connect to does not come up. In fact, only 6 sheets appear on the list when the shared drive has way more than that. 

What am I doing wrong? 



Thank you so much!

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

1 reply

Userlevel 7
Badge +6

Hi there @Rosa,

In order to use files from a shared or Team drive try using the New or Updated Spreadsheet Row (Team Drive)

(view larger)

Please give that a try, and let me know how it goes! 😊