Gmail tips, tricks and questions

[etech0]

GSuite sent an email that they are going to stop allowing access to "Less Secure Apps". They helpfully attached a list of affected users. Is there any way for an admin or for those users to find a list of "Less Secure Apps" that they are using?

TY

[Alexsei]

Slightly OT, I remember seeing a post somewhere about a website that can add recurring google calendar events for Hebrew dates, does anyone recall?

[lcm]

Slightly OT, I remember seeing a post somewhere about a website that can add recurring google calendar events for Hebrew dates, does anyone recall?

https://myhebrewdates.com/ ?

[Alexsei]

https://myhebrewdates.com/ ?

Yes this is it, TY

[Alexsei]

Cool script I had ChatGPT write for my specific use, you can modify according to your needs

This Google Apps Script automatically compiles a digest of outstanding tasks from your Gmail labeled "Outstanding Tasks" (or any other label). It sends an email with a summary of each task, including subject, sender, last email time (with a "time ago" indication), and attachments if any. Each task's subject line is hyperlinked to open its corresponding email thread in Gmail (in the same tab without reloading) for quick access.
You can then set a trigger to send the digest to yourself (or someone else) on a schedule)

If there are no emails labeled "Outstanding Tasks," the script will not send any email. This behavior ensures that you only receive email digests when there are actual outstanding tasks to report on. Therefore, if the label contains no emails, no email digest will be generated or sent.

Code: [Select]

function sendEmailDigest() {
  // Get the label "Outstanding Tasks"
  var label = GmailApp.getUserLabelByName("Outstanding Tasks");

  // Get all threads with the label
  var threads = label.getThreads();

  // Initialize the email body
  var emailBody = "<ul>";

  // Loop through each thread
  for (var i = 0; i < threads.length; i++) {
    // Get messages in the thread
    var messages = threads[i].getMessages();
   
    // Get the last message in the thread
    var lastMessage = messages[messages.length - 1];
   
    // Get the subject, time, sender, and attachments of the last message
    var subject = lastMessage.getSubject();
    var time = formatDate(lastMessage.getDate());
    var senderName = lastMessage.getFrom().split("<")[0].trim();
    var senderEmail = lastMessage.getFrom().match(/<([^>]+)>/)[1];
    var attachments = getAttachmentsList(lastMessage);

    // Generate URL to open the specific email thread in Gmail
    var threadUrl = "https://mail.google.com/mail/u/0/#inbox/" + threads[i].getId();

    // Append subject, time, sender, and attachments to the email body in bullet list format
    emailBody += "<li><strong>Subject:</strong> <a href='" + threadUrl + "'>" + subject + "</a><br><strong>Last Email Time:</strong> " + time + " (" + getTimeAgo(lastMessage.getDate()) + ")<br><strong>Sender:</strong> " + senderName + " (" + senderEmail + ")";
    if (attachments !== "") {
      emailBody += "<br><strong>Attachments:</strong> " + attachments;
    }
    emailBody += "</li>";
   
    // Add a blank line between each email
    emailBody += "<br>";
  }
 
  emailBody += "</ul>";

  // Send the email
  MailApp.sendEmail({
    to: "your.email@example.com", // Change this to your email address
    subject: "Email Digest - Outstanding Tasks",
    htmlBody: emailBody
  });
}

function formatDate(date) {
  var formattedDate = Utilities.formatDate(date, Session.getTimeZone(), "MMMM dd, yyyy HH:mm:ss");
  return formattedDate;
}

function getAttachmentsList(message) {
  var attachments = message.getAttachments();
  var attachmentsList = "";
 
  for (var i = 0; i < attachments.length; i++) {
    attachmentsList += attachments[i].getName();
    if (i < attachments.length - 1) {
      attachmentsList += ", ";
    }
  }
 
  return attachmentsList;
}

function getTimeAgo(date) {
  var now = new Date();
  var diff = now - date;
  var seconds = Math.floor(diff / 1000);
  var minutes = Math.floor(seconds / 60);
  var hours = Math.floor(minutes / 60);
  var days = Math.floor(hours / 24);
  var months = Math.floor(days / 30);
  var years = Math.floor(days / 365);

  if (years > 0) {
    return years + (years == 1 ? " year ago" : " years ago");
  } else if (months > 0) {
    return months + (months == 1 ? " month ago" : " months ago");
  } else if (days > 0) {
    return days + (days == 1 ? " day ago" : " days ago");
  } else if (hours > 0) {
    return hours + (hours == 1 ? " hour ago" : " hours ago");
  } else if (minutes > 0) {
    return minutes + (minutes == 1 ? " minute ago" : " minutes ago");
  } else {
    return seconds + (seconds == 1 ? " second ago" : " seconds ago");
  }
}


[Yo ssi]

Is there any easy way to have a filter move to trash after a delay?

[Alexsei]

Is there any easy way to have a filter move to trash after a delay?

Believe so, ask him

[Yo ssi]

Believe so, ask him

I was referring to without AS

[Alexsei]

I was referring to without AS

I don't think that would be possible since filters process incoming mail

[etech0]

I don't think that would be possible since filters process incoming mail

Filter those emails and move/add a label. Search your inbox for

label:mylabel older_than:7d

(you can change the # of days). Copy the url from your browser and paste it into an email to yourself. When you get the email, click the link, select all, click trash, then snooze the email you sent until yourself until next week.

[Definitions2]

Cool script I had ChatGPT write for my specific use, you can modify according to your needs

This Google Apps Script automatically compiles a digest of outstanding tasks from your Gmail labeled "Outstanding Tasks" (or any other label). It sends an email with a summary of each task, including subject, sender, last email time (with a "time ago" indication), and attachments if any. Each task's subject line is hyperlinked to open its corresponding email thread in Gmail (in the same tab without reloading) for quick access.
You can then set a trigger to send the digest to yourself (or someone else) on a schedule)

