I have 2 large csv files 10 to 15k rows and 20 columns. Right now I have a script that is importing them but leaving empty rows or timing out. It is doing them in segments need to find a way to get them to import without leaving empty rows.
Sorry its not google drive they are in google drive and need imported into a sheet inside a workbook on google sheets. Daily
I think your task has scripting solution. Google script is a good alternative for direct data import. Moreover, script may be simply scheduled daily for your needs.