this is because the uploaded sheet has column count of but we have only columns of data you can read the number of rows and columns in sheet with the rowcount and columncount attributes then by setting these valuesyou can change the size of the sheet sheet rowcount the number of rows in the sheet sheet columncount the number of columns in the sheet sheet columncount change the number of columns to sheet columncount now the number of columns in the sheet is these instructions should delete the fifth and sixth columns of the "producesalesspreadsheetas shown in figure - figure - the sheet before (leftand after (rightchanging the column count to according to google sheets spreadsheets can have up to million cells in them howeverit' good idea to make sheets only as big as you need to minimize the time it takes to update and refresh the data creating and deleting sheets all google sheets spreadsheets start with single sheet named "sheet you can add additional sheets to the end of the list of sheets with the createsheet(methodto which you pass string to use as the new sheet' title an optional second argument can specify the integer index of the new sheet to create spreadsheet and then add new sheets to itenter the following into the interactive shellimport ezsheets ss ezsheets createspreadsheet('multiple sheets'ss sheettitles ('sheet ',working with google sheets