All Collections
QR Codes
Integrations and API
Integrations
How to integrate Google Sheets with Uniqode?
How to integrate Google Sheets with Uniqode?

Generate and manage QR Codes in bulk using Uniqode's Google Sheets add-on

Sreenidhi MJ avatar
Written by Sreenidhi MJ
Updated over a week ago

Uniqode's Google Sheets add-on lets you bulk create and manage dynamic QR Codes directly from Google Sheets. Fetch the number of QR Code scans instantly, assign labels to organize your campaigns, and enhance team collaboration.

Prerequisites

Integrate Google Sheets with Uniqode

Install Uniqode Add-On in Google Sheets

  1. Sign in to your Google Sheets account.

  2. Click Extensions in the top menu.

  3. Click Add-ons, then click Get add-ons.

  4. In the search box, search for “Beaconstac”, then click Beaconstac.

  5. Click Install, then click Continue.

  6. Allow Uniqode to access your Google Sheets.

  7. Click Done.

Connect Google Sheets with your Uniqode account

  1. Click Extensions in the top menu.

  2. Click Beaconstac.

  3. Connect to Beaconstac account. A pop-up window will appear.

  4. Sign in to your Beaconstac account.

  5. Click Integrations in the left menu.

  6. Click Google Sheets.

  7. Copy the YOUR API KEY and ORGANIZATION ID and paste the in the API Token and Organization ID fields respectively.

  8. Click Authenticate.

Create Dynamic QR Codes using the Beaconsta add-on in Google sheets

  1. In a new sheet, enter Name, ID, Download URL, specific data related to the campaign type, and other data you would like to include, such as labels and QR Code scans in separate columns.

  2. Select the rows for which you want to create dynamic QR codes.

  3. Click Extensions in the top menu.

  4. Click Beaconstac, then click Create/update dynamic QR codes.

  5. Choose the type of code you want to create. A sidebar appears.

  6. Assign the right columns to the respective fields. Click Next.

  7. Customize your QR Code campaign by selecting a template, enabling GPS for location analytics, scheduling your QR Code Campaign, and selecting a download format.

  8. Once done, click Create/Update.

  9. Click Done.

  10. Click on the URL provided under the Download URL column to get your dynamic QR Code.

What’s next?: Improve QR Code Automation with Make (Integromat) and Workato

Did this answer your question?