All guides
Events and trade shows

Trade show lead capture: scan visitor badges into a Google Sheet

Scan visitor badges at your stand into a Google Sheet from any phone browser: the free routes, badge formats, which rep scanned, and when a lead app wins.

By the QR to Sheets team 8 min readUpdated

Short answer

QR to Sheets is a no-app trade show lead capture web app: booth staff open a scanner link in a phone browser, scan each visitor's badge, and every scan becomes a timestamped row in your Google Sheet, free for 300 scans on one phone.

Without it, leads reach a Google Sheet by typing business cards in after the show, by importing the organiser's lead retrieval export if you bought it, or by typing each visitor into a Google Form at the stand, which is live but slows every conversation.

The row holds exactly what the badge code holds, so a contact-card badge can be split into name, email and company columns with free column mapping, while notes and lead ratings at the stand are where a dedicated lead retrieval app is the better buy.

This guide is for exhibitors: the people at a stand who want every visitor they talk to in a Google Sheet, ready for follow-up. Checking guests in at the front door is QR event check-in; session attendance and CPD minutes are in the seminar and conference guide.

Written by QR to Sheets, which sells the scanner link described below, so weigh that accordingly. The free routes come first.

What are the free ways to get trade show leads into Google Sheets?

  • Collect business cards, or photos of them, and type them into the Sheet after the show.
  • Use the organiser's lead retrieval export, if you bought it, opened with File > Import in Google Sheets.
  • Put a Google Form on a tablet at the stand and have the rep type each visitor's details into it.

Each works, and each breaks somewhere. Typing cards takes hours after a long show, and the leads arrive after the best time to follow up. An export arrives when the provider sends it, usually after the event. A form typed at a busy stand slows every conversation and invites typos in exactly the field that matters, the email address.

What is inside a conference badge QR code?

Badge codes come in three shapes: a contact card, which is text that starts BEGIN:VCARD or MECARD:, a delimited record such as ID|Name|Company, or only an attendee number or a link. Scan one badge at set-up and look at the row before doors open: the Sheet gets exactly what the code holds.

Some organisers encode only an attendee number and sell lead retrieval as an exhibitor package; then the contact details come through that package.

A QR to Sheets scanner link reads QR codes, PDF417, Data Matrix, Aztec and Code 128 in the phone browser.

How do I split a badge into name, email and company columns?

Open Customize columns on the link (column mapping). It is free on every plan, with up to 20 columns per link. Columns A to C of a mapped row are always the scan time, the scanner and the device, so your mapped columns start at column D. For a contact-card badge, add three Regex extract columns:

For badges whose code starts BEGIN:VCARD. Copy each pattern exactly and set Group to 1.
ColumnSourcePatternGroup
nameRegex extractFN[^:\r\n]*:([^\r\n]*)1
emailRegex extractEMAIL[^:\r\n]*:([^;\r\n]*)1
companyRegex extractORG[^:\r\n]*:([^;\r\n]*)1
For badges whose code starts BEGIN:VCARD. Copy each pattern exactly and set Group to 1.

To keep the whole code as well, add a fourth column with the source Full value. For badges written as ID|Name|Company, use Split by separator with | and parts 0, 1 and 2 instead; the Event badge check-in template does this.

Phone numbers are left out on purpose: a value that starts with + is written as text with an apostrophe in front.

How do I know which rep scanned each lead?

Two ways. Give each rep their own scanner link, named after them: the link's name is written in the scanner column of every row. Premium has unlimited links; the free plan has one. Or keep one link and turn on Staff sign-in for it: invite each rep to your workspace, each one signs in once on their own phone with their own Google account, and each row records the signed-in staff member's email in place of the link name.

Staff sign-in is free on every plan, and each staff phone counts as one phone on your plan. A rep without a Google account cannot use Staff sign-in, so give that rep their own link instead.

How many phones does a stand need?

One for each rep scanning at the same time. One scanner link works on all of them, writing into the same Google Sheet. Free covers one phone and 300 scans in total. Premium is $7 per phone per month, so three reps cost $21 a month, or $70 per phone per year. You can lower the phone count or cancel at any time on the Billing page, and the change takes effect at the end of the period you already paid for.

Test on the phones the reps will use: a laptop, a second browser or a private tab counts as another phone. More on running several phones at once is in several phones scanning into one Google Sheet.

What if the hall Wi-Fi drops?

If the signal drops, the open scanner keeps saving scans on the phone and sends them when the signal is back, each with its original scan time. Open the link before doors open and keep the page open.

