Pricing

from $1.40 / 1,000 rows

Try for free

Go to Apify Store

Run ChatGPT, Claude & Gemini in Bulk on CSV or Google Sheets

Try for free

Runs one plain-English ChatGPT, Claude or Gemini instruction on every row of an Apify dataset, CSV/Excel file, Google Sheet or JSON array; answers come back as new columns (classify, extract, score, summarise). No API key needed. Pay per enriched row; agent-ready via x402 and MCP.

Pricing

from $1.40 / 1,000 rows

Rating

0.0

(0)

Developer

Adam Pearce

Actor stats

Bookmarked

Total users

Monthly active users

8 days ago

Last modified

Categories

Developer tools

Agents

Dataset to enrich

datasetId

Optional

Pick an existing Apify dataset (for example the output of any scraper run). Use this OR 'File URL' OR 'Data (inline)' below. Declaring it this way is what lets this Actor run with limited permissions: it may read the dataset you point at, and nothing else on your account.

Type:string

File URL (CSV, Excel, JSON or JSON Lines)

fileUrl

Optional

Instead of a dataset, download the rows from a public link: a CSV or TSV file, an Excel .xlsx file (first sheet, header row), a JSON array or JSON Lines file, or a Google Sheet (paste the normal sheet link with sharing set to 'Anyone with the link can view'). Format detected automatically. Up to 100 MB.

Type:string

File format

fileFormat

Optional

Only needed if automatic detection gets the file URL's format wrong.

Type:string

Default:auto

Options:

autocsvtsvjsonjsonlxlsx

Data (inline)

data

Optional

A JSON array of records to enrich, for ad-hoc data instead of a dataset ID or file URL.

Type:array

Instruction (applied to every row)

prompt

Required

Plain-English instruction applied to each row on its own. Use {{field}} placeholders to insert that row's values (dotted paths like {{address.city}} work). Only the fields you reference are sent to the model; if you reference none, every field is sent. Examples: classify, extract a value, score 1 to 10, summarise, translate, normalise a job title, decide yes/no.

Type:string

Output columns

outputFields

Optional

The new columns the model must fill in for every row, as a JSON list of {"name", "type", "description"}. Types: string (default), number, boolean, array, object. The description tells the model exactly what goes in the column (allowed values, units, language). Leave empty to get one free-text column called 'aiResponse'.

Type:array

Extra context (optional)

systemPrompt

Optional

Optional background the model should know for every row: your industry, the categories you use, the language to answer in, edge-case rules.

Type:string

Model

model

Optional

Which model answers. Claude Haiku 4.5 is the default: fast, accurate on classification and extraction, about $0.001 of tokens per typical row. Cheaper options for simple labelling: GPT-4.1 nano, Gemini 2.5 Flash Lite, Mistral Small. Stronger options for nuanced judgement: Claude Sonnet 4.5, GPT-5 mini.

Type:string

Default:anthropic/claude-haiku-4.5

Options:

anthropic/claude-haiku-4.5anthropic/claude-sonnet-4.5openai/gpt-4.1-nanoopenai/gpt-4.1-miniopenai/gpt-4o-miniopenai/gpt-5-minigoogle/gemini-2.5-flash-litegoogle/gemini-2.5-flashdeepseek/deepseek-v3.2mistralai/mistral-small-3.2-24b-instruct

Custom model id (optional, overrides Model)

customModel

Optional

Any model id from openrouter.ai/models in vendor/model form, e.g. anthropic/claude-opus-4.5 or meta-llama/llama-3.3-70b-instruct.

Type:string

Your own OpenRouter API key (optional)

openRouterApiKey

Optional

If set, requests go straight to openrouter.ai on your own key and no token cost is billed through Apify. Leave empty to use Apify's built-in proxy with no key at all.

Type:string

Preview: only process the first N rows

previewRows

Optional

Test your instruction cheaply before running everything: set to 5 or 10, check the output columns, then set back to 0 for the full run.

Type:integer

Minimum:0

Default:0

Maximum rows to process

maxRows

Optional

A cost guard. Rows beyond this are not loaded. Hard ceiling 50,000 per run.

Type:integer

Minimum:1

Maximum:50000

Default:1000

Rows per model request

rowsPerRequest

Optional

How many rows share one model call. Higher is cheaper (the instruction is sent once per call) and faster; lower is safer for long texts. 5 is a good default; use 1 for very long rows.

Type:integer

Minimum:1

Maximum:25

Default:5

Parallel requests

concurrency

Optional

How many model calls run at once.

Type:integer

Minimum:1

Maximum:10

Default:4

Max characters per field sent to the model

maxInputCharsPerField

Optional

Longer values are cut (with a '[truncated]' marker) so one huge text field can't run up the token bill.

Type:integer

Minimum:100

Maximum:50000

Default:4000

Max answer length per row (tokens)

maxOutputTokensPerRow

Optional

150 covers a label plus a short summary; raise it for long summaries or translations.

Type:integer

Minimum:20

Maximum:1000

Default:150

