Skip to main content
A batch is rows on the Workbench. The steps run once per row instead of once per file, and {{column}} in a prompt is where each row’s value goes.

Putting rows on the bench

Any of these:
  • Drop a spreadsheet: a .csv, .tsv or .xlsx, like any other file. Only the first sheet of an .xlsx is read.
  • Paste: cells copied from Excel, Numbers or Google Sheets, or a list of short lines. Two lines are enough. The message offers Keep as text if you meant a note.
  • Write: type a line per row. A list is rows until you switch Each line is a row off. Cells split by tabs are always rows.
  • Paste a list of links: two or more links, one per line. Each link is a row, and its file.
  • Row each: with two or more files on the bench and no rows yet, Row each makes a row for each file, with its name in a file column.
  • Write them: the Write rows skill writes a sheet from a sentence, like “product photo prompts for a red trainer, each somewhere different”. Pick 10, 25, 50 or 100 rows, and name the columns if you want particular ones. Press Use as rows on the result to put the sheet on the bench. It’s written by a model, so read it before you run it.
The tile says how many rows it holds.

Using the rows

Write {{column}} in a prompt wherever a row’s value goes. A heading like Product Name is {{product_name}}. You don’t have to type it: press Insert beside the prompt, or type {{ in it, and pick from the list. Each column shows the first few things it holds. When the first step makes something from a prompt (an image, a video, a voice) and its prompt is empty, Use each row makes the sheet’s first column the prompt: paste three lines under Veo, press it, and Run makes three videos. Under the prompt, a preview shows it as one run will send it, with each value filled in. The arrows step through the runs. The rows run as soon as a step uses them. Run says how many runs and what they cost. A sheet no step uses is only a file, so a CSV you meant to convert still converts.

More than one sheet

A prompt can read any sheet on the workbench, and more than one. With two or more sheets on the bench, a column is named after its sheet: {{shots.prompt}} is the prompt column of shots.csv. A column only one sheet has also works on its own, as {{prompt}}. Two sheets in one prompt make every combination of their rows by default: 12 shots in shots.csv and 3 looks in styles.csv are 36 runs. The menu in the preview’s top line switches to Row by row, which pairs row 1 with row 1 and stops at the shorter sheet. Notes on the workbench can be read too. {{brief}} is the text of brief.txt, the same on every run. A batch runs up to 1,000 runs. Past that, Run says how many there would be.

The rows’ table

Press the pencil on the rows tile to open its table. See the rows in the Insert list opens it too. There you can:
  • Edit cells, and add rows or columns.
  • Switch off First row is headings when the first line is data, or a title. The columns are then column_1, column_2 and so on.
  • Turn on Every combination of the columns. Each column becomes a list, and every value runs with every value of the others: 3 products and 4 scenes make 12 rows.
  • Pick Each row’s file: a column naming a file dropped with the rows, a link, or a Vault file id. A column of file names or links is picked for you. With one other file on the bench and no file column, every row starts from that file.
  • Set Name each result from the columns: {{sku}}-{{colour}}.

Files for each row

Drop the sheet and its files together. A zip works too: the files inside land on the bench, folders flattened, and anything the bench doesn’t take is left out and counted. Match names decides how a cell finds its file: The table shows each row’s file beside it. A row whose name matches no file, or matches two, is marked, and Run says which rows. Nothing is dropped without a word. Under Run, a line says how many rows have a file and how many files went unused. An End frame or Second picture can come from the rows too: press From the rows in the field and pick a column, and each run uses its own picture. A link in the file column can be a direct file, a YouTube, Vimeo or other video page, a Google Drive or Dropbox share, or a podcast episode. Each is fetched the way a link pasted on the bench is. A link two rows share is fetched once. Signed in, the links are looked at before Run. The table shows each one’s title, and a line under Run names any that won’t fetch, such as a private video. That row fails when it runs and costs nothing. The other rows run.

Data steps

The data skills are ordinary steps that work on a sheet’s rows:
  • Filter rows: keep the rows where a column contains, is, isn’t, is filled or is empty.
  • Remove duplicate rows: by the whole row, or by one column. The first is kept.
  • Keep the first rows.
  • Split into rows: red, blue in one cell becomes two rows.
  • Add a column: written from the others, like {{brand}} {{product}}, {{style}}.
  • Stack sheets: a second sheet’s rows under these. Columns with the same name line up.
  • Match a sheet: a second sheet’s columns, matched in by a shared column, like prices matched to products by SKU. Every row stays, and the step says how many found no match.
Put them at the top of the steps and they make the rows: they run once, on the sheet, and each row that’s left runs the steps below them. Each one says how many rows went in and came out. They’re free, and a saved recipe keeps them. The Data filter in Add a step lists them. Stack sheets and Match a sheet take a second sheet. Drop it on the workbench and pick it under Other sheet, or upload it there. It isn’t run as a file of its own. With nothing below them, a data skill works on the sheet as a file and hands back the same kind: a CSV for a CSV, an Excel file for an Excel file.

Spending and checking

  • Run shows how many rows there are and what the batch costs. If your balance is short, it asks you to top up before anything starts.
  • Under Run, a line says what each row’s file turned out to be and names any link that won’t fetch.
  • Add an Image check step and a picture that fails it is made again, once. Each try is charged. The line under Run says so.
A batch pauses if your balance runs out. To cap what a batch spends, start it from the API with budget. See Run a batch. Running a batch needs an account. A free account runs one row at a time. The paid plans run the whole batch.

Starting from one

Start from a recipe has a Many at once shelf: every product in every scene, one video in every shape and language, and a video for each person on a list. Each lays its steps and puts sample rows on the bench, ready to edit.

Results

Results land in the results column as each row finishes. A result a batch made has Make again, which runs its row again. When the batch ends, a message says how many rows were done and offers to run the failed ones again. A batch keeps running if you close the tab. It is one row in the Queue; open it and its results come back onto the Workbench. The API runs batches too: see Run a batch.