/
Google Sheets – Google Service Account

Google Sheets – Google Service Account

Owned by Lakshmi Manda, created
Last updated: Jan 09, 2025 by Kalpana Malladi
2 min read

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.

For enhanced security, you can store your JSON key in a secret vault and pass it in this field.

How to use the Google Service Account to read and write data from Google Sheets

To read and write data in Google Sheets that belong to a user within your organization, you can use the Google Service Account. Here are the steps to configure:

  1. Get the Service Account email.

    1. In the Details tab of your Service Account, locate the Email field. The format is: your-service-account-name@your-project-id.iam.gserviceaccount.com.

  2. Share the Spreadsheet.

    1. Open the Google Sheet in your browser.

    2. Click the Share button.

    3. Enter the Service Account email address.

    4. Set the permission to Editor if you need write access or Viewer if you need only read access.

    5. Click Send.

Learn more: How to Access Google Sheets Data Using a Service Account.

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 retry.

Spreadsheet not found

The spreadsheet may not exist or cannot be accessed.

Verify if the spreadsheet exists and retry.

Related Content:

Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2025 SnapLogic, Inc.