Google Sheet
Update Sheet
Update existing data in Google Sheets
Update Sheet
The Update Sheet node allows you to modify existing data in Google Sheets documents.
Overview
This node enables you to:
- Update specific cells or ranges
- Modify multiple ranges at once
- Update formatting and formulas
- Clear cell contents
- Batch update operations
Configuration
Parameter | Type | Description |
---|---|---|
Spreadsheet ID | String | The ID of the Google Sheet |
Range | String | Range to update (e.g., ‘Sheet1!A1:D10’) |
Values | Array | New values to update |
Value Input Option | String | How to interpret input (RAW/USER_ENTERED) |
Include Format | Boolean | Whether to update cell formatting |
Authentication
This node requires:
- Google Cloud Project
- Google Sheets API enabled
- Service account or OAuth2 credentials
- Write access to the spreadsheet
Output
The node returns:
- Number of cells updated
- Updated range
- Success/failure status
- Error messages if operation fails