Google sheet node executed only once

So this is a special behavior in the Merge node described here:

When the “Wait all data” node from your screenshot is executed, it would try executing the Function node (which presumably fails because it doesn’t have the required data available yet). I am afraid that’s how it currently works, but you might want to vote on the feature request linked above to change this.