AI Dataset Enricher - Bulk LLM Classify, Tag & Summarise

Run one AI prompt over every row of an Apify dataset, CSV/Excel/JSON file or pasted rows: classify, tag, score sentiment, summarise, translate or extract into typed fields you define. Cheap LLM via Apify's OpenRouter, billed at cost to your account. $0.70 per 1,000 rows plus tokens.

Run one AI prompt over every row of your data, in bulk. Point it at an Apify dataset (reviews, jobs, leads, products, posts, tickets…), a CSV, Excel or JSON file or rows pasted as JSON, write what you want in plain English ("Classify the review's sentiment and main topic", "Write a 20-word summary", "Translate to English", "Extract seniority and remote/on-site", "Score this lead 1-10 for B2B SaaS fit"), list the output fields you want (or give a JSON Schema), and get every row back with new, typed columns (numbers, booleans and lists are converted). It sends only the fields you choose, retries a bad reply once, caps the AI spend per run, and can estimate the cost first without calling the model. Use it for bulk sentiment analysis, text classification and tagging, lead scoring and qualification, data cleaning and normalisation, summarisation, translation, entity extraction and categorising products, inside Apify pipelines or from Make, n8n, Zapier and AI agents. Default model Google Gemini 2.5 Flash Lite; any OpenRouter model works (GPT-5 nano, GPT-4o mini, Gemini 2.5 Flash, Claude, Llama, Mistral…). $0.70 per 1,000 rows plus the AI tokens at cost.

Two lines on your bill (please read)

