Google Spreadsheet API update overwrite unspecified value <p>In the Google Spreadsheet API <a href="https://developers.google.com/sheets/reference/rest/v4/spreadsheets.values/update." rel="nofollow">https://developers.google.com/sheets/reference/rest/v4/spreadsheets.values/update.</a>,</p> <p>We can specify a valueRange<a href="https://developers.google.com/sheets/reference/rest/v4/spreadsheets.values/update." rel="nofollow">https://developers.google.com/sheets/reference/rest/v4/spreadsheets.values/update.</a> as the data we want to update</p> <p>Is there a way to overwrite all unspecified cells to empty? For example, if the original first row before updating is: ['1','2','3','4'] . Is there a way to make a request containing ['3'] and update the entire row to: ['3']. In other words, I want to provide absolute overwrite so that I don't need to do a read before update to know which cells I should update to empty</p>