Google Sheets Append Row
Append a single row of data to a Google Sheet
Node Type
Action
Category
Google Sheets Integration
Icon
Google Sheets
Overview
The Google Sheets Append Row node allows you to append a single row of data to a Google Sheet. This powerful automation tool integrates with Google Sheets API to provide intelligent data management capabilities for your workflows.
Key Features
- • Single Row Appending: Add one row of data at a time to your sheets
- • Flexible Range Support: Append to specific sheets or ranges
- • Data Validation: Ensure data integrity before appending
- • Real-time Updates: Changes appear instantly in your sheets
- • Error Handling: Built-in success/failure tracking
Prerequisites
Google Integration
Must be connected to access Google Sheets API
Required Scopes
The following OAuth scopes are required for this node to function properly
Node Configuration
Required Fields
spreadsheetId
ID of the spreadsheet to append to. Can be selected using the Google Drive picker or manually entered.
range
Sheet name or A1 notation (e.g., 'Sheet1' or 'Sheet1!A:D'). For append operations, simple sheet names like 'Sheet1' are recommended.
rowData
Array of values for the new row (JSON array format). Each element can be a string, number, or formula.
Examples & Use Cases
Append Simple Data Row
Append a single row of data to a sheet
{
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1",
"rowData": ["John Doe", "[email protected]", "Engineer", "2024-01-15"]
}Appends a single row with employee information to the end of Sheet1.
Append with Formulas
Append a row containing formulas and calculated values
{
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Calculations!A:D",
"rowData": ["Product A", 100, 15, "=B2*C2"]
}Appends a row with product data including a formula to calculate total cost.
Log Workflow Results
Append workflow execution data to a logging sheet
{
"spreadsheetId": "{{workflowSettings.loggingSheetId}}",
"range": "Logs!A:E",
"rowData": [
"{{workflow.timestamp}}",
"{{workflow.id}}",
"{{currentNode.status}}",
"{{currentNode.output}}",
"{{user.email}}"
]
}Appends workflow execution data to a logging sheet using template variables.
Data Collection Workflow
Collect form data and append to Google Sheets
Workflow Structure
Collect form submissions, process the data, and append each submission as a new row in Google Sheets for data collection and analysis.
Best Practices
Do's
- • Use simple sheet names (e.g., 'Sheet1') for the range parameter
- • Ensure rowData is a valid JSON array format
- • Check the success field before proceeding
- • Validate data structure before appending
- • Use specific sheet names for targeted appending
- • Monitor appendedRange for confirmation
Don'ts
- • Don't append without checking write permissions
- • Avoid appending very large data arrays
- • Don't forget to handle the Error field
- • Avoid appending to protected ranges
- • Don't use complex A1 notation for ranges
- • Avoid hardcoding spreadsheet IDs
Troubleshooting
Common Issues
Permission Errors
Symptoms: Node fails with insufficient permissions
Solution: Ensure your Google account connection has write scope and that you have edit access to the spreadsheet. Check that the spreadsheet is shared with edit permissions.
Invalid Range Format
Symptoms: Node fails with range format errors
Solution: Use simple sheet names like 'Sheet1' for best results. If you use A1 notation like 'Sheet1!A:D', the node will automatically convert it to just the sheet name 'Sheet1' for the append operation.
Data Format Issues
Symptoms: Row data doesn't append correctly or appears malformed
Solution: Ensure rowData is a valid JSON array format. Each element should be a string, number, or formula. Check that your data structure matches the expected column layout.
Empty or Missing Data
Symptoms: Row appears empty or missing data
Solution: Verify that rowData contains the expected number of values and that none are null or undefined. Use template variables carefully to ensure they resolve to actual values.