Google Sheets (Service Account) icon

Google Sheets (Service Account)

Access Google Sheets API using Service Account

Actions11

Sheet → Append

AI-generated

Overview

This node allows appending data to a specific sheet within a Google Sheets spreadsheet using a Google Service Account for authentication. It supports both saved credentials and manual entry of service account details. The node is useful for automating data entry tasks, such as adding new rows or data arrays to existing sheets in a spreadsheet, which is common in workflows involving data collection, reporting, or integration with other systems.

Use Case Examples

  1. Appending sales data to a monthly report sheet in a Google Sheets spreadsheet.
  2. Adding new user information rows to a customer database sheet automatically after form submissions.

Properties

Name Meaning
Authentication Choose the authentication method to use, either saved credentials or manual entry of service account details.
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, used for authentication (required if manual authentication is selected).
Impersonate Email (Optional) Email of a user to impersonate when making API calls, requires domain-wide delegation (optional).
Spreadsheet ID The unique identifier of the Google Sheets spreadsheet where data will be appended.
Sheet Name The name of the sheet within the spreadsheet to which data will be appended.
Data The data to append, provided as a JSON array of arrays, where each inner array represents a row of values to add to the sheet.

Output

JSON

  • json
    • spreadsheetId - The ID of the spreadsheet where data was appended.
    • updates - Details about the update operation, including the range and number of cells updated.

Dependencies

  • Google Sheets API
  • Google Service Account credentials

Troubleshooting

  • Ensure the service account has the necessary permissions to access and edit the target spreadsheet.
  • Verify that the spreadsheet ID and sheet name are correct and exist in the Google Sheets document.
  • If using manual authentication, confirm that the private key is correctly formatted and includes proper newline characters.
  • Check that the data provided is a valid JSON array of arrays; invalid JSON will cause parsing errors.
  • If impersonation is used, ensure domain-wide delegation is properly configured for the service account.

Links

Discussion