Google Sheets (Service Account) icon

Google Sheets (Service Account)

Access Google Sheets API using Service Account

Actions11

Spreadsheet → Get

AI-generated

Overview

This node allows users to interact with Google Sheets using a Service Account for authentication. Specifically, the 'Get' operation under the 'Spreadsheet' resource retrieves the metadata and details of a specified Google Spreadsheet by its ID. This is useful for scenarios where you need to fetch spreadsheet information such as its properties, sheets, and other metadata without manual API calls. For example, it can be used to verify spreadsheet existence, inspect its structure, or prepare for further data operations.

Use Case Examples

  1. Retrieve metadata of a Google Spreadsheet by providing its Spreadsheet ID to confirm its structure before processing data.
  2. Use the node to fetch spreadsheet details in an automated workflow that manages multiple spreadsheets.

Properties

Name Meaning
Authentication Choose the authentication method to access Google Sheets API, either using saved credentials or manual entry.
Service Account Email The email address of the Google service account used for authentication (required if manual authentication is selected).
Private Key The private key associated with the service account for authentication (required if manual authentication is selected).
Impersonate Email (Optional) Optional email address to impersonate a user, requiring domain-wide delegation (used only with manual authentication).
Spreadsheet ID The unique identifier of the Google Spreadsheet to retrieve.

Output

JSON

  • json - The JSON object containing the retrieved spreadsheet metadata and details as returned by the Google Sheets API.

Dependencies

  • Google Sheets API via googleapis library
  • Service Account credentials for authentication

Troubleshooting

  • Ensure the provided Spreadsheet ID is correct and accessible by the service account.
  • If using manual authentication, verify the service account email and private key are correctly entered and valid.
  • Check that the service account has the necessary permissions to access the spreadsheet.
  • Common error: 'No credentials provided' - occurs if no credentials are selected or entered; resolve by selecting saved credentials or entering manual credentials.
  • If impersonation is used, ensure domain-wide delegation is properly configured.

Links

Discussion