My programs were fine until I updated gspread to 6.x.x. and encountered this exact "transferownership" error. Downgraded to 5.4.0 and issue resolved.
pip install --upgrade gspread==5.4.0