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, Plus and Enterprise plans

How to install the Google Sheets add-on

Step 1: Install the Beaconstac add-on

Click on Add-ons > Get add-ons.

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

Step 2: Allow authorization for Beaconstac

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 3: Connect Google Sheets to your Beaconstac account

Click on Add-ons > Beaconstac > Connect to Beaconstac account.

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 Google Sheets add-on

Step 1: Create the spreadsheet

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 data

Select the row(s) for which you want to create the QR Code.

Step 3: Setup the creation workflow

Click on Add-ons > Beaconstac > Create/Update Dynamic QR Code, and select the campaign type from the list.

Assign the right columns to the headers as shown below. Once done, click 'Next'.

Step 4: Customize QR Code

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'.

Step 5: Download QR Code

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.

Read next: Improve QR Code Automation with Integromat and Workato

Related to this article: Automate QR Code campaigns with Zapier | Bulk uploading dynamic QR codes using Zapier | Ready-to-use Zap Templates for automating workflows

Did this answer your question?