Review Elorus Invoices After a Sheet Metric Changes
A changing total can be the prompt to look at the invoices behind your billing picture.
Trigger
Aggregate Metric Changed
Fires when a spreadsheet aggregate metric changes.
Action
Get Invoices
Retrieve invoices for review, reporting, or other operations.
Why this helps
A spreadsheet metric changes, but checking the related invoice records requires a separate manual review.
- Use a metric change as a cue to review invoice records.
- Get a concise summary from retrieved invoice data.
- Reduce the need to switch between a spreadsheet and billing portal.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Elorus once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, ask Notis to fetch the relevant Elorus invoices when the monitored aggregate changes and summarize the records using available invoice data; specify any invoice filters or business context it needs.
- 4Pick Aggregate Metric Changed as the trigger and choose where run reports should go.
- 5Test with one real metric change and review the report against the returned invoices.
Questions about this workflow
Can the workflow explain why the metric changed?
Notis can analyze the information returned by the trigger and Elorus, but it needs the relevant records and context. A metric alone may not identify which invoices caused the change.
Can I monitor a specific type of invoice?
You can describe the desired invoice criteria in the instruction. Notis can only summarize records that the Elorus action returns.
Does this workflow change invoices?
No. It retrieves invoices for review and reporting; it does not edit or send them.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Elorus. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Elorus actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Invoice
Create an invoice or receipt, saved as a draft by default.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Expense
Creates an expense from categorized line items.
Aggregate Metric Changed
Fires when a spreadsheet aggregate metric changes.
CREATE_PRODUCT
Create a product or service in the catalog.
Cell Range Values Changed
Fires when values in a monitored cell range change.
Email Invoice
Email an existing invoice to selected contacts.
Conditional Format Rule Changed
Fires when conditional formatting rules are added, changed, or removed.
Get Bills
Retrieve bills for viewing and managing expenses or purchases.
Data Validation Rule Changed
Fires when data validation rules are added, changed, or removed.
Delete Invoice
Permanently deletes a draft invoice; issued invoices cannot be deleted.
Developer Metadata Changed
Fires when developer metadata is added, changed, or removed.
Get Contacts
Retrieve your contacts.
Filtered Range Values Changed
Fires when values in a filtered range change.
Get Credit Notes
Retrieve credit notes.
Connect any two apps with Notis in the middle.
Google Sheets and Elorus, 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 Elorus.