Sheets Enrich
sheets_enrichFill empty cells in one column of an editable sheet through paid web research using each row's existing context. Use sheets.research to create new result rows, or sheets.start_enrichment for explicit multi-column targets or requested replacement of existing values. Use an existing columnId with its configured question/type, or supply a new column name, question and type. Omit rowIds only when the user requests all existing rows (up to 10,000); otherwise pass the requested row IDs. Existing values and active cells are skipped. A new column is persisted before research starts. Consumes the workspace's existing Leadbase credits; completed usage cannot be undone. Returns accepted runs, not finished results. Read sheets.get_enrichment_status for progress and settled costs, then sheets.query for saved values and sources. After an interrupted response, reuse the same idempotencyKey and unchanged arguments; never use a fresh key to retry an uncertain start.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | ||
| rowIds | No | Stable IDs of the rows the user requested. Omit only for a request covering all existing rows (up to 10,000). | |
| sheetId | Yes | ||
| idempotencyKey | Yes | Stable key for this paid request. Reuse with identical arguments after an interrupted response; a new key creates a separate operation. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runs | Yes | ||
| executions | Yes | ||
| skippedCellCount | Yes | ||
| startedCellCount | Yes | ||
| requestedCellCount | Yes |