Hello @towyssl
Using this approach as you mentioned, you’ll need multiple “Update Row in Sheet” nodes, and to update data only for a specific range, you’ll need to specify the location in the “Data Location on Sheet” option.
For example:
Calling the Google Sheets API using an HTTP Request lets you do it in a single call node, and the JSON body is easy to create, especially since the cell range syntax (like "B7:H7") is the same as what you see in Google Sheets:
Here’s a sample of this approach:
Personally, I prefer this one.
Try both approaches and see which one works best for you, only you can decide based on your specific situation.