Temperature

temperature

Optional

0 (default) for consistent, repeatable answers, which is what classification and extraction need. Only raise it for creative rewriting. Whole number 0 to 2.

Type:integer

Minimum:0

Maximum:2

Default:0

Skip rows whose referenced fields are all empty

skipIfEmpty

Optional

On (default): a row with nothing in any {{field}} the instruction uses is written out with 'aiSkipped: true' and never sent to the model or charged.

Type:boolean

Default:true

Keep the original fields in the output

includeOriginalFields

Optional

On (default): each output row is the original row plus the new columns. Off: only the new columns (plus aiModel/aiError).

Type:boolean

Default:true

Also append to a named dataset

outputDatasetName

Optional

Optional. A name (3 to 63 letters, digits or hyphens). Enriched rows are appended to a dataset with this name in your account, created on the first run, so scheduled runs accumulate in one place. Not charged again.

Type:string

Export file formats

exportFormats

Optional

Also save the enriched rows as a real downloadable file in the run's key-value store. CSV opens anywhere; XLSX opens in Excel and Google Sheets.

Type:string[]

Webhook URL (optional)

webhookUrl

Optional

Optional. If set, the enriched rows (plus download links and a summary) are POSTed here as JSON the moment the run finishes. Works with a Zapier/Make/n8n catch-hook, your own API, or a Slack incoming webhook. Only charged on a confirmed HTTP 2xx; a failed delivery is a warning and costs nothing.

Type:string

OpenRouter

apify/openrouter

You can use any AI LLM model without accounts in AI providers. Use this Actor as a proxy for all requests. Use pay-per-event pricing to pay only for the real credit used.

Apify

13K

4.9

(10)

Dataset Filter & Transform

nerolabs/dataset-filter-transform

Returns rows of any Apify dataset, CSV/Excel/JSON file URL or Google Sheet that pass filter rules (25 operators, AND/OR, date ranges that fix a scraper's ignored date filter) after transforms (rename, cast, compute, regex), then sort, dedupe, export, webhook. Agent-ready: pay per event (x402, MCP).

Adam Pearce

116

Bulk OCR: Image & Scanned PDF to Text from CSV or Google Sheet

nerolabs/bulk-ocr-image-pdf-to-text

OCR every image and scanned PDF linked in an Apify dataset, CSV, Excel or Google Sheet, keeping your columns. Inputs: datasetId or fileUrl or fileUrls, urlField, languages. Adds text, confidence and page counts. Tesseract inside the run, no outside service. Charged per page. Agent-ready: x402, MCP.

Adam Pearce

Dataset Cleaner & Exporter

nerolabs/dataset-cleaner-exporter

Returns a deduplicated, flattened and cleaned copy of any Apify dataset, file or Google Sheet by URL, or JSON array, plus CSV and Excel files, named-dataset append and webhook delivery. Inputs: source, dedup keys, flatten, cleaning options. Agent-ready: pay per event (x402, MCP), per cleaned record.

Adam Pearce

Dataset Aggregate, Group By & Pivot

nerolabs/dataset-aggregate-pivot

Returns GROUP BY and pivot tables for any Apify dataset, file or Google Sheet by URL, or JSON array: count, sum, average, min, max, median per group, date buckets, pivot columns. Exports CSV/Excel, appends to a named dataset, posts to a webhook. Agent-ready: pay per event (x402, MCP), per input row.

Adam Pearce

Dataset Join & Merge (VLOOKUP for Datasets)

nerolabs/dataset-join-merge

Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields like SQL or VLOOKUP: left, inner, right, full and anti joins plus union, with CSV/Excel export, named-dataset append and webhook delivery. Agent-ready: pay per event (x402, MCP), per output row.

Adam Pearce

Bulk Image Downloader: Files from CSV, Google Sheet or Dataset

nerolabs/bulk-file-downloader

Downloads every image or file linked in a dataset, CSV, Excel or Google Sheet and stores each with a public link, keeping your columns. Inputs: datasetId or fileUrl, urlField, fileNameField, createZip. Charged per file stored plus per 10 MB; broken links and repeats free. Agent-ready: x402, MCP.

Adam Pearce

Bulk PageSpeed & Lighthouse Checker: Core Web Vitals from CSV

nerolabs/bulk-pagespeed-checker

Google PageSpeed Insights (Lighthouse) scores, Core Web Vitals and top speed fixes for every URL in a plain urls list, Apify dataset, CSV or Google Sheet, keeping your columns. Inputs: urls, datasetId or fileUrl, strategy. Charged per completed report. Agent-ready: x402, MCP.

Adam Pearce

Run ChatGPT, Claude, Gemini & DeepSeek in Bulk (No API Key)

fayoussef/bulk-llm-runner

Run hundreds of prompts in parallel across GPT, Claude, Gemini, Perplexity, DeepSeek, Qwen, Kimi and 350+ models, with web search, JSON columns and side-by-side model comparison. Optional: upload an Excel, CSV or Google Sheet to run AI on every row. No API key needed.