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.

  • Home
  • Get Help
  • How Do I
  • Can't pull Google worksheet data when looking up row after triggering from New Spreadsheet

 

 

Ultimate Goal

I’m trying to trigger sending a PDF of my google sheet (one worksheet or a group of specific worksheets) to a recipient that is defined in a row in my sheet, as well as the subject and the body of the email.

Our team utilizes a template that i’ve made to create new sheets, so I can’t attach zaps to this specific file, since they work on copies.

I already have a working script in my sheet that makes a copy of the sheet and puts it into a specific folder on our team drive, so I can trigger based on detecting a new sheet. (If there is a better way to trigger a zap on a template copy, and pull data from that specific copy every time, i’m open to suggestions)

The Zap So Far

I’m making the first step of this Zap “New Spreadsheet in Google Sheets.” It finds the sheet fine.

Do This … Lookup Spreadsheet Row. I can’t get this step to actually dig into the sheet that was found.  I always get the error “We’re having trouble loading 'Worksheet' data. The app returned "Requested entity was not found."

I’ve tried every line item under “Custom” since I want to pull the file data conditionally based on the first step, not just search the same test file every time.

What am I misunderstanding?

 

Pulls the file correctly
Can’t actually dig into the file

 

Hi @thartgrove86 ,

Thanks for reaching out- happy to help!

Currently, it is not possible to dynamically choose a spreadsheet in Google Sheets the same way you can dynamically choose options for other custom-value type dropdowns. This is because there isn’t a way for us to generate a good action template unless we know specifically which spreadsheet/worksheet combination will be used each time the Zap runs. 

However, check out this post for a workaround one of our Experts has shared! Let us know if that does the trick for you!

Terms & Conditions