← All add-ons
sheets · Google Workspace

Bulk Barcode QR Code Mail Merge

Generate a QR/barcode per row and email it to each recipient — a code mail merge

mail mergeQR codebarcodebulk emailCode128EAN-13
Turn a Google Sheet into a personalised code mail merge. For every row, generate
a QR code or barcode and email it straight to that row's recipient — the code
embedded right in the message. No design tools, no attachments, no copy-paste.

WHAT IT DOES
• Point it at a value column and a recipient-email column. Each data row gets a
  code generated and delivered to its recipient in one click.
• Supports QR Code plus popular barcode symbologies: Code128, Code39, EAN-13,
  and UPC-A.
• Personalise the subject and HTML body with {{merge}} fields:
  – {{A}}, {{B}} … pull the value from that column letter.
  – {{header}} pulls the value under a matching column header.
  – {{code}} drops the recipient's code image into the email.
• Pick the code size (100–300 px).
• "Send test to me" previews the merged email without emailing recipients — and
  never counts against your free tier.

GREAT FOR
• Event tickets and check-in QR codes.
• Coupons, loyalty codes, and gift cards.
• Membership cards, asset tags, and licence keys.
• Product/SKU codes sent to suppliers or customers.

SIMPLE & FAST
• The code rides in the email as an image — recipients just open and scan.
• Works entirely on your active spreadsheet.
• Respects your Gmail daily send limit and shows how many sends you have left.

FREE & PRO
• Free: up to 20 emails/month.
• Pro: send beyond the cap, all symbologies. 14-day full trial.

NOTE ON EMAIL SENDING
This add-on sends email on your behalf (the sensitive script.send_mail scope)
and is subject to Gmail's daily send limits (about 500/day for @gmail.com and
1,500/day for Workspace accounts). It only reads your active spreadsheet —
nothing else in your Drive.