Sign inGet started

Getting started

Welcome to Deepnote

Connecting to data sources

Google Drive

Coding and analysis tools

Google Drive

If you store spreadsheets and CSVs in Google Drive, our native integration makes it easy to access these files from within Deepnote.

How to use the Google Drive integration

There is a two-step process for setting up the Google Drive integration:

  1. Grant Deepnote permission to access the files.
  2. Connect the integration to your desired project.

From there you will be able to use Python to read the files into your notebook.

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).

choose_gd.png

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.

connect_gd_to_proj.png

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:

gd_data.png

💡 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.