Template merge troubleshooting

Google Docs merge fields not replacing from Sheets?

If your generated Google Doc or PDF still shows placeholders, has blank fields, or pulls the wrong row values, fix the template and sheet mapping before running another batch.

Template fieldSheet headerStatus
{{ApplicantName}}Applicant NameMismatch
{{StartDate}}StartDateMapped
Generated output check {{ApplicantName}} StartDate replaced Run one-row preflight first
Quick answerCompare exact placeholder names with mapped sheet fields.
First testUse one row and one template before a batch.
Common causeRenamed headers, blank cells, or stale mappings.
Best fixRun preflight, regenerate one file, then scale.

Quick answer

When Google Docs merge fields do not replace from Google Sheets, the problem is usually a mismatch between the template placeholder and the selected sheet column, a blank source value, a renamed header, the wrong template file, or output generated before the latest mapping was saved.

Do not troubleshoot with a full batch. Pick one row with known values, generate one Google Doc or PDF, and inspect every field before producing more files.

Check in this order

1Template text

Make sure each placeholder is plain text and has the exact name you expect.

2Sheet headers

Check whether row 1 headers were renamed, duplicated, hidden, or moved.

3One-row output

Run preflight and generate one file from a row that has complete test data.

Most common causes

Placeholder spelling does not match

Spaces, punctuation, capitalization, and braces can matter. If the template uses {{FirstName}} but the mapping expects First Name, confirm the mapping instead of assuming the text will normalize itself.

Header renamed after setup

If a Sheets column was renamed after the merge workflow was configured, open the mapping again and reconnect that field before generating output.

Selected row has blank cells

A blank output field can be correct if the source row is blank. Test with a row where required values are visible and easy to verify.

Wrong template selected

Teams often have multiple draft templates. Confirm the selected Google Docs file is the current version and contains the placeholders you are checking.

Output generated before saving

If you changed the template or mapping, generate a fresh one-row test. Older files will not update themselves after a mapping fix.

Rich copied placeholder text

If a placeholder was copied from another source, retype it directly in Google Docs as plain text. Broken hidden formatting can make a field hard to detect.

DocForge preflight pattern

DocForge is built for template-based document generation from Google Sheets rows. Use the add-on when you want a repeatable workflow with field mapping, preflight checks, and one-file testing before a full batch.

  1. Open the source Google Sheet and choose a row with complete sample data.
  2. Open DocForge from the Google Sheets Extensions menu.
  3. Select the current Google Docs template file.
  4. Review the field mapping against row 1 headers.
  5. Run preflight and fix any missing fields or access warnings.
  6. Generate one Google Doc or PDF and inspect unresolved placeholders before continuing.
Boundary: DocForge helps generate Docs and PDFs from mapped rows. If you need legal approval routing, retention policies, or document lifecycle governance, use a dedicated document management system.

FAQ

Why do some fields replace and others stay as placeholders?

The working fields probably have valid mappings and source values. Recheck the unresolved fields for spelling, renamed headers, blank row data, or copied placeholder formatting.

Why are merged fields blank instead of showing the placeholder?

That usually means the field was found, but the selected row did not have a value for that mapped column. Test with a row that contains obvious sample values.

Should I rename sheet headers to match the template exactly?

Exact names are easier to audit, but a field mapping step can still connect different names. The important part is confirming the current mapping before generation.

Can I fix a generated file after changing the template?

Generated files are snapshots. After changing the template or mapping, generate a new one-row output and replace the old file if needed.

Install DocForge for repeatable template merges

Install DocForge when spreadsheet rows need to become Google Docs or PDFs through a repeatable template workflow with a safer first-run check.

Related guides