Write a row to a custom cell range
Writes a single row starting at a specific cell in a spreadsheet (for example G9 in My sheet). Values are written in the same order as supplied in the SET list.
UPDATE [My sheet]
SET Column1='data-1', Column2=100, Column3='2020-01-31'
WITH(
WriteRange='G9',
SpreadSheetId='1az2H8ZYk7BvjddVTqPR-LfDjX9IRpIpjCDpFPe9EzkU'
)