import gspread
# print(gspread.__version__)
from google.colab import auth
from oauth2client.client import GoogleCredentials
import gspread
auth.authenticate_user()
gc = gspread.authorize(GoogleCredentials.get_application_default())
# https://docs.google.com/spreadsheets/d/{スプレッドシートのID}/edit#gid=0
ss_id = "{スプレッドシートのID}"
workbook = gc.open_by_key(ss_id)
# シート名
worksheet = workbook.worksheet("シート名")
# 行数
worksheet.row_count
認証を求められるので承認する
991