Overview

You can use this account type to connect Google Sheets Snaps with data sources that use Google Service Account.

Prerequisites

None.

Asterisk ( * ): Indicates a mandatory field.
Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.
Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the field set.
Remove icon ( ): Indicates that you can remove fields from the field set.

Field Name	Field Type	Description

Field Name

Field Type

Description

Label*

Default Value: Google Service Account
Example: Google Sheets - Service Account

String

Specify a unique label for the account.

JSON key*

Default Value: N/A
Example: root-beacon-429915-m9-12hj8jkln,.json

String/Expression

Specify the JSON key created for the service account. Learn how to create a JSON key.

Refresh the account if the Google Sheets Snaps display a 401 error.

Error	Reason	Resolution

Error	Reason	Resolution
`Failed to get the spreadsheet ID`	Found an empty ID.	Provide a unique name for the spreadsheet and retry.
`Spreadsheet not found`	The spreadsheet may not exist or cannot be accessed.	Verify if the spreadsheet exists and retry.