Download a Google Sheet (or any Google Doc) to Colab VM using gspread

download_sheet.py

GOOGLE_SPREADSHEET_ID = '<ID_OF_YOUR_SPREADSHEET>' #e.g. 1klG4ihJRyesiWAI_Fq1mv-fErbXtXP4IoVmrJ9hij-k

from google.colab import auth
auth.authenticate_user()

import gspread
from oauth2client.client import GoogleCredentials

gc = gspread.authorize(GoogleCredentials.get_application_default())

import os
if os.path.exists("export.xlsx"):
  os.remove("export.xlsx")

# you can change the format changing the 'format' parameter of the URL 
exported_file = gc.session.get('https://docs.google.com/spreadsheets/d/' + GOOGLE_SPREADSHEET_ID + '/export?format=xlsx')
open('export.xlsx', 'wb').write(exported_file.content)