Google Apps Script报错：第44行var意外语法错误的排查与疑问

语法错误的直接原因 #

• formData拼接末尾冗余符号：在formData的最后一行，+ p2email +后面直接接var finalURL，多余的+破坏了语法结构，这是触发syntax error unexpected token var的核心原因。
• 多处拼接语法遗漏：
  • &entry.1710226101后缺少=，应为&entry.1710226101=
  • + add + "entry.2057643731="中entry前缺少&，应为+ add + "&entry.2057643731="
  • &entry.1096702233后缺少=，应为&entry.1096702233=
• formURL赋值未加分号：formURL ="https://docs.google.com/forms/d/..."行尾无分号，虽JS支持自动分号，但易引发解析异常。

变量位置调整的可行性 #

将finalURL和options移到formURL与formData上方是可行的——只要变量在被调用前完成赋值，JS就可以正常解析。不过从代码可读性和逻辑合理性来看，保持变量在使用前定义（比如在formData拼接完成后再声明finalURL）会更清晰，避免逻辑混乱。

修正后的完整代码 #

function autoEntry() { 
  var wrkBk = SpreadsheetApp.getActiveSpreadsheet(); 
  var wrkSht = wrkBk.getSheetByName("Data"); 
  var formURL = ""; 
  var formData = ""; 
  var email = ""; 
  var wherefound = ""; 
  var contest = ""; 
  var contest2 = ""; 
  var p1name = ""; 
  var phone = ""; 
  var email1 = ""; 
  var college = ""; 
  var team = ""; 
  var add = ""; 
  var p2name = ""; 
  var p2phone = ""; 
  var p2email = ""; 
  var noOfrows = 11; 

  for (let i=2;i<=noOfrows;i++) { 
    email = wrkSht.getRange("A" + i).getDisplayValue(); 
    wherefound = wrkSht.getRange("B" + i).getDisplayValue(); 
    contest = wrkSht.getRange("C" + i).getDisplayValue(); 
    contest2 = wrkSht.getRange("D" + i).getDisplayValue(); 
    p1name = wrkSht.getRange("E" + i).getDisplayValue(); 
    phone = wrkSht.getRange("F" + i).getDisplayValue(); 
    email1 = wrkSht.getRange("G" + i).getDisplayValue(); 
    college = wrkSht.getRange("I" + i).getDisplayValue(); 
    team = wrkSht.getRange("I" + i).getDisplayValue(); 
    add = wrkSht.getRange("J" + i).getDisplayValue(); 
    p2name = wrkSht.getRange("H" + i).getDisplayValue(); 
    p2phone = wrkSht.getRange("F" + i).getDisplayValue(); 
    p2email = wrkSht.getRange("G" + i).getDisplayValue(); 

    formURL = "https://docs.google.com/forms/d/1CBfK0vGAJhU2zUlAYQS75qX0a79n52o_j5xRobd9ElM/formResponse?&pageHistory=0,1,2";
    formData = "&emailAddress=" + email + 
               "&entry.985288382=" + wherefound + 
               "&entry.1403417779=" + contest + 
               "&entry.1403417779=" + contest2 + 
               "&entry.840653442=" + p1name + 
               "&entry.333445391=" + phone + 
               "&entry.1710226101=" + email1 + 
               "&entry.1025973123=" + college + 
               "&entry.1833616786=" + team + 
               "&entry.1627866442=" + add + 
               "&entry.2057643731=" + p1name + 
               "&entry.1510242317=" + phone + 
               "&entry.1096702233=" + email1 + 
               "&entry.1638965943=" + p2name + 
               "&entry.699293629=" + p2phone + 
               "&entry.811372241=" + p2email;

    var finalURL = formURL + formData; 
    var options = {"method": "post"}; 
    UrlFetchApp.fetch(finalURL, options); 
  } 
}

额外优化建议 #

• 批量读取数据提升效率：当前循环多次调用getRange和getDisplayValue会拖慢执行速度，建议用wrkSht.getDataRange().getDisplayValues()一次性读取所有数据，再通过数组索引获取对应单元格值。
• 规范变量作用域：循环中的i未用let/const声明，会成为全局变量，建议改为for (let i=2;i<=noOfrows;i++)。

内容的提问来源于stack exchange，提问作者Achillies Clash