In this article

This account is used by the Snaps in the Google Sheets Snap Pack.

You will need to use a Google Account that has access to the Google API Admin Role.


In this section

You can create an account from Designer or Manager. In Designer, when working on pipelines, every Snap that needs an account prompts you to create a new account or use an existing account. The accounts can be created in or used from:

  • Your private project folder: This folder contains the pipelines that will use the account.
  • Your Project Space’s shared folder: This folder is accessible to all the users that belong to the Project Space.
  • The global shared folder: This folder is accessible to all the users within an organization in the SnapLogic instance.


Account Configuration

In Manager, you can navigate to the required folder and create an account in it (see Accounts). To create an account for Google Sheet: 

  1. Click Create, then select Google Sheets, then Google Dynamic OAuth2 or Spreadsheet Basic Auth Account.

    • Google OAuth2:

      • Supply an account label.
      • Click Authorize. You will be asked to log into a Google account. Log in with your user credentials, and after successfully logging in, you will be asked to provide permission for access. Access is required to make a connection.

      • Click Apply.

    • Google Dynamic OAuth2:

      • Provide a valid access token to make requests against OAuth2 enabled endpoints. 

  2. (Optional) Supply additional information on this account in the Notes field of the Info tab.

Avoid changing account credentials while pipelines using them are in progress. This may lead to unexpected results, including locking the account.

Known Issue

While authorizing accounts, force approval prompts you to request a new refresh token.

Account encryption

Standard Encryption

If you are using Standard Encryption, the High sensitivity settings under Enhanced Encryption are followed.

Enhanced Encryption

If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected per each account.

  • High:
  • Medium + High:
  • Low + Medium + High