Skip to main content

Set Cell Value

Sets the value of a specific cell in a Google Spreadsheet.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Spreadsheet Id - The ID of the Google Spreadsheet containing the cell to modify.
  • Cell - The cell reference (e.g., "A1", "B2") to set the value for.
  • Cell Value - The value to set in the specified cell.

Options​

  • Set as Formula - If enabled, the Cell Value will be treated as a formula rather than plain text.

Output​

No output variables for this node.

How It Works​

The Set Cell Value node updates the content of a specific cell in a Google Spreadsheet. When executed, the node:

  1. Validates all input parameters
  2. Connects to the Google Spreadsheet using the provided ID
  3. Processes the cell value, converting strings to numbers when appropriate
  4. Constructs a value range with the specified cell value
  5. Determines the appropriate value input option based on the Set as Formula option
  6. Sends an update request to set the cell value
  7. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • A valid cell reference in the format of a letter followed by a number (e.g., "A1", "B2")
  • A valid cell value
  • Proper Google Sheets API authentication and permissions

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid Spreadsheet Id
  • Empty or invalid Cell reference
  • Empty or invalid Cell Value
  • Invalid cell reference format
  • Google Sheets API authentication or permission errors
  • Network or connectivity issues with Google Sheets API

Usage Notes​

  • The Spreadsheet Id can be obtained from the URL of your Google Spreadsheet or from the Open Spreadsheet node
  • Cell references should follow the standard Google Sheets format (e.g., "A1", "B2", "Z100")
  • When Set as Formula is enabled, the value will be treated as a formula (e.g., "=SUM(A1:A10)")
  • When Set as Formula is disabled, the value will be written as literal text or number
  • String values that can be parsed as numbers will be automatically converted
  • This operation modifies the spreadsheet data, so use with caution
  • Ensure your Google account has proper permissions to modify the target spreadsheet