Skip to content

Set Formula Activity

The Set Formula activity allows users to write a specific Google Sheets formula into a designated cell or range. This activity is essential for performing dynamic calculations, data lookups, or conditional operations directly within a cloud-based spreadsheet during an automation workflow.

Field Description Requirement
Google sheet name The reference name of the Google Sheets connection or instance to be used. Required
Sheet name The specific name of the worksheet (tab) within the spreadsheet where the formula will be applied. Optional
Range The target cell address (e.g., "A1") or range (e.g., "B2:B10") where the formula will be inserted. Required
Formula The Google Sheets formula string to be executed (e.g., "=SUM(A1:A10)"). Required

Action Types & Examples

Applying Mathematical Functions

  • Format: =SUM(B2:B20)
  • Example Result: The cell displays the total sum of the specified range.

Logical Operations

  • Format: =IF(C2>100, "High", "Low")
  • Example Result: The cell evaluates the condition and displays the corresponding text label.

Implementation Examples

Field Setup

  • Google sheet name: FinanceSpreadsheet
  • Sheet name: Q1_Results
  • Range: D15
  • Formula: =AVERAGE(C2:C14)

Execution Parameters

  • Target Instance: FinanceSpreadsheet
  • Data Write: The AVERAGE function is active in cell D15 of the Q1_Results worksheet.

Technical Notes

All formulas must begin with an equals sign (=). If the Sheet name is left blank, the activity will attempt to write the formula to the first available or active sheet in the spreadsheet instance.