Google Sheets (Service Account) icon

Google Sheets (Service Account)

Access Google Sheets API using Service Account

Actions11

Row → Get

AI-generated

Overview

This node allows users to interact with Google Sheets using a Service Account for authentication. Specifically, the 'Row - Get' operation retrieves data from specified rows within a sheet in a Google Spreadsheet. It is useful for scenarios where you need to read data from a Google Sheet programmatically, such as fetching records for processing, reporting, or integration with other systems.

Use Case Examples

  1. Retrieve rows from a sales data sheet to generate a report.
  2. Fetch user information stored in a Google Sheet for further processing in a workflow.

Properties

Name Meaning
Authentication Choose the authentication method: use saved credentials or enter service account details manually.
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 from the service account JSON used for authentication (required if manual authentication is selected).
Impersonate Email (Optional) Email of the user to impersonate, requiring domain-wide delegation (optional, manual authentication only).
Spreadsheet ID The ID of the Google Spreadsheet from which to retrieve rows.
Sheet Name The name of the sheet within the spreadsheet to read rows from.
Range The range of cells to read from the sheet, e.g., A:Z or A1:D10.

Output

JSON

  • json
    • spreadsheetId - The ID of the spreadsheet from which rows were retrieved.
    • range - The range of cells that were retrieved.
    • majorDimension - The major dimension of the returned data (ROWS or COLUMNS).
    • values - The array of values retrieved from the specified range in the sheet.

Dependencies

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

Troubleshooting

  • Ensure the service account has access to the target spreadsheet, otherwise authorization errors will occur.
  • If using manual authentication, verify the private key format is correct and newline characters are properly handled.
  • Check that the specified sheet name and range exist in the spreadsheet to avoid 'Sheet not found' or empty data errors.
  • If impersonation is used, ensure domain-wide delegation is properly configured for the service account.

Links

Discussion