Skip to main content

Get Cell Value

Retrieves the value of a specific cell from 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 from which to retrieve the cell value.
  • Cell - The cell reference (e.g., "A1", "B2") to get the value from.

Options​

No additional options available for this node.

Output​

  • Cell Value - The value of the specified cell in the spreadsheet.

How It Works​

The Get Cell Value node retrieves the value of a specific cell from a Google Spreadsheet. When executed, the node:

  1. Validates the provided Spreadsheet Id and Cell inputs
  2. Connects to the Google Spreadsheet using the provided ID
  3. Constructs a range reference for the specified cell
  4. Retrieves the value of the specified cell using the Google Sheets API
  5. Sets the retrieved value to the output variable
  6. 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")
  • 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
  • The specified cell does not exist in the spreadsheet
  • 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
  • Cell references should follow the standard Google Sheets format (e.g., "A1", "B2", "Z100")
  • The retrieved cell value will be stored in the "Cell Value" output variable
  • Ensure your Google account has proper permissions to read from the target spreadsheet
  • If the cell is empty, the output variable will contain an empty string