Update Google Sheet according to api.v4

update-google-sheets.cs

var valueRange = new Google.Apis.Sheets.v4.Data.ValueRange();
var values = new List<string[]>();
var range = currentSheet.Title + "!H2:H" + currentSheet.Rows.Count + 1;

foreach (var row in currentSheet)
{
    string[] cell = { row.Value[lastSheetCaption] };
    values.Add(cell);
}

valueRange.MajorDimension = "ROWS";
valueRange.Values = values.ToArray();

var request = service.Spreadsheets.Values.Update(valueRange, this.Id, range);
request.ValueInputOption = 
   SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.USERENTERED;
var response = request.Execute();