title: Set raw values in Google Sheets through App Script
body: <p>The behaviour of Google Sheets App Script <code>Range.setValues</code> function seems to be tied to the number format of the cell to be modified:</p>
  <ul>
  <li>If you set <em>Format-&gt;Number-&gt;Automatic</em>, it will try to parse numeric strings as numbers.</li>
  <li>If you set <em>Format-&gt;Number-&gt;Plain text</em>, it will coerce boolean <code>false</code> to string <code>&quot;false&quot;</code>.</li>
  </ul>
  <p>What I'd much enjoy is a sensible behaviour similar to Google Sheets API v4, where you can <a href="https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption" rel="nofollow noreferrer">force it to interpret values as raw.</a></p>
  <p>What I am looking for is unambiguous behaviour, where javascript</p>
  <ul>
  <li>string <code>&quot;&quot;</code> stays string.</li>
  <li>number <code>1.23</code> stays number.</li>
  <li>boolean <code>true</code> stays boolean.</li>
  <li>Date <code>Date(...)</code> stays date.</li>
  </ul>
  <p>Does anyone know whether something like that is possible?</p>