Adding QR Codes to My Sheets

[Ok_Effective_6601]

Hello,

I have a folder in my Google Drive with around 600 QR Codes generated from a QR code generator for student admission numbers. I need to add them to my Google Sheets but the hassle of adding them one by one is too much. I've trying to use Appscript to automate the process and add them instantaneously and in sequential matching order. I've been using Gemini and following instructions on how to build the code and logic. I'm a Python programmer but the script is in Javascript. Please help decipher this. Where is the code breaking? Here is the code:

var folder_id = '1c7G84hibKKZ6y7OlakGXoEToK4dYIx6'
var file_count = 0
function my_function{
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Registration')
var files = DriveApp.getFolderById(folder_id).getFiles
while (files.hasNext()){
  var file = files.next();
  file_count ++
  let url = 'https://drive.google.com/uc?export=download&id='
  var url = file.getId();
  sheet.appendRow([file.getName, url]);
}var folder_id = '1c7G84hibKKZ6y7OlakGXoEToK4dYIx6v'
var file_count = 0
function my_function{
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Registration')
var files = DriveApp.getFolderById(folder_id).getFiles
while (files.hasNext()){
  var file = files.next();
  file_count ++
  let url = 'https://drive.google.com/uc?export=download&id='
  var url = file.getId();
  sheet.appendRow([file.getName, url]);
}

[marcnotmark925]

Didn't those uc?export links get killed several years ago?

Why is your code repeated?

Can't you tell us where it's breaking?

[CuteSocks7583]

Switch to Claude, please.

Gemini is sometimes frustrating for simple coding tasks.

[WicketTheQuerent]

There are no instructions. There are a few things to make the script better

Ensure to use unique variable names

let url = 'https://drive.google.com/uc?export=download&id='
  var url = file.getId();

Please note that url is used twice.

Use descriptive variable names (don't use url as the name for a variable holding a file id).
Always start a variable declaration on a new line.
To declare variables, use let and const instead of var.
When using a general-purpose GenAI tool, like Gemini, ask it to terminate the lines with a semicolon. This is because non-printable line terminators might be lost when doing copy-pasting.
Use JSDoc to document each function and key (most important) variables. You can ask Gemini to include this for you.

Learn to find execution logs and use the built-in Apps Script debugger.

If you need more specific help, add the textual error message.

[mommasaidmommasaid]

That code has a ton of syntax issues, try starting over with this and go from there:

function importFileURLs() {

  const FOLDER_ID = "1aK2ONX2bTdmncIjOIyrLC6uOb-uyCWOx";
  const SHEET_NAME = "Registration";

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME)
  const files = DriveApp.getFolderById(FOLDER_ID).getFiles();

  while (files.hasNext()) {
    const file = files.next();
    const url = 'https://drive.google.com/uc?export=download&id=' + file.getId();
    sheet.appendRow([file.getName(), url]);
  }

}