As with all integrations, once you set up the Google Drive integration, members of your workspace will be able to connect it to any project (if they have the appropriate permissions to do so).

Let's set it all up and look at some examples of working with files from Google Drive.

Authorizing & connecting

First, click the Integrations section in the left panel and find the Google Drive entry in the list of native integrations (you can also create new integrations in the Integrations area in the right panel).

You will be taken through the authorization flow (via OAuth). Once Deepnote is authorized to access the files, connect the Google Drive to your desired project as shown below.

The access credentials are encrypted and stored securely in our database. You can revoke access by revisiting the Google Drive integration pop-up and clicking Revoke access.

Accessing a Shared Drive

To access a Shared Drive within your workspace, set the Team Drive ID in the Integration settings. You may get the Drive ID from the URL of the Drive.

Working with files in Google Drive

Once Google Drive is connected to your project, it will be mounted to the /datasets/ folder. It is now a simple matter to use pandas (or other standard Python commands) to read the files into your notebook and begin working with them.

Here's an example using pandas to read a CSV from Google Drive into the notebook:

💡 You can also use the Google API to read Google Sheets directly into the notebook. Please see these examples to learn how to read a public and private Google sheet into Deepnote.