This Google Script sends a daily newsletter containing a summary of your Starred e-mails in Gmail. You can extend it to attach other information like RSS feeds, summary reports, etc.
|
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 |
var LABEL = "STARRED"; var TOTAL = 10; function Install() { ScriptApp.newTrigger("readStarredMessages").timeBased().everyDays(1).create(); } function readStarredMessages() { var thread, subject, link, body, from, date, html, emails, color, index = [], i; var mySheet = SpreadsheetApp.getActiveSpreadsheet(); emails = GmailApp.search("label:" + LABEL); var count = emails.length; if (count == 0) return; if (count > TOTAL) index = getIndex(TOTAL, 0, count); else { for (i=0; i<count; i++) index.push(i); } for (i=0; i<TOTAL; i++) { var n = index[i]; if (emails[n]) { thread = emails[n].getMessages()[0]; subject = thread.getSubject(); body = processHTML(thread.getBody(), 250); link = thread.getId(); // can also use GetPermalink() from = thread.getFrom(); date = Utilities.formatDate(thread.getDate(), Session.getTimeZone(), "MMM dd, yyyy"); if (i%2 == 0) color = "#f0f0f0"; else color = "#f9f9f9"; html += "<p>On " + date + ", <i>" + from + "</i> wrote: "; html += "<strong>" + subject + "</strong><br /><br />"; html += body + " <a href='https://mail.google.com/mail/#all/"; html += link + "'>Click to read »</a></p>"; } } html += "<p><a href='" + SpreadsheetApp.getActiveSpreadsheet().getUrl(); html += "'>click here</a> and choose Gmail > unsubscribe.</p> "; GmailApp.sendEmail(Session.getActiveUser(), emails.length + " pending messages in Gmail", "", { htmlBody: html }); } // Pick random messages from the Gmail label function getIndex(count, min, max) { var results = [], index; while ( count > 0) { randNumber = Math.round(min + Math.random() * (max - min)); if (results.indexOf(randNumber) == -1) { results.push(randNumber); count--; } } return results; } // Remove HTML tags from the Gmail messages function processHTML(html, count) { html = html.replace(/<(?:.|\n)*?>/gm, ''); html = html.replace(/^\s+|\s+$/g, ''); return html.substring(0, count); } |
Post Comments