Generate QR codes using Google Apps Script

const qrFolderId = "your-target-folder-id-here";
var spreadsheetID = 'your-spreadsheet-id';
var spreadsheet  = SpreadsheetApp.openById(spreadsheetID);

function generateQRcode() {
  try {
    Logger.log("Function started");

  // Sample userId hardcoded, you can generate it dinamycally
  var newUserId= "01234";

  // Get the script URL
  const scriptUrl = ScriptApp.getService().getUrl();

  // Combine the script URL and newUserId as a parameter
  const combinedUrl = `${scriptUrl}?userId=${newUserId}`;
  Logger.log("combined URL: " + combinedUrl); // Log the combined URL

  const encodedData = encodeURIComponent(combinedUrl);
  Logger.log("encoded data: " + encodedData); // Log the encoded data

  // Generate QR code URL
  const chartUrl = `https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=${encodedData}`;

  // Fetch the QR code image
  const fetchedImage = UrlFetchApp.fetch(chartUrl).getBlob();

  // Open the Google Drive folder to save the QR code
  var qrFolder = DriveApp.getFolderById(qrFolderID);

  // Create the file in Google Drive and save the QR code image
  const file = qrFolder.createFile(fetchedImage);
  file.setName(`QRCode_${new Date().getTime()}.png`);

  // Get the file ID
  const fileId = file.getId();
    spreadsheet.getSheetByName("your-sheet-name-here").appendRow([
    file.getName(),
    "https://drive.google.com/uc?id="+fileId
    Utilities.formatDate(new Date(), "GMT-4", "MM/DD/YYYY")
    ]);

  } catch (error) {
    Logger.log("An error occurred: " + error.toString());
  }
}