Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi there @Rosa,

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

6da8df2820cda54e5f0dbb4906b2988b.png
(view larger)

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

Terms & Conditions