Print

Import Dropbox Data to Google Sheets

premium

In this guide, we’ll walk through how to import Dropbox data directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get your Dropbox API Credentials

  1. Log in to the Dropbox developer console at https://www.dropbox.com/developers
  2. Navigate to the App Console and click Create app (or click https://www.dropbox.com/developers/apps/create to go there directly)
    dropbox-createapp
  3. Choose the type of access you need (App folder or Full Dropbox), name your app, and click Create app
    dropbox-configapp
  4. Click over to the Permissions tab, tick the boxes for all data you'd like to access, and click Submit. Note: this step must be done before you generate your token, as the token's scopes can't be updated later (if you need to change or add scopes, you'll need to delete your app and create a new one).
    dropbox-permissions
  5. Now click back to the Settings tab of your app. Scroll down the page and click Generate to get your token. Copy this token down and keep it safe, we'll need it shortly.
    dropbox-generatetoken

Part 2: Get Dropbox Data in Sheets

You can see the full list of available endpoint and parameters in the API documentation. For example, to get a list of the files in the root folder of your Dropbox account, run a request like this:

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodPOST
    • Request URLhttps://api.dropboxapi.com/2/files/list_folder
    • Headers:
      • AuthorizationBearer your_token
      • Content-Type: application/json
    • Request body: {"include_deleted":false,"include_has_explicit_shared_members":false,"include_media_info":false,"include_mounted_folders":true,"include_non_downloadable_files":true,"path":"","recursive":false}
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see a list of files populate your sheet.
The above request contains "path":"", indicating that it's fetching files from the root directory. To get files from a particular folder, replace the empty quotes with the folder's path.

Part 3: API Documentation

Official API documentation: https://www.dropbox.com/developers/documentation/http/documentation

Leave a Comment

Jump To