Append data to a spreadsheet method from Google Sheet resource to add row to a spreadsheet. It's possible to add row but without updating some fields (for example if you keep cursor in a spreadsheet in formula bar in one of the cells of new row). My goal is to verify if all data was added correctly.
Append method returns property - data.updates.updatedRange which points to a range in A1 notation. I want to use this range to read data from spreadsheet and verify if all necessary fields are updated. The problem is that I can't get any results if the first row of the spreadsheet is not included in range definition and I can't find a way to bypass that limitation.
I've tried to use range like this:
It selects cells in spreadsheet but doesn't work with Retool.
Similar case is described in this stackoverflow topic:https://stackoverflow.com/questions/56263938/google-sheets-v4-net-batch-get-a1-notation-for-first-row-then-all-rows-starting
Could you please suggest how my issue can be solved?