c# - What's the best strategy to do a "update .. where" in Google Sheet using their API? -

i have table on google spreadsheet, , c# application needs update cells based on content of first column(s), similar "update ... ..." in sql.

so far, current method clears sheet , adds rows again, not appropriate if users want add more columns manually table, , not find on sheets' .net library allow such thing, i'm wondering if there better strategy this.

perhaps content of sheet object, modify in code , update sheet? i'm trying avoid because such heavy operation big table.