Reproduce this sample in your Sheet

Before: you read prepared weekly cells, calculate four summaries and compose an email. After setup: the script reads those configured cells and builds the format above. You still maintain the reporting ranges. It does not collect data from your other tools, select a new date window or attach PDFs.

This sample data is free to copy. Running the workflow requires the six source files in the paid pack and authorization in your Google account. No one-click installer is included. Installation time, Google execution and received email remain unverified.

1. Create a blank Google Sheet in an account you are allowed to use. Add tabs named Data, Weekly and Clients. Copy each tab-separated block below into that tab's A1 cell. Use fictional data for your first test.
2. In Apps Script, create a project and paste the six purchased files: Config, Main, Metrics, Render, Triggers and Tests. Keep all functions in Config.gs.
3. In Config.gs, replace SPREADSHEET_ID with the Sheet ID (between /d/ and /edit in its URL), and RECIPIENTS with one address you control. Leave DRY_RUN true. Set HEADING to Fictional Studio: Weekly Metrics and replace only the METRICS array with the array below.
4. Run smokeTest, then previewDigest. Google may ask for authorization even on the smoke test because it scans the whole project. Review spreadsheet access, email sending and trigger management. This code reads the configured cells but the spreadsheet permission may be broader than one file. Do not bypass an organization policy or use a personal account without permission.
5. Check the preview log: 12 invoices, 2.4 days, revenue 6000 with +20%, and Sample Beta, Alpha, Gamma ranked by hours. The displayed date will reflect your run. Previewing with DRY_RUN true sends no email.
6. For a controlled delivery test, set DRY_RUN false and run sendWeeklyDigest once. Verify the received message and all four results in the recipient inbox. A successful execution log alone does not confirm receipt.
7. Set the project timezone, run installTriggers, and inspect the trigger list for one sendWeeklyDigest weekly Monday trigger near 09:00. Timing is approximate (nearMinute allows a 15-minute margin). Verify a later scheduled execution and received message separately; creating a trigger is not that test.
8. After testing, run uninstallTriggers, confirm that the digest trigger is gone, and restore DRY_RUN true. Keep the Sheet, recipients, permissions and execution logs private.

Data tab: paste into A1

Entry	Invoices	Turnaround days
A	2	2
B	3	3
C	1	4
D	4	1
E	2	2

Weekly tab: paste into A1

Week	Revenue USD
Previous	5000
Current	6000

Clients tab: paste into A1

Client	Hours
Sample Alpha	8
Sample Beta	15
Sample Gamma	6

Replace the METRICS array in Config.gs

[
  {
    "label": "Invoices issued",
    "sheet": "Data",
    "range": "B2:B6",
    "agg": "sum"
  },
  {
    "label": "Average turnaround (days)",
    "sheet": "Data",
    "range": "C2:C6",
    "agg": "average"
  },
  {
    "label": "Revenue (USD, week over week)",
    "sheet": "Weekly",
    "range": "B2:B3",
    "agg": "delta"
  },
  {
    "label": "Client hours (top 3)",
    "sheet": "Clients",
    "range": "B2:B4",
    "labelsRange": "A2:A4",
    "agg": "topN",
    "n": 3
  }
]

Check the native options first

Sheets conditional notifications send alerts about cell changes on eligible accounts. That documented event-based behavior differs from this fixed weekly summary. If a change alert solves your problem, you may not need this pack.

Workspace Studio supports scheduled flows where your organization enables it. Check its available actions for your exact report; we have not tested an equivalent Studio flow. Writing your own Apps Script is another option. This pack's offer is editable source and a defined report format, not exclusive access to scheduling.

Google authorization · Quotas (count email recipients) · Trigger timing

Review the $39 one-time pack