title: Upload CSV to Google Drive Spreadsheet using Drive v2 API
body: <p>How can I upload a local <strong>CSV</strong> file to Google Drive using the <strong>Drive API v2</strong> so that the uploaded file is in the <strong>native Google Spreadsheet</strong> format. Preferably in Python, but a raw HTTP request will suffice.</p>
  
  <p>What I tried:</p>
  
  <ol>
  <li><p>request body content-type: 'application/vnd.google-apps.spreadsheet', media_body content-type: 'text/csv'. --> 401 Bad Request</p></li>
  <li><p>request body content-type: 'application/vnd.google-apps.spreadsheet', media_body content-type: 'application/vnd.google-apps.spreadsheet'. --> 400 Bad Request</p></li>
  <li><p>... (a couple of others such as leaving a property out and similar, usually got 400 or Drive didn't recognise it as a native spreadsheet)</p></li>
  </ol>