Skip to main content

Format Range

Formats a range of cells in a Google Spreadsheet with a specific number format.

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​

  • Spread Sheet Id - The ID of the Google Spreadsheet where the formatting will be applied.
  • From Cell - The starting cell of the range to format (e.g., "A1").
  • To Cell - The ending cell of the range to format (e.g., "Z100").

Options​

  • Format - The number format to apply to the cell range:
    • Number - Formats cells as numbers
    • Date - Formats cells as dates
    • Time - Formats cells as time
    • Date Time - Formats cells as date and time
    • Text - Formats cells as plain text

Output​

No output variables for this node.

How It Works​

The Format Range node applies a specific number format to a range of cells in a Google Spreadsheet. When executed, the node:

  1. Validates all input parameters
  2. Connects to the Google Spreadsheet using the provided ID
  3. Converts the cell references to grid coordinates
  4. Constructs a repeat cell request with the specified format
  5. Sends the formatting request to the Google Sheets API
  6. Returns any errors encountered during the process

Requirements​

  • A valid Google Spreadsheet ID
  • Valid cell references for the range (From Cell and To Cell)
  • A format selection from the available options
  • 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 From Cell reference
  • Empty To Cell reference
  • No format selected
  • Invalid cell references
  • 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
  • Both From Cell and To Cell must be specified to define the range
  • The format is applied to all cells within the specified range
  • This operation modifies the formatting of the spreadsheet data, but not the actual data
  • Ensure your Google account has proper permissions to modify the target spreadsheet