Configure Google Sheets Accounts

Overview

You can configure your accounts in SnapLogic using the Designer or Manager. You can create a Google Sheets Account to connect to Google Sheets data sources in your Pipelines.

Snap-account compatibility

The Snaps in the Google Sheets Snap Pack work with different accounts per the following table:

Snaps Spreadsheet OAuth2 Account Spreadsheet Dynamic OAuth2 Account Google Sheets Google Sheets – Google Service Account
Spreadsheets Browser Tick Icon Tick Icon Tick Icon
Worksheet Reader Tick Icon Tick Icon Tick Icon
Worksheet Writer Tick Icon Tick Icon Tick Icon
Google Sheets Subscribe Tick Icon Tick Icon Tick Icon
Google Sheets Unsubscribe Tick Icon Tick Icon Tick Icon

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account:
  • High: Access token, Refresh token, Client secret.
  • Medium + High: Client ID.
  • Low + Medium + High: All account fields.

Related links

Spreadsheet OAuth2 Account

Spreadsheet Dynamic OAuth2 Account

Google Sheets – Google Service Account

Accounts