If there are no emails labeled "Outstanding Tasks," the script will not send any email. This behavior ensures that you only receive email digests when there are actual outstanding tasks to report on. Therefore, if the label contains no emails, no email digest will be generated or sent.

Code: [Select]

function sendEmailDigest() {
  // Get the label "Outstanding Tasks"
  var label = GmailApp.getUserLabelByName("Outstanding Tasks");

  // Get all threads with the label
  var threads = label.getThreads();

  // Initialize the email body
  var emailBody = "<ul>";

  // Loop through each thread
  for (var i = 0; i < threads.length; i++) {
    // Get messages in the thread
    var messages = threads[i].getMessages();
   
    // Get the last message in the thread
    var lastMessage = messages[messages.length - 1];
   
    // Get the subject, time, sender, and attachments of the last message
    var subject = lastMessage.getSubject();
    var time = formatDate(lastMessage.getDate());
    var senderName = lastMessage.getFrom().split("<")[0].trim();
    var senderEmail = lastMessage.getFrom().match(/<([^>]+)>/)[1];
    var attachments = getAttachmentsList(lastMessage);

    // Generate URL to open the specific email thread in Gmail
    var threadUrl = "https://mail.google.com/mail/u/0/#inbox/" + threads[i].getId();

    // Append subject, time, sender, and attachments to the email body in bullet list format
    emailBody += "<li><strong>Subject:</strong> <a href='" + threadUrl + "'>" + subject + "</a><br><strong>Last Email Time:</strong> " + time + " (" + getTimeAgo(lastMessage.getDate()) + ")<br><strong>Sender:</strong> " + senderName + " (" + senderEmail + ")";
    if (attachments !== "") {
      emailBody += "<br><strong>Attachments:</strong> " + attachments;
    }
    emailBody += "</li>";
   
    // Add a blank line between each email
    emailBody += "<br>";
  }
 
  emailBody += "</ul>";

  // Send the email
  MailApp.sendEmail({
    to: "your.email@example.com", // Change this to your email address
    subject: "Email Digest - Outstanding Tasks",
    htmlBody: emailBody
  });
}

function formatDate(date) {
  var formattedDate = Utilities.formatDate(date, Session.getTimeZone(), "MMMM dd, yyyy HH:mm:ss");
  return formattedDate;
}

function getAttachmentsList(message) {
  var attachments = message.getAttachments();
  var attachmentsList = "";
 
  for (var i = 0; i < attachments.length; i++) {
    attachmentsList += attachments[i].getName();
    if (i < attachments.length - 1) {
      attachmentsList += ", ";
    }
  }
 
  return attachmentsList;
}

function getTimeAgo(date) {
  var now = new Date();
  var diff = now - date;
  var seconds = Math.floor(diff / 1000);
  var minutes = Math.floor(seconds / 60);
  var hours = Math.floor(minutes / 60);
  var days = Math.floor(hours / 24);
  var months = Math.floor(days / 30);
  var years = Math.floor(days / 365);

  if (years > 0) {
    return years + (years == 1 ? " year ago" : " years ago");
  } else if (months > 0) {
    return months + (months == 1 ? " month ago" : " months ago");
  } else if (days > 0) {
    return days + (days == 1 ? " day ago" : " days ago");
  } else if (hours > 0) {
    return hours + (hours == 1 ? " hour ago" : " hours ago");
  } else if (minutes > 0) {
    return minutes + (minutes == 1 ? " minute ago" : " minutes ago");
  } else {
    return seconds + (seconds == 1 ? " second ago" : " seconds ago");
  }
}


Interesting idea.
Why not just open the label folder?

[Alexsei]

Interesting idea.
Why not just open the label folder?

This may be only me, but I want an action item at a set time, meaning i actually receive an email at 10:00 daily with a digest, and I also have a daily record in case the label from an email was accidentally removed I can just look back at yesterdays digest

[yoohoo]

Anyone have issues finding emails lately ? I’m looking for an email I received a week ago. It just disappeared. I know the sender, the content and no matter what or where I search it’s gone. Happened a few times in recent months.

[Jojo202]

Anyone have issues finding emails lately ? I’m looking for an email I received a week ago. It just disappeared. I know the sender, the content and no matter what or where I search it’s gone. Happened a few times in recent months.

Someone else told me similar story and I sort of didn't believe him. Maybe they sent with with self-destruct?

[Elikip]

Any recommendations for where a beginner/amateur (With basics graphics knowledge) can create an HTML email? Just a one time project. Should have an option to upload images/collages and customize background, text, colors etc. Ready templates a plus.

[Amexpoints]

It seems that Gmail has now added the WhatsApp backup to your storage which will for most people put them well over their allowed storage. Does anyone have any clarification as to what it means if you delete your WhatsApp back up? Is deleted completely or is it still backed up by WhatsApp?

[HudZ]

It seems that Gmail has now added the WhatsApp backup to your storage which will for most people put them well over their allowed storage. Does anyone have any clarification as to what it means if you delete your WhatsApp back up? Is deleted completely or is it still backed up by WhatsApp?

You can try making a separate Google account just for WA.

[Essen est zich]

You can try making a separate Google account just for WA.

That works only if you have up to 15gb of WA. Storage.