Automatic Daily Reminder with Trigger for wedding planner

Project info

• ThemeWedding Planner and Budget
• FeatureAutomation · Advanced
• ToolGoogle Sheets
• Price (one price)US$38

Functions used

• Apps Script
• ScriptApp
• Time-driven trigger
• MailApp

Reminders arrive every morning without opening the file.

Formulas in the file

How to use it

1. 1Enter the email in Dashboard!B24 and the status to remind in B25.
2. 2Paste the code in Apps Script.
3. 3Run aktifkanPengingatHarian once and grant permission.
4. 4Check the clock icon (Triggers) shows the daily trigger.
5. 5Wait for 08:00 or run pengingatHarian to test.

Apps Script code

The script is delivered as a separate Code.gs file inside the ZIP. Paste it into Extensions, Apps Script. A short excerpt:

function aktifkanPengingatHarian() {
  ScriptApp.getProjectTriggers().forEach(function (t) {
    if (t.getHandlerFunction() === "pengingatHarian") ScriptApp.deleteTrigger(t);
  });
  ScriptApp.newTrigger("pengingatHarian").timeBased().everyDays(1).atHour(8).create();
}

function pengingatHarian() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var data = ss.getSheetByName("Data").getDataRange().getValues();
  var dash = ss.getSheetByName("Dashboard");
  var tujuan = dash.getRange("B24").getValue();
  var status = dash.getRange("B25").getValue();
  var daftar = [];
  for (var i = 1; i < data.length; i++) {
    if (data[i][5] === status) daftar.push(data[i][1] + " (Rp " + data[i][6] + ")");
  }
  if (daftar.length === 0) return;
  MailApp.sendEmail(tujuan, "Pengingat harian: " + daftar.length + " data",
    "Status " + status + ":\n" + daftar.join("\n"));
}

Sample content

Columns of the Data sheet:

• Wedding Item
• Category
• Quantity
• Price
• Status
• Date

Master sheet items

Dashboard: Wedding Budget Dashboard

• Total Budget
• Paid
• Remaining Balance
• Items Settled

Tips

• Set a budget cap before vendor visits
• Record deposits and payoff dates for each vendor
• Count guests first because it drives many costs

The sample data is synthetic.

Price and ordering

Frequently asked questions