Create calendar event from Gmail?

Question

I found the following code online but can't remember where I got it from. The script will search for any emails with a specific label (in this case "GReminder") and add those emails into your calendar. I tried to set this up but I'm getting the error message:

TypeError: label.getThreads is not a function

I'm not familiar with Javascript and I'm not a software developer by any means. I've tried to modify it but couldn't get it to work. Hoping someone can help me here. Here is the code below:

function gMailReminder() {
  var reminderLabel = "GReminder", //Substitute your label here
      calendarName = "Mobile Calendar", ////Substitute your Calendar name here
      reminderDuration = 2, //duration in hours
      label = GmailApp.getUserLabelByName(reminderLabel),
      threads = label.getThreads();
  
  if (threads.length > 0) {
    //get calendar by name
    var cals = CalendarApp.getCalendarsByName(calendarName);
          
    var now = new Date().getTime();
    for (i in threads) {
      cals[0].createEvent(reminderLabel + '- '+threads[0].getFirstMessageSubject(),
        new Date(now+(60000*60*reminderDuration)),
          new Date(now+(60000*60*reminderDuration)), {description: threads[i].getPermalink()});
    }
    //Remove the label from the mails to avoid duplicate event creation on next run 
    label.removeFromThreads(threads);
  }
}

Furthermore, the code searches for the label "GReminder" and then removes that label at the end of the script. I'd like to modify this so that the script searches for GReminder in Gmail, then adds a new GReminder-Processed label to it (to show that those emails have been "processed") and then the next time it runs again, it will skip emails with GReminder-Processed. I've only gotten the part of creating the labels sorted (I think), but can't figure out the rest...

function getOrCreateLabel(labelName) {
  var label = GmailApp.getUserLabelByName(labelName);
  if (label == null) {
    label = GmailApp.createLabel(labelName);
  }
  return label;
}


  var label = getOrCreateLabel("Bill Reminder - processed"); 
  thread.addLabel(label);

Answer 1

function gMailReminder() {
  const rlbl = "GReminder";
  const rdur = 2;
  const label = GmailApp.getUserLabelByName(rlbl);
  const threads = label.getThreads();
  const cal = CalendarApp.getCalendarsByName("Mobile Calendar")[0];
  if (threads.length > 0) {
    threads.forEach(t => {
      let now = new Date().getTime();
      cal.createEvent(rlbl + '- ' + t.getFirstMessageSubject(), new Date(now), new Date(now + (60000 * 60 * rdur)), { description: t.getPermalink() });
    });
    label.removeFromThreads(threads);
  }
}

I think probably your label name is wrong:

Here's a function to get your label names:

function getUserLabels() {
  const labels = GmailApp.getUserLabels();
  let html = '';
  labels.forEach(l => {
    html += `<br>Name: ${l.getName()}`
  });
  SpreadsheetApp.getUi().showModelessDialog(HtmlService.createHtmlOutput(html),'Label Names');
 }

I modified your code to test the label names:

function gMailReminder() {
  const rlbl = "Qs/Services/Google";
  const label = GmailApp.getUserLabelByName(rlbl);
  const threads = label.getThreads();
  let html ='';
  if (threads.length > 0) {
    threads.forEach(t => {
      html += `<br>${t.getFirstMessageSubject()}`;
    });
    SpreadsheetApp.getUi().showModelessDialog(HtmlService.createHtmlOutput(html),'Subjects');
  }
}

And this now works

Answer 2

Came up with the solution myself.

As you can see, my label has Chinese characters and GmailApp.Search has no problem with this.

