Update Google Sheet with Dynamic reference

Questions
1

I have a Google Sheet trigger node that I have manually configured to point to a particular worksheet. That works fine and I get the data I want to work with throughout the flow. The very last step I want to do is to update the row that was worked with and set a column to “Processed”.

I know that I can manually pick the worksheet again in the final “Update Sheet” Node but I was hoping that I could somehow reference the worksheet as it was defined in the first trigger. Not seeing that data available from the node so is there a way to do this or do I just have to update the worksheet reference twice?

2

You need to capture Workbook id and/or Sheet id from each of triggering Google Sheet node parameters, and refer to this captured data in your final Google Sheet append/update node. It will receive params from the trigger that was fired.

If my proposal resolves your issue please mark my post as a Solution.

1 Like
3

Perfect. Thanks!

1 Like