Manage an event with Google Sheets

Luis Manjarrez
Jan 21, 2019 · 4 min read

This post is for people who are looking for a quick, affordable way to manage a free small event. By following this tutorial you will create:

  • An online registration form.
  • An attendee list that is populated automatically.
  • Name badges for your guests.
  • A way to scan QR code to exchange guest’s information.

Ok, so let’s get started!

Online registration form

Go to Google Drive and click on New → More → Google Forms → Blank Form

Customize the form the capture all the information you need from the attendees. If you don’t know what info you need, you can start with these fields:

  • Email (in case you need to contact people)
  • First name
  • Last name
  • Company
  • Job title
  • Attendee type (in case you wish to have different badge designs this can be handy)
Image for post
Image for post

I recommend making most or all these fields required, you don’t want to get some attendees with missing information.

Done. You now have an online form, you can share it through a newsletter, share a simple link or even embed it to your website!

To share it click on Send on the upper right corner and select the option you prefer.

Image for post
Image for post

Attendee list that populates automatically

Inside the Google Form we just finish setting up, you have the option to manage your responses, or in this case the attendee’s RSVPs.

To do that click on Responses → Google Sheets (it’s a green icon) → Create a new spreadsheet

Image for post
Image for post

This will create a spreadsheet that will be filled out automatically once you start getting responses (RSVPs)!

Image for post
Image for post

Name badges for your guests

Once you close registration and have you attendee list ready, it’s time to create name badges.

The first step is to export the data, to do this click on File → Download as → Comma-separated values (.csv, current sheet)

Image for post
Image for post

This will download a CSV file to your computer.

Image for post
Image for post

Now head over to ConferenceBadge.com and click on Create your badges and create a free account. Once inside click on New Event From Excel.

Image for post
Image for post

Upload the CSV you downloaded from Google Sheets and enter the rest of the event’s information.

Image for post
Image for post

Match the columns with your attendee’s information. Don’t worry if there’s information you don’t need, like the Timestamp, later on you will be able to choose what to include in your badge design.

Now choose the product and size you need. We offer very affordable PDF badges, those are printed and assembled by you, they only cost a quarter each! But if you have a little more budget and don’t want to invest time in this task, we can print, assemble and ship the badges to your doorstep in just 2 business days.

Image for post
Image for post

Once you select a product and size you will be able to choose a starting template or start from scratch with a blank canvas.

If you are feeling dry on inspiration, check out our name badge inspiration page.

Image for post
Image for post

Now let’s customize the design depending on their badge type. To do this you can follow this quick tutorial. But you basically create conditions based on a column from you spreadsheet information and then customize the badge, pretty easy!

Image for post
Image for post

Scan QR codes to exchange guest’s information.

Finally, let’s add a vCard QR code that can contain name, company, job title, email and phone, this is great to do lead retrieval. Attendees can leave the business cards at home and just scan other guest’s badges and store their contacts directly on their phones!

There are many apps out there that can scan vCards, we recommend CamCard or just use the native iOS Camera app if you have an iPhone.

In the editor you have to click on QR codes & barcodes → vCard → QR code (most used) → OK.

Image for post
Image for post

Wrap up

So that’s that, you are ready to focus on other areas of your event, but registration, attendee management, badge-making and lead retrieval is solved. Great work!

If you want to try Conference Badge for the first time, let me know in the comments and I will provide you with a discount!

Conference Badge

Name badges. Easy and fast.

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store