Skip to main content
Best answer

Dynamically set Google Sheet Spreadsheet and Worksheet custom values

  • June 17, 2021
  • 1 reply
  • 407 views

I am using Google sheet for multiple partners, A column mentions the partner sheet id.

I wish to trigger my master sheet in such a manner that a partner receives data relevant to them.

while setting up the action, in spreedsheet field, I am passing a custom entry of the partner sheet id.

The worksheet field throws an error “Unable to load choices”.

How do I make the spreedsheet field dynamic?

Best answer by MarinaHBest answer by MarinaH

Hi @Parv.Barraiser!

Thanks for the great question 👍This isn’t available functionality in the Zap Editor at present, but there is a way to do it - described here: 

 Hope this helps!

View original
Did this topic help you find an answer to your question?
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

Forum|alt.badge.img+9
  • Zapier Staff
  • 238 replies
  • Answer
  • June 18, 2021

Hi @Parv.Barraiser!

Thanks for the great question 👍This isn’t available functionality in the Zap Editor at present, but there is a way to do it - described here: 

 Hope this helps!