What happens when the same visitor is scanned twice?

Each link has an Accept duplicate scans setting with three choices. Always, the default, saves every scan and flags a repeat on the phone. Once a day records each code once per day, and Once ever records each code once on that link. For leads, keep Always: a visitor who comes back is still one lead, and two reps may scan the same person. Count unique visitors in the Sheet with UNIQUE on the email column instead; handling duplicate QR scans has the formulas.

When is a lead retrieval app the better buy?

When the rep needs to add notes, ratings or photos at the moment of the scan, when you want business cards read as well as badges, or when the badges hold only an attendee number and the contact details are licensed through the organiser. QR to Sheets records the scanned code and nothing else at the stand; notes go into a column of the Sheet afterwards.

Read on the vendors' own pages on 2026-10-25. Conference Badge Lead Retrieval costs $149 per event for up to 10 exhibitor licenses, $299 for up to 30, or $499 for unlimited, with notes, tags and a CSV when the event ends, and its exhibitors scan from a phone browser. Orca Scan's trade show page has exhibitors download the Orca Scan mobile app and lists photos and a scan history for each lead; its pricing page lists Google Sheets on the Business plan, $99 a month or $79 a month billed annually.

Organiser's lead retrieval app compared with QR to Sheets
CapabilityOrganiser's lead retrieval appQR to Sheets
Cost modelSet by the provider, often per event and per exhibitor licenceFree for 300 scans on one phone, then $7 per phone per month
Where leads liveThe provider's portal, then an export such as a CSV fileA row in your own Google Sheet at each scan
InstallAn app or a web page from the providerA link opened in Safari or Chrome
Notes and ratingsUsually, at the scanNo; add them in the Sheet afterwards
Which rep scannedDepends on the providerOne link per rep, or Staff sign-in

Step by step

  1. 1

    Create a scanner link

    Sign in, connect the Google Sheet your leads should land in and create a scanner link that writes to one tab. Name it after the show or the rep.

  2. 2

    Scan one badge and read the row

    At set-up, scan one real visitor badge with the link and look at the row: the Sheet gets exactly what the badge code holds.

  3. 3

    Map the columns

    If the badge holds a contact card, add Regex extract columns for name, email and company. If it holds fields separated by |, use Split by separator instead.

  4. 4

    Open the link on each rep's phone before doors open

    Each rep opens the link in Safari or Chrome, allows the camera once and keeps the page open during the show.

Frequently asked questions

Is there a lead capture app that writes straight to Google Sheets?+

Yes. QR to Sheets is free for 300 scans on one phone: booth staff open a scanner link in the phone browser and every badge they scan becomes a row in your Google Sheet, with no app, and after that it is $7 per phone per month. Orca Scan also offers trade show lead capture: its own page has booth staff download the Orca Scan mobile app, and its Google Sheets integration is a paid-plan feature (both read on Orca Scan's site, October 2026). Orca Scan is the better fit when notes, photos and a history for each lead matter at the stand.

Will a phone browser read our event badges?+

A QR to Sheets scanner link reads QR codes, PDF417, Data Matrix, Aztec and Code 128. Badges differ from show to show, so scan one badge at set-up and look at the row before doors open: the Sheet gets exactly what the code holds.

Can I add a note or a rating to each lead?+

Not inside the scan. Add notes in a column to the right of the rows after the show, or use a dedicated lead retrieval app if notes at the stand matter.

Does QR to Sheets read business cards?+

No. It reads QR codes and barcodes, not printed text.

Can several reps scan into one Sheet at the same time?+

Yes. Open the same scanner link on every rep's phone and every scan lands as its own row in the same Google Sheet. Each phone counts as one phone on your plan: Free covers one, and Premium is $7 per phone per month.

Try it on your own Google Sheet

Connect Google, create a scanner link, and open it on the phone that will scan. Have that phone at hand: setup takes a few minutes and ends with your first row in the Sheet. Free covers 300 scans on one phone, and the people you scan never install anything.

Start for free

No credit card required

A second door, booth or classroom is a second phone

Free covers one phone and one scanner link. Premium lets several phones scan at the same time, one per door, booth or classroom, into the same Sheet: $7 per phone per month. Running several classes, events or lists from one phone? Premium on that one phone is $7 a month, with a separate scanner link for each. Paid yearly, it is $70 per phone per year (2 months free).

How many phones will scan at the same time?

$7 x 2 = $14 a month

Sign in with Google and, on the free plan, the billing page opens with this choice. Nothing is charged until you confirm the card checkout, and you can change the number of phones later.

Keep reading