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 MarinaHView original