Error when appending 'This range already has a worksheet with different title set'

[caynebrister1]

For some reason I get the error 'This range already has a worksheet with different title set' when running the following code:

gc = pygsheets.authorize(client_secret='auth/client_secret.json', local=True)
sh = gc.open_by_key('1rP-RKuIfkGB_qps7VclkmBEQW9T2DfwJm64UVcc-4lw')
wks = sh[1]
wks.append_table(values=['1', '2', '3'])

Ive searched the error up but cant find much on it and I am having trouble understanding what is causing the error, if anyone knows what is happening and how I might be able to fix this I would love to learn!

[caynebrister1]

Couldnt figure it out so ended up just using try/except to ignore the error.

[Vanifac]

Seeing this error as well. The append seems to go through regardless.

[CodeBiriyani]

@nithinmurali is there a workaround for this? As @caynebrister1 mentioned I have been using it with the try/except block and using the Insert Rows method to get over this.

If I am able to execute the append_table method without any error, the class becomes extremely powerful as I can write to multiple sheets from a single script.

[Jacoba777]

Hello, I've just encountered this issue as well.

If you are getting this error, you are probably trying to append a single row of data as a simple list, whereas this function is expecting a list of lists (so that you could add many rows at once). If you mean to only add a single row, then just wrap your row in an additional list.

For instance @caynebrister1 could fix the code above by changing the last line to
wks.append_table(values=[['1', '2', '3']])

[Anthony-Marcovecchio]

@Jacoba777 Experiencing the same issue noted above, ensuring values is a list of lists does not resolve the 'This range already has a worksheet with different title set' message on my end. Using worksheet.insert_rows(row=1, number=1, values=[ [1, 2, 3]]) pushes the data successfully but without that error message. Hope this helps

[SamLiCN]

Hello, I met similar case, it solved after I remove the space in the "sheet title";
in my case, append_table can add new row to Google Sheet, the error in the return value
{
"spreadsheetId": string,
"tableRange": string,
"updates": {
object (UpdateValuesResponse)
}
}
the "tableRange" value for sheet title has extra quote "''".