Skip to main content

Google Drive

Setting up a connection with Google Drive

Updated over 6 months ago

Summary

This document explains the steps needed to prepare your Google Drive environment for a dScribe connection. dScribe uses a Service Account provided by Google Cloud Platform.

This connector can be used to automatically crawl all CSV and Excel files from selected Google Drive folders.

Step-by-step guide

  1. Navigate to Google Cloud Platform and log in with a user with Admin permissions.

  2. Create a new project:

  3. Create a Service Account in your project via Menu > 'IAM & Admin' > 'Service Accounts':

    Enter a name and continue.

    Select role 'Owner' or 'Viewer':

    Click done.

    Save your Service Account email adress, you'll need it later:

  4. Create a privateKey for your Service Account: Click on your Service Account name > KEYS > Add Key > Create a new key:

    Keep Key Type = JSON. When you click on 'Create', a file will be downloaded with your privateKey.

  5. The privateKey needs to be base64 encoded:

    You can do this by going to base64encode.org. Paste your privateKey and click on encode.

    Save your encoded privateKey somewhere safe, you'll need it later.

  6. Enable Google Drive API on the project that you want to use.

    In your menu bar, you can find 'API & Services' > 'Library'. On this page you can search for the Google Drive API and enable it.

  7. Go to your Google Drive and choose the folders you want to connect. You'll have to share these folders with your Service Account. This is the Service Account email adress you saved earlier. Set the access permissions to 'Editor' or 'Reader'.

  8. Using the email adress of your Service Account and the base64 encoded Private key, you can now create a new Source in dScribe.

Reached the end? Congratulations! You’re a star!

Did this answer your question?