The open-source gspread library allows the user to interact with Google sheets.

from google.colab import auth
auth.authenticate_user()

import gspread
from oauth2client.client import GoogleCredentials

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

This imports the library and creates the interface to Sheets.

To create and update a new sheet, use:

sh = gc.create('My cool spreadsheet')
worksheet = gc.open('My cool spreadsheet').sheet1
worksheet.update_cells(cell_list)