Unable to Connect to Calc sheet on Google Drive?

I am getting a request from LibreOffice to enter a Google PIN “G-xxx” when connecting with a spreadsheet on our Google Drive. I have two factor authentication turned OFF in the Google account that contains the drive. I have a phone number associated with the account, but we received no SMS text containing a pin. And even if we did, we would not be able to use this, since many people need to connect to this file.

It appears this this capability is still not ready? Does anyone have a way around this problem?

ditto… same issue.