Set Field Autofill
sheet.set_autofillMake a field fill itself on an existing sheet, or stop it. source: ai writes from an instruction reading readFields (by name) — it uses AI credit, so tell the user (the result's note). source: formula computes the value from formula, with fields in braces ({Price} * {Quantity}). source: manual removes the field's autofill. Fields are named as sheet.schema lists them; an unknown name is refused with the valid ones.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| when | No | When it fills: `created` (new rows), `first_value` (once the named field gets a value) or `changed` (whenever the named fields change). Default: AI on created; a formula whenever the fields it reads change. | |
| field | Yes | Name (or code) of the field that fills itself. | |
| source | Yes | `ai` fills from an instruction, `formula` computes it, `manual` turns autofill off. | |
| formula | No | Formula only: fields in braces, e.g. `{Price} * {Quantity}`. | |
| sheetId | Yes | ||
| readFields | No | AI only: the fields the AI reads, by name. | |
| instruction | No | AI only: what to write into the field. | |
| keepUpdated | No | Also refill a value autofill wrote earlier (never a person's). Default: true for a formula, false for AI. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | Tell the user this (AI credit use) | |
| field | Yes | The field whose autofill was set | |
| source | Yes | What fills it now; manual = autofill removed | |
| workflowId | No | The autofill workflow |