logo
APIAutomations•

Create a QR code for each Google Sheets row with Make

Make a QR code for every new Google Sheets row with a ready-made Make template: map URL and Title, and get the QR Code ID and PNG link back in the row.

Avatar for undefined
CodeQR Team
Content Team

Every new row in a Google Sheets spreadsheet gets its own QR code, and the QR Code ID and a link to the QR code as a PNG are written back into that row. A ready-made Make template handles it: you connect Google and CodeQR once, map two fields, and turn it on.

Availability

  • Plan: the template works on every Make plan. Make counts each module run as an operation, so a long list needs a Make plan with enough monthly operations. On the CodeQR side, the codes this template creates are static: they are unlimited on Pro, Business, Scale and Enterprise, and on Free and Starter they count toward the monthly QR code limit. See pricing for your plan.
  • Where: Make, using the CodeQR app. You also need a Google account that owns the spreadsheet and a CodeQR account.

Before you start

  • Create a Make account if you do not have one. Have your Google account and your CodeQR account ready.
  • Set up the spreadsheet with one row per item and four headers in row 1: URL, Title, QR Code ID and QR Code Image. Fill in URL (starting with https://) and Title, and leave the other two columns empty, because the scenario fills them.
  • Decide what the code should open. A static code stores the URL itself in the pattern. A scan opens that URL directly and never passes through CodeQR, so CodeQR records no scans for it and the destination cannot change after you print it.

Steps

  1. Open the Sheets rows template and sign in to Make.
  2. In the guided setup, add your Google connection and pick the spreadsheet and the tab that hold your list.
  3. Add your CodeQR connection: sign in to CodeQR and allow Make to access the project the codes should belong to.
  4. Map the fields: your URL column to URL and your title column to Title. The step that writes the result back is already set up and the guided setup skips it. It fills QR Code ID and QR Code Image in the same row.
  5. Click Run once with one or two test rows.
  6. Turn the scenario on. Make asks where to start. Choose All to process the rows that are already in the sheet, or From now on to handle only rows added after this moment.

Verify it works

  • Check the row you tested: QR Code ID and QR Code Image are filled in, and URL and Title are unchanged.
  • Open the PNG link. The image is a 1024 px PNG of the code. Scan it with your phone: it opens the URL from the row.
  • In CodeQR, open QR Codes and look for the new code under the title you mapped.

Troubleshooting

A column you added stays empty

If you change the template and map the CodeQR module's "QR Code URL" output, that column stays empty because the API does not return that field. Map Image URL instead, which is the link to the PNG.

New rows are not picked up right away

The Google Sheets trigger checks for new rows on the scenario's schedule, which is every 15 minutes in the templates, so new rows are not picked up instantly. Wait for the next check, or use Run once in Make to process them now.

The connection asks you to sign in again

The Google or CodeQR connection lost its authorization. Open the connection in Make and reauthorize it, then run the scenario again. If the CodeQR step returns an error code instead, see Fix API errors 401, 403, 404, 409, and 429.

The other templates

The same setup applies to the other templates. Each one starts from a sheet or a request and ends with a PNG link:

  • Serial numbers: a Serial Number and a URL per row, and the code is named by the serial.
  • Labels: a Label Text and a URL per row, with the PNG link ready for a label or mail-merge tool.
  • Asset tags: an Asset Tag, an Asset Name and a URL per row, and the code is named with the tag followed by the asset name.
  • Event tickets: each new registration row becomes a dynamic code that expires on the date you set, and Gmail sends the QR code by email. It needs the Starter plan or above.
  • Webhook: send a token, a URL and a title to a Make webhook URL, and it answers with the code's id, short link and image. A wrong or missing token creates nothing, and an invalid URL returns 400. This one runs instantly.

There is no Excel template. You can rebuild the Sheets template with Make's Microsoft 365 Excel "Watch Worksheet Rows" module.

Use the template

Open the Create a QR code for each new Google Sheets row template in Make and follow the guided setup above.

Related articles