跳转到内容

AI Sheet Formulas

此内容尚不支持你的语言。

AI Sheet Formulas brings AI directly into your grid so you can run structured prompts from regular sheet formulas.

Available Formulas

=AITASK(instruction, input_range, [refresh])
=AIPATTERN(example_range, target_range, [refresh])
=AIDRAFT(prompt, context_range, [refresh])
=AISPLIT(text, split_instruction, [refresh])
=AITABLE(prompt, [context_range], [refresh])

Before You Start

Open the add-on sidebar once and ensure you are signed in.
Use a checkbox cell (for example $Z$1) as the optional [refresh] argument to force recalculation when needed.
Use range-based formulas for batch tasks (for example A2:A200) instead of dragging one-cell formulas down.

Common Examples

=AITASK("Extract the primary domain from this email address", A2:A50, $Z$1)

=AIPATTERN(A2:B5, A6:A100, $Z$1)

=AIDRAFT("Write a short follow-up email based on this note:", C2:C20, $Z$1)

=AISPLIT(A2, "Split into First Name, Last Name, City", $Z$1)

=AITABLE("List the top 10 US cities by population with state and population", , $Z$1)

Limits and Notes

Formula names use AI... without dots (AITASK, not AI.TASK).
AISPLIT processes one cell per invocation.
AITABLE and AISPLIT spill into nearby cells; clear output space first to avoid #REF!.
Formula outputs are plain text. Use AI Agents for post-processing and formatting.

Troubleshooting

Error: Not authorized...: open the sidebar and sign in again.
Error: Range too large...: split the range into smaller batches.
#REF!: clear cells in the spill path.
#ERROR!: reduce range size and retry.

AI Agents Use sidebar-driven AI workflows for value updates, formatting, formulas, and filters.

Language & Settings Control AI permission behavior for add-on features.