Add data after the last filled line of Google Sheets, with gspread python

Question

I need to add a dataframe's values to the end of the last row of records in my Google spreadsheet, but I can't. Each time I use the code below, it subscribes to the above information. I'm using a gspread library to update the data in the Google Sheets spreadsheet.

sheet.update([df_data.columns.values.tolist()] + df_data.values.tolist())

I want to add new data after the last filled line.

score 2 · Accepted Answer · answered Oct 09 '21 at 23:45

In your situation, how about using the method of appendRows?

Modified script:

From:

sheet.update([df_data.columns.values.tolist()] + df_data.values.tolist())

To:

If you want to append the value of [df_data.columns.values.tolist()] + df_data.values.tolist(), how about the following modification?

sheet.append_rows([df_data.columns.values.tolist()] + df_data.values.tolist(), value_input_option="USER_ENTERED")

If you want to append the value of df_data.values.tolist(), how about the following modification?

sheet.append_rows(df_data.values.tolist(), value_input_option="USER_ENTERED")

Add data after the last filled line of Google Sheets, with gspread python

1 Answers1

Modified script:

From:

To:

References: