/**
* Daily Inbox Digest (no AI)
* Pulls Gmail from the last 24 hours and emails you a sorted digest.
*/
const CONFIG = {
QUERY: 'newer_than:1d -from:me -category:promotions -category:social -category:updates -category:forums ' +
'-from:noreply -from:no-reply -from:donotreply ' +
'-subject:invitation -filename:ics -subject:accepted -subject:declined -subject:tentative',
MAX_THREADS: 100,
SNIPPET_LENGTH: 160,
// Always flagged, and never filtered out as a newsletter
VIP_SENDERS: [
'name@berkeley.edu',
'vcf@berkeley.edu'
],
// Subject or body containing any of these gets flagged as priority
FLAG_KEYWORDS: [
'urgent', 'asap', 'deadline', 'due', 'by eod', 'by friday',
'action required', 'approval', 'approve', 'decision', 'sign off', '?'
]
};
function sendDailyDigest() {
const cutoff = new Date(Date.now() - 24 * 60 * 60 * 1000);
const threads = GmailApp.search(CONFIG.QUERY, 0, CONFIG.MAX_THREADS);
const priority = [];
const everythingElse = [];
threads.forEach(thread => {
const recent = thread.getMessages().filter(m => m.getDate() > cutoff);
if (recent.length === 0) return;
const latest = recent[recent.length - 1];
const from = latest.getFrom();
// Skip newsletters and mailing lists unless the sender is a VIP
const isVip = CONFIG.VIP_SENDERS.some(v => from.toLowerCase().includes(v.toLowerCase()));
if (latest.getHeader('List-Unsubscribe') && !isVip) return;
const subject = latest.getSubject() || '(no subject)';
const body = latest.getPlainBody().replace(/\s+/g, ' ').trim();
const reasons = flagReasons(thread, isVip, subject, body);
const item = {
from: cleanSender(from),
subject: subject,
time: Utilities.formatDate(latest.getDate(), Session.getScriptTimeZone(), 'h:mm a'),
snippet: body.substring(0, CONFIG.SNIPPET_LENGTH),
count: recent.length,
unread: thread.isUnread(),
reasons: reasons,
link: 'https://mail.google.com/mail/u/0/#all/' + thread.getId()
};
(reasons.length > 0 ? priority : everythingElse).push(item);
});
const me = Session.getActiveUser().getEmail();
const dateLabel = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), 'EEE MMM d');
const total = priority.length + everythingElse.length;
if (total === 0) {
MailApp.sendEmail(me, 'Inbox digest ' + dateLabel + ': nothing new', 'No new email in the last 24 hours.');
return;
}
const html =
'<div style="font-family:Arial,sans-serif;font-size:14px;color:#222;">' +
'<p><b>' + total + ' threads</b> in the last 24 hours. ' +
priority.length + ' flagged for a closer look.</p>' +
section('Look at these first', priority, true) +
section('Everything else', everythingElse, false) +
'</div>';
MailApp.sendEmail({
to: me,
subject: 'Inbox digest ' + dateLabel + ' (' + priority.length + ' flagged / ' + total + ' total)',
htmlBody: html
});
}
function flagReasons(thread, isVip, subject, body) {
const reasons = [];
const text = (subject + ' ' + body.substring(0, 2000)).toLowerCase();
if (isVip) reasons.push('VIP');
if (thread.isImportant()) reasons.push('Gmail important');
if (thread.hasStarredMessages()) reasons.push('Starred');
const hits = CONFIG.FLAG_KEYWORDS.filter(k => k !== '?' && text.includes(k));
if (hits.length) reasons.push('Keyword: ' + hits.slice(0, 2).join(', '));
if (CONFIG.FLAG_KEYWORDS.includes('?') && body.substring(0, 1500).includes('?')) reasons.push('Question');
return reasons;
}
function section(title, items, showReasons) {
if (items.length === 0) return '';
const rows = items.map(i =>
'<tr>' +
'<td style="padding:6px 8px;border-bottom:1px solid #eee;vertical-align:top;white-space:nowrap;">' +
(i.unread ? '<b>' : '') + esc(i.from) + (i.unread ? '</b>' : '') +
'<br><span style="color:#888;font-size:12px;">' + i.time +
(i.count > 1 ? ' · ' + i.count + ' msgs' : '') + '</span></td>' +
'<td style="padding:6px 8px;border-bottom:1px solid #eee;vertical-align:top;">' +
'<a href="https://bpm.berkeley.edu/%27%20%2B%20i.link%20%2B%20%27" style="color:#1a4d8f;text-decoration:none;"><b>' + esc(i.subject) + '</b></a>' +
(showReasons ? ' <span style="color:#b35c00;font-size:12px;">[' + esc(i.reasons.join(' | ')) + ']</span>' : '') +
'<br><span style="color:#555;">' + esc(i.snippet) + '</span></td>' +
'</tr>'
).join('');
return '<h3 style="margin:18px 0 6px;">' + title + ' (' + items.length + ')</h3>' +
'<table style="border-collapse:collapse;width:100%;">' + rows + '</table>';
}
function cleanSender(from) {
const match = from.match(/^"?([^"<]+)"?\s*</);
return match ? match[1].trim() : from;
}
function esc(s) {
return String(s).replace(/&/g, '&').replace(/</g, '<').replace(/>/g, '>');
}
/** Run once to schedule the digest every morning between 6 and 7 AM. */
function createDailyTrigger() {
ScriptApp.getProjectTriggers()
.filter(t => t.getHandlerFunction() === 'sendDailyDigest')
.forEach(t => ScriptApp.deleteTrigger(t));
ScriptApp.newTrigger('sendDailyDigest')
.timeBased()
.everyDays(1)
.atHour(6)
.create();
} |
