Google Drive API v3: .export_media() doesn't work for big sheets

[anelyubin]

Hi Team

I couldn't fetch Google Sheet over export call.

Environment details

• OS type and version: Ubuntu 20.04.6
• Python version: 3.8.10
• pip version: pip 23.2.1
• google-api-python-client version: 2.98.0

Steps to reproduce

1. Select big Google Sheet: more than 5MB and less then 10MB.
2. Call drive.export_media(file_id, mimeType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") for this file. Result - timeout exception after 60 seconds waiting.
3. Set request timeout to 300s (for example), call export_media() again. Result: HTTP 503 ("Transient failure") or HTTP 500 ("Internal Error"), after 90 seconds waiting.