Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.
According to the Files you can store in Google Drive Google Sheets has the 5 million cells limit by spreadsheet.
I myself tested the above scenario by trying to insert a 1,999,999 columns to the spreadsheet that contains a single sheet with a single cell (A1) by using the below script:
function testCol() { SpreadsheetApp.getActiveSheet().insertColumns(1, 1999999) }