Setting up detail tasks depends on whether you choose the output location as a column or row.

Note: We don't use all the data you select in the input range for the AI response. We only use the selected cell data you define using an absolute or relative index as a prompt to the AI provider.

Output Location: Column

  • Process Each Row: Use absolute and relative indexes for columns.
  • Examples:
    1. Absolute Index: "Create a Google ad copy for a product title: [col A] with pricing: [col B]."
    2. Relative Index: "Generate a summary for each product in col1."
    3. Relative Index: "Categorize products based on description in col2."
    4. Absolute Index: "Translate product details from [col D]."

Output Location: Row

  • Process Each Column: Use absolute and relative indexes for rows.
  • Examples:
    1. Relative Index: "Categorize products based on description in row3."
    2. Absolute Index: "Categorize products based on description in [row 4]."

Explanation of Absolute vs. Relative Index

Absolute Index(with space inside [])

Specifies the exact location of a cell using its column and row labels. This format remains constant, regardless of changes in the data range.

  • Format: [col A], [row 1]
  • Example: [col A] refers to column A, [row 1] refers to row 1.

Relative Index(no space )

Specifies the location of a cell relative to the starting point of the selected input range. This format adjusts if the data range changes.

  • Format: colX, rowX, where X is the number. Example: col1, row1
  • Example: col1 refers to the first column in the selected input range, row1 refers to the first row in the selected input range.

Valid Index Formats

  • Relative Index: col1, row1
  • Absolute Index: [col A], [row 1]

Ensure your relative or absolute indexes do not exceed or fall outside the input range.

Sample Input Range vs. Valid and Invalid Index Format

Scenario 1

  • Input Range: Data!A1:B10
    • Valid Index: col1, row1, [col A], [row 1]
    • Invalid Index:
      • Absolute: [col C] (Column C is outside the range), [row 11] (Row 11 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row11 (Row 11 is outside the range)

Scenario 2

  • Input Range: Data!C5:D20
    • Valid Index: col1, row1, [col C], [row 5]
    • Invalid Index:
      • Absolute: [col E] (Column E is outside the range), [row 21] (Row 21 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row16 (Row 16 is outside the range)

Scenario 3

  • Input Range: Sheet1!E1:F15
    • Valid Index: col1, row1, [col E], [row 1]
    • Invalid Index:
      • Absolute: [col G] (Column G is outside the range), [row 16] (Row 16 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row16 (Row 16 is outside the range)

Scenario 4

  • Input Range: Sheet2!G10:H30
    • Valid Index: col1, row1, [col G], [row 10]
    • Invalid Index:
      • Absolute: [col I] (Column I is outside the range), [row 31] (Row 31 is outside the range)
      • Relative: col3 (Column 3 is outside the range), row22 (Row 22 is outside the range)

Scenario 5

  • Input Range: Data!A1:C5
    • Valid Index: col1, row1, [col A], [row 1]
    • Invalid Index:
      • Absolute: [col D] (Column D is outside the range), [row 6] (Row 6 is outside the range)
      • Relative: col4 (Column 4 is outside the range), row6 (Row 6 is outside the range)

Ensure your relative index in detail tasks such as col1, row1 or absolute index such as [col A], [row 1] does not exceed or fall outside the input range. For further assistance, please contact our support team.