Through the Zapier integration provided by Beaconstac, you can automatically change the destination URL of your dynamic QR codes by using the Google Sheets.
For this integration, you must create a sheet with the QR code’s name and Website URL. Optionally, if you want to save the respective QR code’s ID and downloadable link, you can add QR Code ID and Download URL, in the consecutive columns.
Create a Zap template to Automate Updation of Dynamic QR Code with Google Sheets
Sign in to your Zapier account.
Click Zaps in the left menu.
Click Create in the top-right, then click New Zap.
Set up Trigger
In the Trigger section, choose Google Sheets.
Choose New or Updated Spreadsheet Row from the drop-down in the Event field.
Click Sign in, to sign in to your Google account.
In the Set up trigger section, choose the required spreadsheet, worksheet, and the column in which the URL will be updated.
Click Test Trigger. If the account connected is right, the data will be fetched from the selected sheet.
Set up Action
In the Action section, choose Beaconstac.
Choose to Update Dynamic QR Code from the drop-down in the Event field.
Choose your Beaconstac account or sign into another Beaconstac account that you want to create the Action for, then click Continue.
In the Set up action section, enter QR Code Name, QR Code ID, Design,Template, and for the Campaign Type, select Website URL. In the Website URL field, choose the column nae with the URLs that will be updated.
Note: To find the QR Code ID, you can go to the QR Codes page in your Beaconstac dashboard and click Edit besides your QR code. The ID will be the part of the QR code’s URL. For example, if https://dashboard.beaconstac.com/qr-codes/123456#campaign is the URL of the QR code, then 123456 is the QR code’s ID.
Click Test action if you want to check whether everything is configured correctly.
Click Publish Zap.
Click Publish & Turn On.
Now every time you update the URL in Google Sheets, the respective QR code’s URL will be changed automatically.
If you want to create and update dynamic QR codes in bulk, you can also use Beaconstac’s plugin in Google Sheets to autoate the creation and updation of QR codes. Learn more