Google Sheets API v4 and valueInputOption
<p>I have three columns in my spreadsheet. The first one is date, the second and the third are simple strings. </p>

<p>When I do batch upload of my data <code>valueInputOption = "RAW"</code> I get a wrong result for my Date column. All dates have an invisible apostrophe before them. String columns are OK.</p>

<p>When I use <code>valueInputOption = "USER_ENTERED"</code> all dates are good, but other values are interpreted not as actual values but as Google parsed values. For example a string "2-3-4" will be represented as 02/04/2004 or something like that. </p>

<p>I want data column to be represented as <code>USER_ENTERED</code> and string columns as <code>RAW</code>.</p>

<p>Is there any way to set <code>valueInputOption</code> for a cell (column)?</p>