Google Sheets Write
Write and update data in Google Sheets programmatically
Node Type
Action
Category
Google Sheets Integration
Icon
Google Sheets
Overview
The Google Sheets Write node allows you to write, update, and append data to Google Sheets programmatically. This powerful automation tool integrates with Google Sheets API to provide intelligent data management capabilities for your workflows.
Key Features
- • Flexible Data Writing: Write to specific ranges, append rows, or update cells
- • Batch Operations: Handle multiple updates efficiently
- • Data Validation: Ensure data integrity before writing
- • 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
The unique identifier of the Google Spreadsheet (found in the URL).
range
The A1 notation range to write to (e.g., 'Sheet1!A1:D10', 'Data!A1').
values
The data to write as a 2D array. Each inner array represents a row of data.
Optional Fields
valueInputOption
How values should be interpreted. RAW: Values are stored as-is. USER_ENTERED: Values are parsed as if typed by user (formulas, dates, etc.).
Examples & Use Cases
Write Simple Data
Write data to a specific range
{
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A1:B3",
"values": [
["Name", "Age"],
["John", 30],
["Jane", 25]
],
"valueInputOption": "RAW"
}Writes a simple table with headers and two data rows.
Write Formulas
Write data including formulas and dates
{
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Calculations!A1:C2",
"values": [
["Value 1", "Value 2", "Sum"],
[10, 20, "=A2+B2"]
],
"valueInputOption": "USER_ENTERED"
}Uses USER_ENTERED to allow formulas to be interpreted. The SUM formula will calculate automatically.
Append Workflow Data
Log workflow results to a spreadsheet
{
"spreadsheetId": "{{workflowSettings.loggingSheetId}}",
"range": "Logs!A:E",
"values": [
[
"{{workflow.timestamp}}",
"{{workflow.id}}",
"{{currentNode.status}}",
"{{currentNode.output}}",
"{{user.email}}"
]
]
}Appends workflow execution data to a logging sheet using template variables.
Data Export Workflow
Export processed data to Google Sheets
Workflow Structure
Read data from API, process/transform it, write to Google Sheets for reporting and analysis.
Best Practices
Do's
- • Use USER_ENTERED for formulas and dates
- • Use RAW for literal text values
- • Check the success field before proceeding
- • Validate data structure before writing
- • Use specific ranges for targeted updates
- • Monitor updatedCells for confirmation
Don'ts
- • Don't write without checking write permissions
- • Avoid writing very large datasets at once
- • Don't forget to handle the Error field
- • Avoid overwriting important data without backups
- • Don't use RAW when you need formulas interpreted
- • 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.
Range Too Small
Symptoms: Data doesn't fit in specified range or truncated
Solution: Ensure your range is large enough for the data array. The number of rows/columns in values should match the range dimensions. Consider using an open-ended range like 'Sheet1!A1'.
Formulas Not Working
Symptoms: Formulas appear as text instead of calculating
Solution: Use valueInputOption: 'USER_ENTERED' to have formulas interpreted and calculated. RAW mode will treat formulas as literal text.
Data Format Issues
Symptoms: Dates or numbers appear incorrectly formatted
Solution: Use USER_ENTERED mode for proper type interpretation. Check that your data array structure is valid (2D array with consistent row lengths).