However, LABEL_DONE requires you to put in I guess the unicode (or whatever it's called) of the Chinese characters. Again, I don't know anything about Javascript and so a lot of my code is just copying and pasting code from somewhere else and modifying them to the best of my extent. I had to do a bit of debugging to find out what my Chinese label looks like in the Logger. The result provided by the Logger is the unicode that you see for LABEL_DONE. If you also use non-English characters for your labels, you'll need to test it yourself and find what the corresponding unicode string is.

Anyway, the code below will use GmailApp.Search to search for specific labels (you can mix and match search conditions in there and can test this easily in Gmail search itself). It will then add the emails for those specific labels into Google Calendar, then apply a "Bill Reminder - Processed" label. The next time the Google App Script trigger runs, it will skip these emails, because of the Processed label.

// https://stackoverflow.com/questions/12377640/printing-to-the-console-in-google-apps-script

function testLog(){
  Logger.log("Logger.log");
  console.log("console.log")
}



function BillReminder_Rates() {

  if (!GmailApp) return; // Skip script execution if GMail is currently not available (yes this happens from time to time and triggers spam emails!)
  
  var reminderLabel = "電費,-水費,-垃圾袋,-網路-bill-reminder---processed", //Substitute your label here
      calendarName = "Reminders", ////Substitute your Calendar name here
      reminderDuration27Days = 648; //duration in hours;

  
  var threads = GmailApp.search('(label:電費,-水費,-垃圾袋,-網路-council-rates---me) AND (-label:電費,-水費,-垃圾袋,-網路-bill-reminder---processed)');

  
  if (threads.length > 0) {
    //get calendar by name
    var cals = CalendarApp.getCalendarsByName(calendarName);
          
    var now = new Date().getTime();
    for (i in threads) {
      //cals[0].createEvent(reminderLabel + ' - '+threads[i].getFirstMessageSubject(),
      cals[0].createEvent(threads[i].getFirstMessageSubject(),
        new Date(now+(60000*60*reminderDuration27Days)),
          new Date(now+(60000*60*reminderDuration27Days)), {description: threads[i].getPermalink()});
    }

 
    LABEL_DONE = "\u96fb\u8cbb, \u6c34\u8cbb, \u5783\u573e\u888b, \u7db2\u8def/Bill Reminder - Processed";
    var label_done = GmailApp.getUserLabelByName(LABEL_DONE);


    for (var t in threads) {
      var threadblah = threads[t];

      // Grab the task data
      var taskTitle = threadblah.getFirstMessageSubject();

      // Insert the task
      //addTask_(taskTitle, TASKLIST);

      // Set to 'done' by exchanging labels
      //threadblah.removeLabel(label_pending);
      threadblah.addLabel(label_done);  
    }
  
  }
  
}







function BillReminder_Power_Gas() {

  if (!GmailApp) return; // Skip script execution if GMail is currently not available (yes this happens from time to time and triggers spam emails!)


  var reminderLabel = "電費,-水費,-垃圾袋,-網路-bill-reminder---processed", //Substitute your label here
      calendarName = "Reminders", ////Substitute your Calendar name here
      reminderDuration12Days = 288; //duration in hours;

  
  var threads = GmailApp.search('(label:電費,-水費,-垃圾袋,-網路-power -OR label:電費,-水費,-垃圾袋,-網路-gas) AND (-label:電費,-水費,-垃圾袋,-網路-bill-reminder---processed)');

  if (threads.length > 0) {
    //get calendar by name
    var cals = CalendarApp.getCalendarsByName(calendarName);
          
    var now = new Date().getTime();
    for (i in threads) {
      //cals[0].createEvent(reminderLabel + ' - '+threads[i].getFirstMessageSubject(),
      cals[0].createEvent(threads[i].getFirstMessageSubject(),
        new Date(now+(60000*60*reminderDuration12Days)),
          new Date(now+(60000*60*reminderDuration12Days)), {description: threads[i].getPermalink()});
    }

    LABEL_DONE = "\u96fb\u8cbb, \u6c34\u8cbb, \u5783\u573e\u888b, \u7db2\u8def/Bill Reminder - Processed";

    var label_done = GmailApp.getUserLabelByName(LABEL_DONE);

    for (var t in threads) {
      var threadblah = threads[t];

      // Grab the task data
      var taskTitle = threadblah.getFirstMessageSubject();

      // Insert the task
      //addTask_(taskTitle, TASKLIST);

      // Set to 'done' by exchanging labels
      //threadblah.removeLabel(label_pending);
      threadblah.addLabel(label_done);  
    }
  
  }
  
}





function BillReminder_Water() {

  if (!GmailApp) return; // Skip script execution if GMail is currently not available (yes this happens from time to time and triggers spam emails!)


  var reminderLabel = "電費,-水費,-垃圾袋,-網路-bill-reminder---processed", //Substitute your label here
      calendarName = "Reminders", ////Substitute your Calendar name here
      reminderDuration15Days = 360; //duration in hours;
  
  var threads = GmailApp.search('(label:電費,-水費,-垃圾袋,-網路-watercare---me) AND (-label:電費,-水費,-垃圾袋,-網路-bill-reminder---processed)');


  if (threads.length > 0) {
    //get calendar by name
    var cals = CalendarApp.getCalendarsByName(calendarName);
          
    var now = new Date().getTime();
    for (i in threads) {
      //cals[0].createEvent(reminderLabel + ' - '+threads[i].getFirstMessageSubject(),
      cals[0].createEvent(threads[i].getFirstMessageSubject(),
        new Date(now+(60000*60*reminderDuration15Days)),
          new Date(now+(60000*60*reminderDuration15Days)), {description: threads[i].getPermalink()});
    }
 

    LABEL_DONE = "\u96fb\u8cbb, \u6c34\u8cbb, \u5783\u573e\u888b, \u7db2\u8def/Bill Reminder - Processed";
    var label_done = GmailApp.getUserLabelByName(LABEL_DONE);

    for (var t in threads) {
      var threadblah = threads[t];

      // Grab the task data
      var taskTitle = threadblah.getFirstMessageSubject();

      // Insert the task
      //addTask_(taskTitle, TASKLIST);

      // Set to 'done' by exchanging labels
      //threadblah.removeLabel(label_pending);
      threadblah.addLabel(label_done);  
    }
  
  }
  
}





function delete_events()
{
  //take care: Date function starts at 0 for the month (January=0)
  //{search: 'cycle'+"*"+'Checkpoint'} hier zijn de search terms
  var fromDate = new Date(2021,6,1,0,0,0); //This is July 1, 2021
  var toDate = new Date(2021,11,1,0,0,0);   //This is September 1, 2021 at 00h00'00"
  var calendarName = 'Reminders';
  var toRemove = 'title_of_the_events';

  var calendar = CalendarApp.getCalendarsByName(calendarName)[0];
  var events = calendar.getEvents(fromDate, toDate,{search: toRemove});
  for(var i=0; i<events.length;i++)
  {
    var ev = events[i];
    if(ev.getTitle()==toRemove) //check if the title matches
    {
      Logger.log('Item '+ev.getTitle()+' found on '+ev.getStartTime()); // show event name and date in log
      ev.deleteEvent(); //uncomment this line to actually do the delete !
    }
  }
}


function delete_events2()
{
    var fromDate = new Date(2021,8,1,0,0,0); 
    var toDate = new Date(2021,11,27,0,0,0);
    var calendarName = 'Reminders';

    // delete from Jan 1 to end of Jan 4, 2013 (for month 0 = Jan, 1 = Feb...)

    var calendar = CalendarApp.getCalendarsByName(calendarName)[0];
    var events = calendar.getEvents(fromDate, toDate);
    for(var i=0; i<events.length;i++){
      var ev = events[i];
      Logger.log(ev.getTitle()); // show event name in log
      ev.deleteEvent();
    }
 }