Best answer

Dynamically set Google Sheet Spreadsheet and Worksheet custom values

  • 17 June 2021
  • 1 reply
  • 349 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?

icon

Best answer by MarinaH 18 June 2021, 21:49

View original

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 4
Badge +9

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!