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,I select Google Sheets as the starting App Then I select the account associated with the shared drive. 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!

Question

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

9 months ago
9 October 2023
1 reply
102 views

Rosa
New
0 replies

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,

I select Google Sheets as the starting App
Then I select the account associated with the shared drive.
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!