How to write access to google spreadsheet in code?

Question

Python

There is a working script that saves a Google spreadsheet to Excel. This table is available via a link.
I ran into such a problem that in another table access is also via a link, but the settings are different there, a request for confirmation by mail was already required. And this link works only after authorization.
How to modify the code so that there is access via the second link?
Now you will definitely have to log in, .ie. to prescribe login/password input in the code? And what does it look like?