Read cell formula action

The Read cell formula action in the Google Sheets package enables you to retrieve the formula available in the Active cell or Specific cell and assign the output to a string variable. This action returns a blank value if the specified cell does not contain a formula.

Settings

  • Enter the name of the session that you used to open the workbook with the Open spreadsheet action
  • Select the Active cell or Specific cell option to specify the cell from which to read the formula.
    Note: If you have selected the Specific cell option, specify the address of the cell in the field.
  • In the Assign the output to variable field, select a string variable to store the name of the formula. The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.