title: Updating Google Spreadsheet Row by Row using Gspread
body: <p>I am using Python and gspread to insert data into/update my Google spreadsheet. </p>
  
  <p>I have tried two different scripts. The first gives me the error that the object is not JSON serializable. The second works but eventually stops because I reach my quota of API calls. I have a lot of data that needs to be updated.</p>
  
  <p>Code 1</p>
  
  <pre><code>    row=list(df.iloc[i])
      sheet.insert_row(row, i+2)
  </code></pre>
  
  <p>Code 2</p>
  
  <pre><code>    row=list(df1.iloc[i])
      for j in range(len(row)):
          x = str(row[j])
          sheet.update_cell(i+2,j+1,x)
  </code></pre>
  
  <p>Error 1</p>
  
  <pre><code>TypeError: Object of type Series is not JSON serializable
  </code></pre>
  
  <p>Any help would be appreciated.</p>