ODBC guide

Write values vertically (column mode)

Writes inserted values vertically starting at a specific cell. Uses MajorDimension='COLUMNS' so each value in the row becomes a column of values.

INSERT INTO [My sheet](Column1, Column2, Column3)
VALUES('Jan','Feb','Mar')
WITH(
  Range='G9',
  SpreadSheetId='1az2H8ZYk7BvjddVTqPR-LfDjX9IRpIpjCDpFPe9EzkU',
  MajorDimension='COLUMNS'
)