How many rows can one job have?

Up to 1,000 items per batch. Split a longer list into several jobs; there is no limit on how many jobs you run, and each counts once against the rate limit. See async and batch.

What happens when one row is wrong?

When the template fails on a row’s data, that item fails and the others still render: the job ends as partially_failed and the failed item carries the error, so you can fix the row and render it again on its own. An item the API refuses outright (a request field it does not accept, or data that misses the template’s schema under validate_data) refuses the whole batch before anything is queued, and the problem names the item’s position.

Does a failed item cost units?

No. Only documents that were produced are counted.

Can I send a spreadsheet instead of writing code?

Yes: the app takes a CSV or Excel file, maps the columns to the template’s fields and runs the batch for you. The code here is for the same thing inside your own system.

Guide · Node.js (TypeScript)

Generate PDFs from a CSV in Node.js (TypeScript)

A list of people and a template make a stack of documents. Instead of one request per row, a batch queues up to 1,000 renders as one job, and one zip comes back. This Node.js (TypeScript) program reads a CSV, maps the rows and waits for the job.

Start for free Read the docs

Free plan with 100 units a month, no credit card

What you need

An API key. Create one in the app under API keys and export it as FORMFEED_API_KEY. A test key (ff_test_…) is right for trying things out. See the quick start.
Node.js (TypeScript). You need Node.js 22 or newer and the @formfeed/sdk package, which has no dependencies of its own.
The template. certificate from the certificate example, whose fields are exactly the columns of the CSV.
The CSV. attendees.csv next to the program, with a header row. It is shown below.
Enough units. Batches are part of every plan, and each item counts as at least one unit. On the Free plan a live batch is refused when the month has fewer units left than the batch has items; a test key is not counted. The limits page has the units per plan.

InstallShell

npm install @formfeed/sdk
npm install --save-dev tsx   # runs the .ts file directly

The program

The program reads the CSV, turns every row into an item, queues them as one job with zip: true, waits until the job is done and saves the archive.

batch.tsTypeScript

import { readFile, writeFile } from 'node:fs/promises';
import { Formfeed } from '@formfeed/sdk';

const formfeed = new Formfeed({ apiKey: process.env.FORMFEED_API_KEY! });

// a simple CSV: one line per attendee, no quoted fields. For anything else use a parser (csv-parse).
const [header, ...rows] = (await readFile('attendees.csv', 'utf8')).trim().split(/\r?\n/);
const columns = header!.split(',');
const attendees = rows.map((row) => Object.fromEntries(row.split(',').map((value, i) => [columns[i]!, value])));

const job = await formfeed.renders.batch({
  template: 'certificate',
  zip: true,
  // every field of a CSV is text: the template expects hours as a number
  items: attendees.map((a) => ({ data: { ...a, hours: Number(a['hours']) } })),
});
console.log(job.id, job.total, 'queued');

// polls GET /jobs/{id} until the job is done, with backoff and a timeout
const done = await formfeed.jobs.waitFor(job.id);
console.log(`${done.succeeded}/${done.total} rendered, ${done.failed} failed`);

if (done.zip_url) await writeFile('certificates.zip', new Uint8Array(await (await fetch(done.zip_url)).arrayBuffer()));

Run it

It prints the job id and how many renders were queued, then 4/4 rendered, 0 failed, and certificates.zip lies next to the program with one PDF per row, 0001-document.pdf to 0004-document.pdf.

Shell

export FORMFEED_API_KEY=ff_test_...
npx tsx batch.ts

What is particular about Node.js (TypeScript)

Top-level await. The file uses await outside a function, so it must be an ES module: keep "type": "module" in package.json or name it .mts.
Retries are built in. The SDK sends an Idempotency-Key with every render and retries 429, 503 and network errors up to three times with backoff, with the same key: a retry of a request that was answered already gets that answer back instead of a second render.
Errors are typed. A problem answer throws a FormfeedError whose code is the API’s error code (template_not_found, quota_exceeded, …); catch it where you would show the user something useful.
Runs anywhere fetch does. The SDK uses only web APIs, so the same call works in Deno, Bun and Cloudflare Workers; only the file access differs.

The CSV

One header row, one line per document. The columns are the fields the template expects, so no mapping table is needed:

attendees.csvText

name,course,completed_on,hours
Erika Mustermann,Analytical Engines 101,2026-09-10,16
Max Mustermann,Analytical Engines 101,2026-09-10,16
Jane Doe,Print CSS for developers,2026-09-11,8
John Doe,Print CSS for developers,2026-09-11,8

What a batch does differently

Always asynchronous. The answer comes back at once with the status queued. The renders run in the background, as many at a time as your plan allows.
One template, many items. A top-level template applies to every item that does not name its own, so an item is usually just its data.
Partly failed is a state. A job in which some items failed ends as partially_failed (failed when all did). succeeded and failed count them, and every item is a render of its own in items, with its own error.
The zip is optional. Every item keeps its own download URL in items, which is what you want when the documents go to different people. zip: true adds one archive of the succeeded ones, each named 0001- and its item’s filename (document.pdf without one), in row order.
Or a webhook. Instead of waiting, give the batch a webhook_url and let job.completed (or job.failed, when every item failed) tell you. For thousands of documents that is the better shape: no process waiting for minutes.

When the API says no

One shape for every error. Errors are problem documents (RFC 9457) with type, title, status, detail, a stable code and the request_id to quote to support; the type URL leads to a page about that error. The list is in the error reference.
The usual ones. 401 unauthorized for a missing or revoked key, 404 template_not_found for a wrong template name, 422 template_runtime_error when the template fails on the data, 429 rate_limited above the plan’s requests per second, 402 quota_exceeded when the Free plan’s units are used up (a paid plan bills extra units up to its hard cap).
Retry safely. Send an Idempotency-Key header with the POST, and repeat the request with the same key when you do not know whether the first attempt arrived: for 24 hours the key returns the first answer instead of rendering and billing again. The answer is stored once the first attempt has been answered, so do not retry while it may still run; and problems below 500 are stored too, so a corrected request needs a new key.

The job around this program

This guide is one program. What the job needs around it, from the template to the limits and the price, is on the page Certificate generator API.

More Node.js (TypeScript) guides

FAQ

How many rows can one job have?: Up to 1,000 items per batch. Split a longer list into several jobs; there is no limit on how many jobs you run, and each counts once against the rate limit. See async and batch.
What happens when one row is wrong?: When the template fails on a row’s data, that item fails and the others still render: the job ends as partially_failed and the failed item carries the error, so you can fix the row and render it again on its own. An item the API refuses outright (a request field it does not accept, or data that misses the template’s schema under validate_data) refuses the whole batch before anything is queued, and the problem names the item’s position.
Does a failed item cost units?: No. Only documents that were produced are counted.
Can I send a spreadsheet instead of writing code?: Yes: the app takes a CSV or Excel file, maps the columns to the template’s fields and runs the batch for you. The code here is for the same thing inside your own system.