In this case, I would like to propose the following flow. Your gauth = GoogleAuth() can be used for downloading the Google Spreadsheet as the XLSX format.You want to achieve this without saving the downloaded XLSX data as a file.You want to read the XLSX downloaded from Google Drive using pd.read_excel.I believe your goal and situation as follows.
