How to add new blank row in the middle of text in Google Docs when using gspread module for python?
<p>I tried to insert a new blank row example after 8 rows with <code>insert_row</code> or <code>append_row</code> or <code>add_row</code>, but they only add a new row in the end of the sheet.</p>

<p>My question is how to correctly insert the row ?</p>

<p>Also, I read <a href="http://gspread.readthedocs.io/en/latest/index.html?highlight=row" rel="nofollow">documentation</a> didn't find the needed class.</p>

<p><a href="http://gspread.readthedocs.io/en/latest/index.html?highlight=row#gspread.Worksheet.insert_row" rel="nofollow">Worksheet.insert_row()</a> is the way to go</p>

<p>Notice that you must supply the index for where the rows will be inserted.</p>

<p>As for how to insert a certain number of rows your best bet is to use a for loop:</p>

<pre><code>empty_row = ['' for cell in range(Worksheet.col_count)]
insertion_row = 4
number_of_rows = 8
for row in range(number_of_rows):
    Worksheet.insert_row(empty_row,index=insertion_row)
</code></pre>

<p>Note that this will have to make as many API calls as the number of rows that you want to add and currently the insert_rows function is notoriously slow.</p>

python gspread