Manage Bulk QR Code Generation from a Single Google Sheet

Whether you’re creating QR Codes for vCards for new employees, tracking inventories, or delivering unique coupon codes from every product’s packaging – you don’t want to go back to the Uniqode dashboard each time. 

We understand these are ongoing requirements for any business, and automating them saves a ton of time and effort; not to mention that it ensures consistency in QR Code generation.  

Google Sheets is a simple and universal way of managing all your data. With this update, we want to add-on to your existing way of managing processes. 

So now, you can manage and create QR Codes in bulk using our Google Sheets add-on. 

Capture real-time scan data and assign labels to segment and organize your QR Codes – all within a single spreadsheet on Google Sheets. 

Note: The Google Sheets add-on is available only on the Pro plan and above. 

What can you do with the Google Sheets add-on?

The Google Sheets add-on lets you:

1. Bulk create/update dynamic QR Codes within seconds. All you need to do is enter the relevant data for your campaigns in the spreadsheet. 
2. Fetch the number of QR Code scans in real-time and stay updated on your QR Codes’ performance. 
3. Assign labels to your QR Codes from Google Sheets. Segment and organize your campaigns seamlessly. 

Why use the Google Sheets add-on? 

The Google Sheets add-on serves the purpose of executing multiple tasks from a sole spreadsheet. Here are a couple of reasons why it will benefit your business: 

1. It doesn’t require third-party marketing automation software. It connects your spreadsheets to Uniqode directly.
2. You can create and update hundreds of dynamic QR Codes from a spreadsheet on Google Sheets. You can also download them from this spreadsheet. 
3. Once your QR Codes are live, you don’t need to keep checking the Uniqode dashboard for the number of scans. The add-on lets you capture that data at any time on your spreadsheet. 
4. You can share this spreadsheet with your team for effective collaboration. Always keep them in the loop on the QR Codes’ performance.
5. It saves you a lot of time, which would have otherwise gone towards exporting and transferring data manually. The add-on keeps you in sync with your Uniqode account at all times.
6. When it comes to constant updates, it’s a hassle-free experience. For instance, if a new employee joins your company every week, you don’t need to keep revisiting Uniqode to create vCard QR Codes for them. You can automate this process using the add-on. 

The Google Sheets add-on provides an efficient and convenient way to create, update, and manage several QR Codes in one place. 

How to install the Google Sheets add-on

Step 1: Open a new spreadsheet in Google Sheets

Open a new spreadsheet in Google Sheets and click on Add-ons > Get add-ons. 

Step 2: Find Uniqode in the Google Workspace Marketplace

Search for Uniqode in the Google Workspace Marketplace and install the add-on.

Step 3: Sign in to your Google account

Sign in to your Google account and click ‘Allow’ to enable authorization for Uniqode. By clicking on ‘Allow’, you’re letting Uniqode read data from your spreadsheet to create/update QR Codes, capture the number of QR Code scans, and assign labels to your campaigns. 

Step 4: Connect your Uniqode account

In your Google Sheets spreadsheet, click on Add-ons > Uniqode > Connect to Uniqode account. 

Enter the API Token and Organization ID. You can find these details in your Uniqode dashboard on the Account page. Click on ‘Authenticate’. 

How to create QR Codes with the Google Sheets add-on

Step 1: Enter the campaign details in a spreadsheet

Create a new Google Sheets spreadsheet. Enter the data required for the campaign type, such as the QR Code name, ID, and other relevant fields. Create separate columns for the download URL, the number of QR scans, and labels. 

For example, here’s a spreadsheet that contains the data required to create Website QR Codes:

Step 2: Select the row(s) in the spreadsheet

Once you’ve entered the details in the spreadsheet, select the rows for which you want to create the QR Codes.

Step 3: Select the campaign type

Click on Add-ons > Uniqode > Create/update dynamic QR Codes, and select the campaign type from the list. 

Step 4: Assign the columns

Assign the right columns to the headers, as shown below. 

Click Next. 

Step 5: Customize the QR Code(s)

Select a pre-defined template, enable the GPS location to track your campaigns, schedule your campaign, and select a download format.

Click on Create/Update. 

Step 6: Download QR Code(s)

Your dynamic QR Codes are now ready for download. Click on the URLs in the spreadsheet to download them. 

How to assign labels using the Google Sheets add-on

Step 1: Select the row(s) in the spreadsheet

Select the rows for which you want to assign labels for your QR Codes. Click on Add-ons > Uniqode > Assign labels to QR Codes. 

Step 2: Assign the columns

Assign the right columns to the headers. 

Click Next.

Step 3: Select the label(s)

Select the labels you want to assign to your QR Codes from your Uniqode account. 

Click on ‘Assign’. 

The labels have successfully been assigned to your QR Codes. You’ll find them in the dedicated column on your spreadsheet. 

How to fetch the number of QR Code scans with the Google Sheets add-on

Step 1: Select the row(s) in the spreadsheet

Select the rows in the spreadsheet for the QR Codes you want to fetch the number of scans. Click on Add-ons > Uniqode > Fetch scan count for QR Codes. 

Step 2: Assign the columns

Assign the right columns to the headers. 

Click on ‘Refresh Scans’. 

You’ll find the number of scans under its dedicated column for each QR Code. 

Check out: How to create and use Excel QR Codes

Need help with the Google Sheets add-on? Shoot us an email at support@uniqode.com or leave a comment below! 

• Author Details
• New tab

Author Details

Shweta Menon

Content Marketer , Uniqode

A happy writer with a fascination for technology, a passion for marketing, and a love for good literature. Feel free to reach out to her on LinkedIn to spark conversations about any of the above.

shweta.m@mobstac.com

• 

  QR Code Retargeting: Know Who Your Customers Are & Boost Conversion Rates

  Is your target audience scanning your QR Code but not converting? Utilize Uniqode’s QR Code retargeting feature to capture prospects via Google and Facebook ads. Check out our article to learn more.

• 

  Uniqode’s Single Sign-On for Secure Logins: What It Means and Why We Have It

  Elevate organizational security and productivity within your enterprise with the help of Single Sign-on. Want to know how? Check out our article on Uniqode’s SSO offering!

• 

  Create a Customized QR Code Landing Page: Improve Conversion Rates

  Power up your marketing campaigns using a landing page QR Code. Let your target audience access valuable content in a single scan. Check out this detailed guide to learn more.

• 

  Create a QR Code in Different Shapes: Elevate Brand Design

  Discover the evolution of QR code design and the trend toward using custom shapes, particularly circular ones, to match brand aesthetics. Find the benefits of custom QR Code shapes and a step-by-step guide on creating custom-shaped QR Codes.

• 

  How to Create a QR Code for Google Reviews: A Simple Guide

  Google Business Profile reviews are excellent for local SEO and business growth. Find out how to create a QR Code for Google Reviews, their various use cases, and how dynamic QR Codes give you an edge with tracking and analytics features.

• 

  TikTok QR Code: How to Create, Customize, and Leverage It for Your Brand

  Enhance your brand marketing strategy in innovative ways with a TikTok QR Code. Enable consumers to visit your profile and engage with your content in a single scan. Check out this guide to learn more.