title: Setting date format in gsheet through python api using sheet.insert_row()
body: <p>I have a list of data let say</p>
  
  <pre><code>record = ['Tuesday','2018-08-29'] 
  
  </code></pre>
  
  <p>and I try to send it to google sheet through </p>
  
  <pre><code>sheet.insert_row(record,index)
  </code></pre>
  
  <p>and I am successfully receiving it on my gsheet but the issue is, that on the gsheet I am getting a date as a string and I can not apply any formula on it. I try to convert the string to date format</p>
  
  <pre><code>import datetime
  
  
  record[1] = datetime.datetime.strptime(record[1], '%Y-%m-%d')
  </code></pre>
  
  <p>but then on using insert_row is giving me error that </p>
  
  <pre><code>TypeError: Object of type datetime is not JSON serializable
  </code></pre>