Connect your QR codes to the tools you use

1. Open the Google Sheet you want the leads in, then choose Extensions, Apps Script.
2. Delete what is there and paste the script below.
3. Open the tool, then choose Deploy, New deployment, Web app. Set "Who has access" to Anyone and press Deploy.
4. Copy the web app address (it starts with https://script.google.com/macros/).
5. Add it here as a webhook for New lead, then press Send test. Every new lead now adds a row.

function doPost(e) {
  var event = JSON.parse(e.postData.contents);
  if (event.type !== "lead.captured") return ContentService.createTextOutput("ignored");
  var lead = event.data.lead;
  SpreadsheetApp.getActiveSheet().appendRow([
    new Date(lead.submitted_at), event.data.code.label, lead.name, lead.email, lead.phone
  ]);
  return ContentService.createTextOutput("ok");
}

This message carries a visitor’s name, email or phone. You are responsible for how it is used, and for having their consent.

1. Open an empty Google Sheet, then choose Extensions, Apps Script.
2. Paste the script below. It writes the question names as the first row by itself.
3. Open the tool, then choose Deploy, New deployment, Web app. Set "Who has access" to Anyone and press Deploy.
4. Copy the web app address (it starts with https://script.google.com/macros/).
5. Add it here as a webhook for Form response, pick the form's folder or leave it for all, then press Send test.

function doPost(e) {
  var event = JSON.parse(e.postData.contents);
  if (event.type !== "form.response") return ContentService.createTextOutput("ignored");
  var sheet = SpreadsheetApp.getActiveSheet();
  var r = event.data.response;
  if (sheet.getLastRow() === 0) sheet.appendRow(["Submitted"].concat(r.columns));
  sheet.appendRow([new Date(r.submitted_at)].concat(r.values));
  return ContentService.createTextOutput("ok");
}

This message carries a visitor’s name, email or phone. You are responsible for how it is used, and for having their consent.

1. Open an empty Google Sheet, then choose Extensions, Apps Script.
2. Paste the script below.
3. Open the tool, then choose Deploy, New deployment, Web app. Set "Who has access" to Anyone and press Deploy.
4. Copy the web app address (it starts with https://script.google.com/macros/).
5. Add it here as a webhook for Scan batch. Scans arrive every few minutes in a group, not one at a time.

function doPost(e) {
  var event = JSON.parse(e.postData.contents);
  if (event.type !== "scan.batch") return ContentService.createTextOutput("ignored");
  var sheet = SpreadsheetApp.getActiveSheet();
  if (sheet.getLastRow() === 0) sheet.appendRow(["Time", "Code", "Device", "System", "Browser", "Country", "From"]);
  event.data.scans.forEach(function (s) {
    sheet.appendRow([new Date(s.at), s.code.label, s.device, s.os, s.browser, s.country, s.referrer]);
  });
  return ContentService.createTextOutput("ok");
}

1. In Slack create an Incoming Webhook for the channel you want and copy its address.
2. Open a new Google Apps Script project and paste the script below.
3. In Project Settings, Script properties add SLACK_URL with the Slack address as its value.
4. Open the tool, then choose Deploy, New deployment, Web app. Set "Who has access" to Anyone and press Deploy.
5. Copy the web app address (it starts with https://script.google.com/macros/).
6. Add the web app address here as a webhook for New lead and press Send test.

// In the Apps Script editor open Project Settings, add a Script property named SLACK_URL
// and paste your Slack incoming webhook address as its value.
function doPost(e) {
  var event = JSON.parse(e.postData.contents);
  if (event.type !== "lead.captured") return ContentService.createTextOutput("ignored");
  var lead = event.data.lead;
  var text = "New lead from " + event.data.code.label + ": " + (lead.name || "no name") +
    (lead.phone ? ", " + lead.phone : "") + (lead.email ? ", " + lead.email : "");
  UrlFetchApp.fetch(PropertiesService.getScriptProperties().getProperty("SLACK_URL"), {
    method: "post", contentType: "application/json", payload: JSON.stringify({ text: text })
  });
  return ContentService.createTextOutput("ok");
}

Slack does not read QR Studio's message directly, so a small script in the middle turns it into a sentence.

This message carries a visitor’s name, email or phone. You are responsible for how it is used, and for having their consent.

1. Make an incoming webhook in your chat tool for the room you want, and copy its address.
2. Open a new Google Apps Script project and paste the script below.
3. In Project Settings, Script properties add CHAT_URL (the address) and CHAT (the word slack, discord or google).
4. Open the tool, then choose Deploy, New deployment, Web app. Set "Who has access" to Anyone and press Deploy.
5. Copy the web app address (it starts with https://script.google.com/macros/).
6. Add the web app address here as a webhook for Milestone reached and press Send test.

// Script properties: CHAT_URL = your incoming webhook address, CHAT = slack, discord or google
function doPost(e) {
  var event = JSON.parse(e.postData.contents);
  if (event.type !== "milestone.reached") return ContentService.createTextOutput("ignored");
  var p = PropertiesService.getScriptProperties();
  var d = event.data;
  var text = d.code.label + " passed " + d.milestone + " scans (" + d.total_scans + " so far)";
  var body = p.getProperty("CHAT") === "discord" ? { content: text } : { text: text };
  UrlFetchApp.fetch(p.getProperty("CHAT_URL"), { method: "post", contentType: "application/json", payload: JSON.stringify(body) });
  return ContentService.createTextOutput("ok");
}

1. In Telegram talk to @BotFather, make a bot, and keep the token it gives you.
2. Send your new bot any message, then find your chat number (search for "telegram getUpdates chat id" for the one-minute way).
3. Open a new Google Apps Script project and paste the script below.
4. In Project Settings, Script properties add TELEGRAM_TOKEN and TELEGRAM_CHAT.
5. Open the tool, then choose Deploy, New deployment, Web app. Set "Who has access" to Anyone and press Deploy.
6. Copy the web app address (it starts with https://script.google.com/macros/).
7. Add the web app address here as a webhook for Destination broken and press Send test.

// Script properties: TELEGRAM_TOKEN = the token from BotFather, TELEGRAM_CHAT = your chat number
function doPost(e) {
  var event = JSON.parse(e.postData.contents);
  if (event.type !== "destination.broken") return ContentService.createTextOutput("ignored");
  var p = PropertiesService.getScriptProperties();
  var d = event.data;
  var text = "Check this QR code: " + d.code.label + ". Its page on " + d.destination_host +
    " is not loading" + (d.http_status ? " (error " + d.http_status + ")" : "") + ".";
  UrlFetchApp.fetch("https://api.telegram.org/bot" + p.getProperty("TELEGRAM_TOKEN") + "/sendMessage", {
    method: "post", contentType: "application/json",
    payload: JSON.stringify({ chat_id: p.getProperty("TELEGRAM_CHAT"), text: text })
  });
  return ContentService.createTextOutput("ok");
}

1. Make a new workflow whose first step is a webhook: Webhooks by Zapier, Catch Hook, Make's Custom webhook, n8n's Webhook node, or Pabbly's Webhook trigger.
2. Copy the address it gives you and add it here as a webhook. Choose the events you care about.
3. Press Send test so the tool sees the shape of the data, then add your next step: Google Sheets, an email, a CRM, a message.

The tools have free and paid plans of their own. QR Studio only sends the message.

This message carries a visitor’s name, email or phone. You are responsible for how it is used, and for having their consent.

1. Start a workflow in Zapier, Make or Pabbly Connect with a webhook as its first step (see the recipe above).
2. Add this webhook address here for New lead, then press Send test.
3. Add a WhatsApp step from a provider you have an account with (WhatsApp Business through Twilio, Gupshup, Interakt, Wati and others) and use the lead's phone and name from the test message.
4. Only message people who ticked the consent box on your code. The message carries consent: true for that reason.

WhatsApp charges per message, and a business message needs an approved template. Both are between you and the provider.

This message carries a visitor’s name, email or phone. You are responsible for how it is used, and for having their consent.

1. Run the script below somewhere with a public https address (for example behind your web server).
2. Set the environment variable QRSTUDIO_SECRET to the signing secret shown once when you make the webhook.
3. Add your https address here as a webhook and press Send test. Reply with any 2xx status within 5 seconds, or the message is tried again.

const http = require("node:http");
const crypto = require("node:crypto");

// The signing secret QR Studio showed once when you made the webhook.
const SECRET = process.env.QRSTUDIO_SECRET;

function isFromQrStudio(raw, header) {
  const parts = Object.fromEntries(header.split(",").map((p) => p.split("=")));
  if (!parts.t || !parts.v1) return false;
  if (Math.abs(Date.now() / 1000 - Number(parts.t)) > 300) return false; // too old
  const expected = crypto.createHmac("sha256", SECRET).update(parts.t + "." + raw).digest("hex");
  const a = Buffer.from(expected);
  const b = Buffer.from(parts.v1);
  return a.length === b.length && crypto.timingSafeEqual(a, b);
}

http.createServer((req, res) => {
  const chunks = [];
  req.on("data", (c) => chunks.push(c));
  req.on("end", () => {
    const raw = Buffer.concat(chunks).toString("utf8");
    if (!isFromQrStudio(raw, req.headers["x-qrstudio-signature"] || "")) {
      res.statusCode = 401;
      return res.end("bad signature");
    }
    const event = JSON.parse(raw);
    console.log(event.type, JSON.stringify(event.data));
    res.end("ok");
  });
}).listen(3000);

This message carries a visitor’s name, email or phone. You are responsible for how it is used, and for having their consent.