Sheet to PDF
Help · Troubleshooting · Blank PDFs

PDFs are blank or missing values

If your generated PDFs look like the template with {{Variables}} still showing (or with empty spaces where values should be), one of these is the cause.

1. Header name mismatch (most common)

The placeholder name in your template must exactly match the column header in row 1 of your sheet — case-sensitive, including spaces.

Fix: open the sidebar → expand "Customize filename" → look at the "Insert:" chips. Those are the column headers Sheet to PDF detected. Use one of those exactly in your template.

2. Cells are empty

If the cell value is empty, the placeholder gets replaced with an empty string. That's expected behavior — we don't skip rows with empty cells.

Fix: fill in your sheet, or use a default filter (Starter+): {{Address | default:"—"}}

3. Row 1 doesn't contain headers

Sheet to PDF only reads row 1 for headers. If row 1 contains data and your real headers are on row 2 or 3, no placeholders will match.

Fix: move your headers to row 1. Delete any rows above the headers.

4. Template uses {Variable} (single braces)

Sheet to PDF only recognizes the {{Variable}} syntax (double braces). Single braces stay as plain text.

Fix: replace single braces with double braces throughout your Doc.

5. Smart syntax on the Free plan

If your template uses {% if %} or filters like {{ X | currency:"EUR" }} and you're on the Free plan, those stay as literal text — they're only rendered on Starter+.

Fix: upgrade to Starter (€5/mo), or remove the smart syntax from your template.

6. Template was modified mid-generation

Rare, but if you edited the template Doc while Sheet to PDF was reading it, some PDFs may have the old version and some the new.

Fix: regenerate the affected rows.