“QR Code Access Card” Google Sheets™ Addon

QR Code Pass Per Response illustration image

QR Code Access Card” is our Google Sheets™ addon that makes it easy to register people to events, then check their registration or record their participation to various activities, using QR codes.

Google Workspace Marketplace badge

Install addon
Post-install tips
Frequently asked questions
Privacy policy
Terms of use
Check out our QR code pass extension for Google Forms™

Usage

Screenshot of Google Sheets with the code columns added by the "QR Code Access Card" addon

The initial (Configuration tab) page of the addon is used to setup the sheet where you have your event registration data. It is expected to have headers on the first line, and a line for each attendee.

Screenshot of the initial page of the "QR Code Access Card" addon, where the sheet with attendee data is selected

When you initialize the addon with the sheet containing your attendee data, it will transparently configure an app on our QR code tracking platform for you. This step is based on the columns on your sheet, so make sure your attendee data has all needed columns, and some attendee data, before using the addon.

Screenshot of the "QR Code Access Card" addon, where one can generate QR codes for each attendee

From the Dashboard tab, you can click on “Generate QR codes” every time you add new attendees, and tracking columns will be automatically filled for you. One will link to the QR pass for this attendee.

Screenshot of the "QR Code Access Card" addon, where on can record participant check-in

From the same Dashboard tab, you can scan any QR code pass to check or track every attendee. Scanning is easier from a smartphone (though you can use your laptop with a camera too). The addon will display a QR code for each action. Scan that code from your smartphone and follow the link to have access to your QR pass scanner ou lookup page.

Screenshot of the "QR Code Access Card" addon, where one can access various reports on participants

You can scan a group of QR code passes, by showing them to the camera one after another, in quick succession. For the default check-in, you don’t need to enter any additional data. Currently, the title on QR passes is derived from name fields in your form, and the subtitle is the attendee email. These (and the design) can easily be changed on request.

sample QR code ticket for attendance

You also have access to several reports (people registered but not checked in, people checked in, etc.), which you can export to Excel. You can also download all QR passes here, if you need to print them for your attendees (though you can directly scan the PDF on their phone to avoid printing).

This service is free for less than 20 attendees. Please reach out for more responses or for any custom data collection configuration.

For pricing information, please consult the addon description on the store or reach out.

Post-install tips

Make sure you already have a sheet with some attendee data, with headers on the first line, then select that sheet in the configuration to setup QR code pass generation.

Labels on the QR code pass PDF will be automatically build from questions with “name” in their title, or the first question in the form.

After initialization, click the “Generate missing attendee codes” to test QR pass generation, and click the links added to the sheet to download the pass.

Frequently asked questions

How do I add other staff to help validate passes or record attendance?
Use management is not yet integrated in the addon, but supported by the underlying platform. Please get in touch and we’ll activate it for you.

How do I record attendance per event session?
The default configuration only records one type of attendance, but you can do so much more! Advanced configuration is not currently exposed inside the addon, but you can reach out and we’ll do it for you quickly.

How do I customize the design of the PDF QR code ticket?
Your QR title and subtitle will use default settings derived from attendee data sheet. Those defaults might not suit you though, either because you prefer static text, or data from different fields. Until this setting is exposed inside the addon, you can reach out and we’ll handle it for you. This also applies to custom logos on the PDF, or completely custom designs.

How do I add a shortcut for the validation camera on my smartphone’s homescreen?
You can use “Install app” or similar from your browser’s menu, or click the “Android app” link at the bottom of the page.

Terms of use

By using this addon, you agree to:

  • Let us collect and use attendee data from your sheet to generate QR code passes and track attendance.
  • Keep the attribution on generated QR passes, unless explicitly authorized to remove it.
  • Understand that the addon is provided as is and we are not liable for any damages.
  • Contact us with questions.