Google Sheets (Service Account) icon

Google Sheets (Service Account)

Access Google Sheets API using Service Account

Actions11

Row → Append

AI-generated

Overview

This node allows appending new rows of data to a specified 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 records or logs to a spreadsheet without manual intervention.

Use Case Examples

  1. Appending sales data rows to a monthly sales report sheet.
  2. Adding new user sign-up information to a Google Sheet for further processing.

Properties

Name Meaning
Authentication Choose the authentication method to access the Google Sheets API, either using 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 from the service account JSON used for authentication (required if manual authentication is selected).
Impersonate Email (Optional) Optional email address of a user to impersonate, requiring domain-wide delegation (used only with manual authentication).
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 where the new rows will be appended.
Data The data to append, provided as a JSON array of arrays, where each inner array represents a row of values.
Options Additional options for appending data, including how the input data should be interpreted (raw or user-entered).

Output

JSON

  • json
    • spreadsheetId - The ID of the spreadsheet where data was appended.
    • tableRange - The range of cells that were updated by the append operation.
    • updates
      * updatedRows - The number of rows that were appended.
      * updatedColumns - The number of columns that were appended.
      * updatedCells - The total number of cells that were updated.

Dependencies

  • Google Sheets API
  • Google Service Account credentials

Troubleshooting

  • Ensure that the service account email and private key are correctly provided and formatted, especially when using manual authentication.
  • Verify that the service account has the necessary permissions to access and edit the specified spreadsheet.
  • If impersonation is used, confirm that domain-wide delegation is properly configured for the service account.
  • Common error: 'Sheet not found' occurs if the specified sheet name does not exist in the spreadsheet; verify the sheet name spelling and existence.
  • Errors related to authentication usually indicate missing or invalid credentials; check the credentials setup in n8n or manual input.

Links

Discussion