How it works
- Find the data. Use the Query data operations to pick a source table and its columns.
- Save a slice.
create_worksheetcopies up to 10,000 filtered or sampled rows (and linked conversations) into a worksheet. The source table is unchanged. - Add AI columns.
enrich_worksheetadds columns that classify, score or extract from each row’s conversation. It returns a job id right away. - Wait for results.
get_enrich_statusreports progress until it returnsdone: true;done: falsemeans still running, not failed. The new columns can then be read, filtered and aggregated like any other. - Export.
export_worksheetwrites chosen columns to a CSV file and returns a download link.
Example
Which of last month’s Zendesk tickets were about billing, and how angry was the customer?
list_data_sourceswithprovider: "zendesk"→ the ticket table id.create_worksheetwith awhereon the created date andsampleRows: 500.enrich_worksheetwith two columns:topicas an enum,frustrationas an integer from 1 to 5.get_enrich_statusuntildone: true.aggregate_tableon the worksheet, grouped bytopic, averagingfrustration.
Good to know
- Columns requested in one
enrich_worksheetcall are filled in a single LLM call per row. Request related columns together. - Only rows already on the worksheet are enriched.
export_worksheetexports every row matchingwhere, not what’s filtered on screen.- A CSV uploaded with the Rippit CLI lands as a worksheet too.