How do I open a Google Docs spreadsheet in LibreOffice. There's a 6 digit pin involved

LibreOffice says I need a 6 digit pin for my Google account. I just chatted with Google, and they say I need to solve the problem on the LibreOffice side.

How do I open a Google Docs spreadsheet

In fact you can’t - you can’t even download a Google Sheets document in a native Google sheets document format. Whenever you want to download such Sheets document, you need to select an output format, such as .xlsx,.odt, pdf and a few more. You never get something like a file MyTable.gsheets stored in a Google document format. If you carefully watch the the sizes of Google documents within your account under GDrive, you’ll notice that these are all of size - - so there are no classical “files” for the various types of Google documents which you could retrieve or open from Google Drive (and I’m not aware of any documentation where Google discloses how they store these type of documents).