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.
π‘ Use Cases
- Log workflow execution results
- Collect form submissions
- Track metrics and KPIs
π 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.