How to Set Up Detail Tasks?

Setting up detail tasks depends on whether you choose the output location as a single column or single 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: Next Column

• Process Each Row: Suppose you process each row and have one or more columns as input to process and want the result in another column.
• Examples:  Assume input range is Sheet!C3:G9, if output location is Next Column then Output Range is  Sheet!H3:H9 
  • Detail task: Generate an ad copy for a product title "col1". It will process each row below: 
  • Generate an ad copy for a product title "Animal 1".
  • Generate an ad copy for a product title "Lion".
  • Generate an ad copy for a product title "Kangaroo".
  • Generate an ad copy for a product title "Wolf".
  • etc
  • Detail task: Generate an ecommerce description for product title "col1", price: "col3" and category "col5". It will process each row below:  
    • Generate an ecommerce description for product title "Animal 1", price: "Animal 3" and category "Animal 5"
  • • Generate an ecommerce description for product title "Lion", price: "Elephant" and category "Zebra"
    • Generate an ecommerce description for product title "Kangaroo", price: "Koala" and category "Penguin"
    • etc

Output Location: Next Row

• Process Each Column: Suppose you process each column and  have one or more row as Input to process and want the result in another rows.
• Examples: Assume input range is Sheet!C3:G9, if output location is Next Row then Output Range is  Sheet!C10:G10
• Detail task: Generate an ad copy for a product title "row1". It will process each column below: .
• Generate an ad copy for a product title "Animal 1"
• Generate an ad copy for a product title "Animal 2".
• Generate an ad copy for a product title "Animal 3".
• Generate an ad copy for a product title "Animal 4".
• etc
• Detail task: Generate an ecommerce description for product title "row1", price: "row3" and category "row5". It will process each row below: 
• Generate an ecommerce description for product title "Animal 1", price: "Kangaroo" and category "Rhinoceros"
• Generate an ecommerce description for product title "Animal 2", price: "Panda" and category "Hippotamus"
• etc

As an alternative to using the relative index (based on input range selection), you can use the absolute index, which is based on the actual column or row name.

Explanation of Absolute vs. Relative Index

Relative Index(no space ) --> Recommended

Specifies the location of a cell relative to the starting point of the selected input range. This format adjusts if the data input 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.

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.

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.