Beaconstac'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.
Note: The Google Sheets add-on is available only on the Pro plan and above.
How to install the Google Sheets add-on
Step 1: Click on Add-ons > Get add-ons.
Step 2: Search for Beaconstac in the Google Workspace Marketplace and install the add-on.
Step 3: Sign in to your Google account, and click ‘Allow’ to enable authorization for Beaconstac.
This OAuth consent screen asks for permission to make requests to the Beaconstac server to create/update QR Codes based on the data in the spreadsheet. The authorization also allows Beaconstac to read data from the spreadsheet to capture details such as the QR Code ID, download URL, and the number of QR Code scans.
You’ve now successfully installed the Google Sheets add-on.
Step 4: Click on Add-ons > Beaconstac > Connect to Beaconstac account.
Step 5: Enter the API Token and Organization ID. You’ll find these details in your Beaconstac dashboard once you log in and go to Account.
Click on ‘Authenticate’ once you’ve filled in the fields.
How to create QR Codes using the add-on
Step 1: Create a new Google Sheets spreadsheet. Add separate columns for QR Code 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.
For example, here’s a spreadsheet that contains the data required to create a Website QR Code:
Step 2: Select the row(s) for which you want to create the QR Code.
Step 3: Click on Add-ons > Beaconstac > Create/Update Dynamic QR Code, and select the campaign type from the list.
Step 4: Assign the right columns to the headers as shown below.
Step 5: Customize your QR Code campaign by selecting a template, enabling GPS for location analytics, scheduling your QR Code Campaign, and selecting a download format.
Step 6: Your QR Code has been created and is ready for download. Click on the URL provided under the ‘Download URL’ column to get your dynamic QR Code.