Update row based on cell value
I just wanted to ask if this is true:
I am able to insert new rows in the sheet but now I am trying to update existing rows based on the primary column. Basically trying to develop an upsert integration.
Looking at the Update Rows api docs, it seems like I will need to get the Row Id first of all the existing data/rows in the sheet and use that to update? Like there is no way to just update based on the Primary Column value?