Create a report when a spreadsheet metric changes
When a key total or average moves, produce a short report that makes the update easy to review.
Trigger
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Action
Convert HTML to PDF
Tool to convert HTML to a PDF document. Use when you need to generate a PDF from raw HTML. Returns raw PDF bytes suitable for download or storage.
Why this helps
Important metric changes can disappear into a spreadsheet unless someone remembers to check them.
- Surface aggregate changes in a report-ready format.
- Reduce routine spreadsheet checking.
- Give the team a concise record of the metric update.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and CustomJS once in the Notis portal.
- 2Create an automation named Metric change PDF report.
- 3Tell Notis to summarize the changed aggregate and render the result as a concise PDF.
- 4Pick the Google Sheets Aggregate Metric Changed trigger and its available metric settings.
- 5Choose a report channel, then test with one real metric change.
Questions about this workflow
Which calculations can trigger this?
The listed trigger supports SUM, COUNT, AVG, MIN, and MAX aggregate calculations.
Can the report explain why the metric changed?
Only when the trigger data includes enough detail. If it does not, ask for a report of the changed result without claiming a cause.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Customjs. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Customjs actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Authenticate CustomJS API Key
Tool to authenticate a CustomJS API key. Use when verifying a user's API key before making further requests.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Convert HTML to PDF
Tool to convert HTML to a PDF document. Use when you need to generate a PDF from raw HTML. Returns raw PDF bytes suitable for download or storage.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Convert HTML to PNG
Tool to convert HTML string to PNG image. Use when you need a PNG from HTML after preparing your markup.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Capture webpage screenshot
Tool to capture a screenshot of a webpage. Use when you need a visual snapshot of a URL.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Merge multiple PDFs into one
Tool to merge multiple PDF files into a single PDF. Use when you have multiple PDF URLs and want one combined PDF.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Run Puppeteer Script
Tool to run a Puppeteer script and capture a screenshot. Use when automating headless browser tasks and needing a PNG output. Use after confirming the script logic.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Connect any two apps with Notis in the middle.
Google Sheets and Customjs, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Customjs.