1. This actor's fee: row-processed, $0.0007 per row the model successfully enriched. Rows that fail, empty rows and status rows are free.
2. AI tokens, billed directly to your own Apify account by Apify's official OpenRouter actor at OpenRouter's rates (the run calls it with your run's own token; there is no extra API key and nothing is marked up by us). With the default model a short row (a review or a job title) costs about $0.00002–0.0001 in tokens on a paid Apify plan. On the Apify free plan, Apify charges AI tokens at 10× the OpenRouter rate, plus a tiny per-call start fee.

Every row shows its own _inputTokens, _outputTokens and _llmCostUsd (the estimated token charge on your account, with the 10× free-plan rate applied when it applies), and the run summary totals them. maxLlmCostUsd (default $0.10) is a hard cap on the token side: each row's worst case is reserved before the call and the run stops cleanly before passing it. Every call also has a max_tokens limit. The run's maximum total charge caps this actor's own fee. If the AI service is unavailable or your account has no credit left, you get one free row explaining what happened, and the run still succeeds.

What data does it return?

Every run outputs clean, schema-validated rows like these:

text	sentiment	topic	_status	_inputTokens	_outputTokens	_llmCostUsd
Great product, slow delivery	negative	delivery	ok	98	14	0.00015
Five stars, arrived next day	positive	delivery	ok	97	13	0.00015

How much does it cost?

Transparent pay-per-event pricing — you only pay for what you get, and the actor always respects your run budget: set a maximum total charge and it stops cleanly at the cap instead of overrunning.

Event	Price	Charged	Worked example
row-processed	$0.0007	per row successfully enriched by the model (failed, empty and skipped rows are free)	10,000 reviews classified = $7.00 (+ AI tokens on your account, ≈ $0.50 on a paid plan with the default model)
apify-actor-start	$0.00005	per run per GB of memory (platform start fee)	One run at 0.5 GB = $0.000025

Input options

Field	Type	Required	Default	Description
rows	array	no	—	Rows pasted as a JSON array of objects. You can also (or instead) pick a dataset or give a file URL below.
datasetId	string	no	—	An Apify dataset to enrich, e.g. the output of a reviews, jobs or leads scraper. Picking it here gives this run read access to it.
fileUrl	string	no	—	A public CSV/TSV, JSON, JSON Lines or XLSX file (first row = column names, up to 50 MB).
prompt	string	yes	—	Plain-English instruction applied to every row, e.g. "Classify the review's sentiment and main topic", "Write a 20-word summary", "Translate the title to English", "Extract the company name and job seniority" or "Is this lead a B2B SaaS company? Answer true/false with a reason".
outputSchema	object	no	—	The fields to add, as {"field": "description or type"} (types number, integer, boolean and array are converted), or a full JSON Schema (also sent as a structured-output schema). Empty: the model returns any JSON object.
inputFields	array	no	—	Only send these fields of each row (dot paths allowed), to save tokens and keep private columns out of the prompt. Empty: the whole row.
outputMode	string	no	"merge"	Merge: the original row plus the new fields. Enriched only: just the new fields and _rowIndex.
outputPrefix	string	no	""	Optional prefix such as ai_ so new fields never overwrite existing columns.
model	string	no	"google/gemini-2.5-flash-lite"	Any OpenRouter model id (openrouter.ai/models), e.g. google/gemini-2.5-flash-lite (default: cheap and fast), openai/gpt-5-nano, openai/gpt-4o-mini or google/gemini-2.5-flash (smarter). Tokens are billed to your Apify account at OpenRouter rates.
maxLlmCostUsd	number	no	0.1	Hard cap on the AI token charges this run may cause on your Apify account (estimated, including the 10× free-plan rate when it applies). The worst case of each row (its prompt plus maxOutputTokens) is reserved before the call; the run stops cleanly when the next row would pass the cap. Separate from this actor's per-row fee, which the run's maximum total charge limits.
maxRows	integer	no	1000	Process at most this many rows.
maxInputTokensPerRow	integer	no	2000	Rows larger than this (≈3 characters per token) are skipped with a free row; select fewer fields to fit.
maxOutputTokens	integer	no	400	max_tokens for each reply. A few labels need ~50; a summary ~150; long extractions more.
estimateOnly	boolean	no	false	Read the rows and report the expected AI token cost and this actor's fee without calling the model (one free row).
allowPersonalData	boolean	no	false	Off (default): the model is told not to output private individuals' personal contact details and personal-looking email addresses in its output are replaced. Switch on only if you have a lawful basis.

Limits & honest notes

• AI tokens are a second, separate charge on your own Apify account, made by apify/openrouter at OpenRouter's rates (10× on the Apify free plan). They are not part of this actor's pay-per-event price and are not limited by the run's maximum total charge: use maxLlmCostUsd (default $0.10) to cap them, and estimateOnly to preview the cost. Each row's _llmCostUsd is an estimate from the usage OpenRouter reports; your Apify billing page is authoritative.
• AI models make mistakes. The model is told to use only the row's content and to return null when unsure, but check results that matter, especially classifications used for decisions about people.
• Row content is treated as data: the model is told to ignore instructions inside rows (prompt-injection defence), but no defence is perfect. Use inputFields to keep private columns out of the prompt.
• Personal data: by default the model is told not to output private individuals' contact details and personal-looking emails in its output are replaced. Only switch allowPersonalData on with a lawful basis.
• Datasets: with limited permissions the run can read only the dataset picked in the Dataset field (or passed by ID via the API). Files up to 50 MB; private and internal network addresses are refused at every redirect hop.
• If the AI service rejects the request (no credit, rate limit, unknown model id, outage), the run stops with one free status row "llm-unavailable" explaining why, and still finishes as SUCCEEDED.

Related ActorForge actors

• AI Web Extractor — structured data from web pages with a prompt
• Merge & Deduplicate Datasets — clean and merge datasets before enriching
• Business Places Data — lead lists to score and qualify

Changelog

• 2026-10-23 — Initial release: one prompt over every row of a dataset, CSV/JSON/XLSX file or pasted rows; typed output fields or JSON Schema; merge or enriched-only output; one retry per row; cost estimate; maxLlmCostUsd cap; apify/openrouter billed to the running account.

---

Built and maintained by ActorForge. Reliability first: every actor in the portfolio is monitored by an automated nightly self-test, and breakages are typically fixed the same day.