Connect LibreOffice to Google Drive Remote Files

LibreOffice includes a built-in Remote Files feature that allows users to access, edit, and save documents directly to cloud storage providers like Google Drive without needing third-party sync clients. By establishing a direct connection between the office suite and the Google Drive API, users can manage their cloud-hosted documents seamlessly within the native LibreOffice interface.

How the Remote File Service Works

LibreOffice uses standard network protocols and service-specific APIs to communicate with remote servers. When connecting to Google Drive, LibreOffice utilizes Google’s authentication system (OAuth 2.0) to securely link the application to your cloud storage account without storing your primary password in plain text. Once connected, your Google Drive folder structure appears inside the LibreOffice file manager interface.

Setting Up the Connection

To link Google Drive to LibreOffice, follow these steps:

1. Access the Remote Files Dialog: Open LibreOffice, click on File in the top menu, and select Open Remote File… (or click Remote Files from the LibreOffice Start Center).
2. Add a New Service: In the Remote Files dialog, click the Manage Services button (or Add Service).
3. Select Google Drive: In the File Service window, choose Google Drive from the Type dropdown menu.
4. Enter Account Details: Enter your Google account email address in the User field. You can also specify a custom label in the Label field to easily identify the connection.
5. Authenticate: Click OK. LibreOffice will prompt you with an authentication window or open your default web browser asking you to log into Google and grant LibreOffice permission to access your Drive files.
6. Authorize Access: Follow the on-screen prompts to grant permissions. Google will provide a verification code or automatically validate the session back to LibreOffice.
7. Set Master Password (Optional): If prompted, configure a LibreOffice Master Password to encrypt and protect stored remote credentials on your local machine.

Opening and Saving Remote Files

Once configured, the Google Drive service will appear in your LibreOffice file dialogues:

• Opening Files: Go to File > Open Remote…, select your Google Drive connection from the service list, navigate your folder hierarchy, and select the file you wish to open.
• Saving Files: Go to File > Save Remote…, select your Google Drive service, choose the target folder, enter a file name, and click Save. Any subsequent changes saved with Ctrl + S (or Cmd + S) will upload directly to Google Drive.

Technical and File Compatibility Considerations

• Supported Formats: LibreOffice interacts directly with standard file formats stored on Google Drive (such as .odt, .ods, .docx, .xlsx, and .pdf). Native proprietary Google Docs, Sheets, or Slides files cannot be directly edited in their native web formats and must be downloaded or exported as compatible office formats.
• Two-Factor Authentication: If your Google account uses Two-Factor Authentication (2FA), ensure you complete the browser-based OAuth prompt properly during setup.
• Offline Access: Because the connection interacts directly with the Google Drive API over the internet, an active network connection is required to open and save files using the Remote Files menu.