Credentials
      Back to home
      1. Knowledge Base
      2. Connect & Transform
      3. Credentials

      Google Sheets Credentials

      Credential Configuration

      To make a Google Sheets connection, the following credentials are needed:

      Field Name

       

      Required/ Optional

       

      Description

       

      Type

      Required

      Google Sheets

      Name

      Required

      Provide a unique name for this credential

      Access Token

      Optional

      Leave blank

      Refresh Token

      Optional

      Leave blank

      Connection Steps

      After all fields are filed in, click Connect to Google.

      Google Sheets Cred 1

      Enter Google credentials and/or select a Google account to connect with.

      Google Sheets Cred 2
      Users will be taken to an access screen. Click Advanced and then click Go to datablend.com. 

      Users will then be redirected to the Google Sign in page. Click Continue to connect the Credential. 

      Users will be redirected to DataBlend and the Access Token and Refresh Token fields will be populated.

      Folder, Corpora, and Drive Selection

      Upon a valid connection, DataBlend users will have the options to select a Folder, a Corpora, or to Include Items From All Drives.