title: How can i add rows in a sheet from a dataframe (using pygsheets) without changing the number of columns in the worksheet?
body: <p>I'm trying to add rows from a dataframe into google sheets Im using python2 and pygsheets. I have 10 columns in the google sheets and 6 columns in my dataframe, and my problem is when I add the rows in the Sheets it deletes the 4 extra columns of my sheets</p>
  <p>so this code should add the number of rows of the df in the worksheet (the rows without any content)</p>
  <pre><code>import pygsheets
  import pandas as pd
  
  sh = gc.open_by_key('xxxx')
  worksheet = sh.worksheet('RawData')
  rows= df.shape[0]
  worksheet.add_rows(df)
  
  </code></pre>
  <p>The code does work but is fitting the grid of sheets to the one of the df.</p>
  <p>does anyone know a solution for adding the exact amount of rows in a worksheet and keeping the worksheet columns intact?</p>