{
  "mcpServers": {
    "sheetrender": {
      "command": "npx",
      "args": ["-y", "@sheetrender/mcp"],
      "env": { "SHEETRENDER_API_KEY": "sr_live_..." }
    }
  }
}

SHEETRENDER_API_URL is also read, and defaults to https://sheetrender.com. Set it only if you're pointing at a self-hosted or staging instance.

Tools

`render_pdf`

Renders one PDF from HTML you supply.

Argument	Type
`html`	string	Required. A full HTML document. CSS has to be inline in a `<style>` tag; external stylesheets, fonts and scripts are not fetched.
`data`	object	Optional. Keys become Jinja variables, so `{"total": "42.00"}` makes `{{ total }}` available in the HTML.
`page_settings`	object	Optional, see below.

Returns the path of the saved PDF and its size. Under 512 KB it's also attached inline as a base64 resource, so clients that display attachments show the document itself.

Two server limits apply. HTML over 2 MB is rejected, and that's measured both on what you send and on the document after data is substituted in, so a template that expands a long dataset can cross the line even when the markup you wrote doesn't. The other is the free plan, where every rendered PDF carries a "Made with SheetRender" footer. That applies to render_pdf and render_template alike. Paid plans don't get it.

`list_templates`

No arguments. Returns each saved template's name, id and last-updated date. Call it to turn a template name the user mentioned into the id the other tools want.

`render_template`

Renders one PDF from a template already saved in the account.

Argument	Type
`template_id`	string	Required, from `list_templates`.
`data`	object	Required. One row's values, as Jinja variables.
`page_settings`	object	Optional. Omit it to keep the template's own saved page setup; passing it overrides that for this render.

Same return as render_pdf.

`create_batch_job`

Queues a background job that renders one PDF per row of a dataset already uploaded to the project. This server can't upload spreadsheets.

Argument	Type
`template_id`	string	Required, from `list_templates`.
`dataset_id`	string	Required. A dataset in the same project as the template.
`filename_template`	string	Optional. Output naming pattern, e.g. `invoice-{{ invoice_no }}`.
`group_by`	string	Optional. Column to group rows by, giving one multi-page PDF per distinct value.

Returns the job id to poll with get_job. Worth knowing: filename_template and group_by are persisted to the template and the project respectively, so they change the defaults for later runs too.

If the server predates the public batch endpoint, the tool reports that batch jobs are unavailable rather than failing obscurely.

`get_job`

Takes job_id. Returns the status, rows done and failed, and the id and filename of every rendered document. That document list stays empty while the job is queued, retry_queued or running, and fills in once the job reaches succeeded, partial, failed or cancelled. Those document ids are what get_document takes.

`get_document`

Takes document_id and downloads that single rendered PDF. The ids come from get_job on a finished batch, and there's no other way to get one. Same return as render_pdf: path, size, and an inline blob under 512 KB.

If you want a whole batch, the merged PDF and ZIP in the web app beat fetching each document in turn.

`page_settings`

Shared by both render tools. Every field is optional:

{
  "page_size": "a4",
  "orientation": "portrait",
  "margins": { "top": 15, "right": 15, "bottom": 15, "left": 15 }
}

page_size is lowercase: a3, a4, a5, letter, legal or tabloid. Margins are plain numbers in millimetres, not CSS lengths.

Rendered PDFs are written to the system temp directory. API errors like a bad key, a missing template or a rate limit come back as tool errors carrying the server's own message.

The public API allows 120 requests per minute per API key. Past that it returns 429, and the tool reports that you're rate limited and should retry shortly. Batch job creation is metered separately and more tightly.