Google AppScript syntax error for sendemail. Can't ID my problem

Question

I am trying to get Google sheets to send personalized emails from long list on another sheet in the workbook. I used a tutorial (as I am a certified novice at all coding languages) but the AppScript is telling me that line 4 has a syntax error. I cannot for the life of me figure out what I've done wrong, but I'm sure that its blatantly obvious when explained by someone with these legitimate skills. Here is the script:

function sendEmail() {
      
    var ss = SpreadsheetApp.getActiveSpreadsheet()
    var sheet1=ss.getSheetByName(‘Sheet1’);
    var sheet2=ss.getSheetByName(‘Sheet2’);
    var subject = sheet2.getRange(2,1).getValue();
    var n=sheet1.getLastRow();
    for (var i = 2; i < n+1 ; i++ ) {
    var emailAddress = sheet1.getRange(i,2).getValue();
    var name=sheet1.getRange(i,1).getValue();
    var message = sheet2.getRange(2,2).getValue();
      
    message=message.replace(“<name>”,name);
    MailApp.sendEmail(emailAddress, subject, message);
    }

    }

Anyone that could help me get this running would be a true life saver!

What is the textual error message? – Rubén Jul 18 '20 at 18:00 — Rubén, Jul 18 '20 at 18:00

Rubén · Answer 1 · 2020-07-18T20:23:30.373

The code in the question has ‘, ’ and “,” (opening/closing curly single and double quotes) instead of ' and " (straight single and double quote). Replace the first by the corresponding straight quote.

I have seen that this problem usually happens to people new to Google Apps Script that find a "nice" piece of code on a website that isn't really friendly for publishing code. It's very likely the website is using something that replaces straight quotes by the also called typographic quotes.

score 0 · Answer 2 · answered Jul 18 '20 at 14:55

0

Try to change the following code, might be you are using the wrong apostrophe and you forget to put ; in second line

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet1 = ss.getSheetByName('Sheet1');
var sheet2 = ss.getSheetByName('Sheet2');

answered Jul 18 '20 at 14:55

Rocky

950
1
7
12

Cooper · Answer 3 · 2020-07-18T19:17:28.460

function sendEmail() {
  var ss=SpreadsheetApp.getActiveSpreadsheet()
  var sheet1=ss.getSheetByName('Sheet1');
  var sheet1sr=2;//data start row
  var sheet2=ss.getSheetByName('Sheet2');
  var subject=sheet2.getRange(2,1).getValue();
  var msg=sheet2.getRange(2,2).getValue();
  var vA=sheet1.getRange(sheet1sr,1,sheet1.getLastRow()-sheet1sr+1,2).getValues();
  for (var i=0;i<vA.length;i++) {
    let message=msg;
    message=message.replace("<name>",vA[i][1]);
    if(MailApp.getRemainingDailyQuota()>0) {
      MailApp.sendEmail(vA[i][0], subject, message);
    }else{
      SpreadsheetApp.getUi().alert('Remaining Daily Quota is exhausted.')
    }
  }
}

You were using incorrect single and double quotes also

Google AppScript syntax error for sendemail. Can't ID my problem

3 Answers3

Linked