Google Sheets - Google Service Account

In this article

Overview

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

Prerequisites

Limitations and Known Issues

None.

Account Settings

google-service-account.png
  • 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.

The account must be refreshed if the Google Sheets Snaps display a 401 error.

Troubleshooting

Error

Reason

Resolution

Error

Reason

Resolution

Failed to get the spreadsheet ID

Found an empty ID.

Provide a unique name for the spreadsheet and try again.

Spreadsheet not found

The spreadsheet may not exist or cannot be accessed.

Verify if the spreadsheet exists and retry.


Related Content: