First, copy the template by clicking the link below.
QR Code Generator Template by Lido.app
A tab containing a prompt asking you to copy the spreadsheet to your Google account appears. Click Make a copy.
You will get a copy of the template with the following sheet:
You just need to input the content or link you want to convert to QR Code in the cells in Column A, below the heading Content. There is sample content added in the sheet, a link and a word, with their corresponding QR codes. Feel free to delete them and add your own.
For our example, we want to generate QR codes for the Lido.app website and the corresponding signup page.
Once you added the content to be converted to QR codes, click Generate QR Code.
On the first run, you will be asked to authorize the script attached to the spreadsheet. Click OK.
A new window will load. You will be asked first to choose the Google account that will run the script. Select the account you are using in the list. Most of the time, only the active account will be listed.
You will next get the message that Google hasn’t verified the script. Click the small link labeled Advanced. Another link will appear below it. Click Go to qrfunction (unsafe).
Next, a list of permissions needed by the script will be listed.
Click Allow. The window will close.
The spreadsheet now works. Click Generate QR Code again, and the results will load!
As an additional tip, you can clear all the QR codes in the sheet by clicking Clear all QR Codes. This will help you easily start anew in your task. Quick and easy!
