Batch Merge
Free Membership Card Template for Google Docs (Mail Merge Ready)
A compact membership card design with member details, ID number, tier badge, and expiry date. Copy it into a Google Doc, connect your member roster in Google Sheets, and generate a personalized card for every member in one click.
The template
Everything in {{double braces}} is a merge tag. Each tag matches a column header in your Google Sheet, and Batch Merge fills in the value from each row automatically — one finished card per member.
Tip: the add-on's built-in library also includes a One-Pager Google Slides template — Slides merge (a Pro feature) is great for card-like layouts, since a slide gives you a fixed-size canvas with precise placement for badges, logos, and colored tier bands.
Set up your Google Sheet
Create one column per merge tag. Column headers must match the tag names exactly (they're case-sensitive). Each row becomes one card:
| Member Name | Member ID | Tier | Join Date | Expiry Date | Benefits Summary |
|---|---|---|---|---|---|
| Jordan Blake | MEM-00417 | Gold | Mar 15, 2024 | Mar 15, 2027 | Unlimited classes, 2 guest passes/mo, 10% shop discount |
| Priya Nair | MEM-00532 | Silver | Jan 8, 2026 | Jan 8, 2027 | Unlimited classes, member-only events |
Tip: generate Member IDs with a formula like ="MEM-"&TEXT(ROW()-1,"00000") and compute Expiry Date from Join Date with =EDATE(D2,12) — Batch Merge inserts the displayed value, so format the date columns consistently.
Generate one card per member
Copy the template into a Google Doc. Click Copy template above, paste into a new Doc, and style it — shrink the page size for a card feel, add your logo and tier colors. Tags survive formatting.
Install Batch Merge free from the Google Workspace Marketplace, then open your member roster and choose Extensions → Batch Merge → Open Batch Merge.
Pick your template. Select the card Doc with the file picker. Batch Merge scans it and shows every tag as a pill — green when it matches a column header, amber when it doesn't. Fix any amber pills by renaming columns or tags.
Choose PDF output and run. Pick PDF (or DOCX / Google Doc), choose a Drive folder, and click Run. Batch Merge writes a status per row and a Merge Log so you always know which members have a card.
On the free plan you get 25 merge runs per month — each run can process your whole roster. Email delivery (send each card straight to a {{Member Email}} column), scheduling, and Google Slides templates are on Pro.
FAQ
How do I make the output actually card-sized?
In your Google Doc, use File → Page setup to set a custom page size (a business card is 3.5×2 inches), or place the card content in a fixed-size single-cell table and print several per page. For pixel-precise layouts with badges and background colors, use a Google Slides template instead — Slides merge is a Pro feature.
Can I re-issue cards when memberships renew or tiers change?
Yes — update the Tier and Expiry Date cells and run the merge again. Each run processes your whole sheet, so a re-run regenerates every card in one click. On Pro, scheduling can run the merge automatically so renewals never wait on you.
Can I email each member their card automatically?
On the Pro plan, yes. Add a Member Email column and Batch Merge's per-row email delivery sends each member a personalized email with their own card attached as a PDF — the whole roster in one run.
Related templates
Generate every member card in one click
Batch Merge is free to install — 25 merge runs per month, no credit card.
Install Batch Merge Free