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
Uniqode Pro plan or above with admin privileges
Must have created at least one QR code in the platform
Integrate Google Sheets with Uniqode
Install Uniqode Add-On in Google Sheets
Sign in to your Google Sheets account.
Click Extensions in the top menu.
Click Add-ons, then click Get add-ons.
In the search box, search for “Uniqode”, then click Uniqode.
Click Install, then click Continue.
Allow Uniqode to access your Google Sheets.
Click Done.
Connect Google Sheets with your Uniqode account
Click Extensions in the top menu.
Click Uniqode.
Connect to Uniqode account. A pop-up window will appear.
Sign in to your Uniqode account.
Click Integrations in the left menu.
Click Google Sheets.
Copy the YOUR API KEY and ORGANIZATION ID and paste the in the API Token and Organization ID fields respectively.
Click Authenticate.
Create Dynamic QR Codes using the Uniqode add-on in Google Sheets
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.
Select the rows for which you want to create dynamic QR Codes.
Click Extensions in the top menu.
Click Uniqode, then click Create/update dynamic QR Codes.
Choose the type of code you want to create. A sidebar appears.
Assign the right columns to the respective fields. Click Next.
Customize your QR Code campaign by selecting a template, enabling GPS for location analytics, scheduling your QR Code Campaign, and selecting a download format.
Once done, click Create/Update.
Click Done.
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