title: Google Sheets BatchUpdate API changes the Columns Order on insert
body: <p>I have a template spreadsheet with many sheets, each with a header row ready to receive data via batchUpdate.</p>
  <p>The data inserts correctly into the right columns. However, the column order is changed to the same order as the items in the value ranges. This breaks formula and makes the sheets messy.</p>
  <p>Is there a way to use batchUpdate and the column order is not changed when the data is inserted?</p>
  <p><a href="https://i.stack.imgur.com/MWj59.jpg" rel="nofollow noreferrer">Request</a></p>
  <p><a href="https://i.stack.imgur.com/HzT5l.png" rel="nofollow noreferrer">Response</a></p>