πŸš€ More Vendrato tools: FunnelDupe β€’ GHL Utils
πŸ“

Append Row to Google Sheets

n8n-nodes-base.googleSheets

Add new rows to Google Sheets with automatic formatting and data validation. Perfect for logging and data collection.

google-sheets spreadsheet logging data-collection
App Google Sheets
Category data processing
Version 1.0.0
Author Community
Credentials Google Sheets OAuth2

πŸ’‘ Use Cases

πŸ“‹ Node Configuration

{
  "nodes": [
    {
      "parameters": {
        "content": "## πŸ“ Google Sheets Append\n\n**Usage:**\nAdds new rows to a Google Sheets spreadsheet.\n\n**Required Input:**\n- `name`: Name value to append\n- `email`: Email value to append\n- `status`: Status value to append\n- `notes`: Notes value to append\n\n**Setup:**\n1. Configure Google Sheets OAuth2 credentials\n2. Set document ID and sheet name\n3. Map incoming data to columns\n\n**Output:**\nConfirmation of appended row with spreadsheet metadata",
        "height": 238,
        "width": 389,
        "color": 4
      },
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        332
      ],
      "typeVersion": 1,
      "id": "sticky-c4b3a2d1-e5f6-4a5b-8c9d-0e1f2a3b4c5d",
      "name": "Sticky Note"
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "1ABC-XYZ-SPREADSHEET-ID",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": "Sheet1",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "Timestamp": "={{ $now.format('yyyy-MM-dd HH:mm:ss') }}",
            "Name": "={{ $json.name }}",
            "Email": "={{ $json.email }}",
            "Status": "={{ $json.status }}",
            "Notes": "={{ $json.notes }}"
          }
        },
        "options": {}
      },
      "id": "c4b3a2d1-e5f6-4a5b-8c9d-0e1f2a3b4c5d",
      "name": "Append to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.2,
      "position": [
        368,
        400
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "GoogleSheetsCred123",
          "name": "Google Sheets Account"
        }
      }
    }
  ],
  "connections": {},
  "pinData": {},
  "meta": {
    "templateCredsSetupCompleted": true,
    "instanceId": "751aeba95f3d1aebe5a6ebe9d20293dd6c0f61b00ef369c580f0dc54913f5fcb"
  }
}
BuildShip configuration not available for this node.
Make.com configuration not available for this node.
← Browse all nodes