B
Briefed

Build a Google Sheets email digest with Apps Script

3 min read · Last updated November 16, 2026

A sheet works well as a small editorial queue. You can see what will go into an issue before an automation emails it to you.

Create the queue

Create a tab named Queue. Use columns A through D for title, public URL, a short note and issue ID. Assign the same issue ID to the rows you want in one email.

Assemble a draft from selected rows

In Extensions → Apps Script, read the sheet with getDataRange().getDisplayValues(), skip the header, and select rows matching the issue ID. Join each title, note and URL with line breaks. Preview the text in a separate sheet before enabling sending.

Schedule one send

Use MailApp.sendEmail with your own address, subject and assembled text. Add one installable time-driven trigger for the function. Check the remaining mail quota and serialize overlapping runs. Store delivery state per issue; review an uncertain send before retrying.

Preview one issue from the Queue tab in the execution log
function previewIssue() {
  const sheet = SpreadsheetApp.getActive().getSheetByName("Queue");
  const rows = sheet.getDataRange().getDisplayValues().slice(1);
  const issueId = "sample-01"; // Put this ID in column D of two test rows.
  const selected = rows.filter(([title, url, , id]) => title && url && id === issueId);
  const body = selected.map(([title, url, note]) => [title, note, url].join("\n"));
  console.log(body.join("\n\n"));
}

Sources

Get a personal email on this topic

Briefed researches public web sources using the description you write below. Edit the example and choose how often your newsletter arrives. See the full DIY vs Briefed comparison for setup and maintenance tradeoffs.

How often?

No credit card. No app to install. Unsubscribe with one click, anytime.

Questions

Why did my daily script run at a slightly different minute?

Apps Script time-driven triggers can run within a time window. Use a date or issue ID for selection instead of relying on an exact minute.

More guides