Create Elorus Expenses When Sheet Values Change
Turn updated expense details into a billing record without another round of copy and paste.
Trigger
Cell Range Values Changed
Fires when values in a monitored cell range change.
Action
Create Expense
Creates an expense from categorized line items.
Why this helps
Expense information changes in a sheet, then gets overlooked or entered into Elorus late.
- Act on changes in the specific range you monitor.
- Reduce delays between recording expense details and creating the expense.
- Surface incomplete expense information for follow-up.
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 review changed values in the chosen range and create an Elorus expense only when they provide complete expense details and categorized line items; ask it to report missing or ambiguous details.
- 4Pick Cell Range Values Changed as the trigger and choose where run reports should go.
- 5Test with one real range change and review the created expense.
Questions about this workflow
Does a range change always create an expense?
The instruction should require evidence that the changed values describe a complete expense, so unrelated edits or incomplete details can be reported instead.
What expense details should I include?
Provide the expense information and categorized line items needed for the Elorus record. If your sheet does not contain a required detail, have Notis report it rather than guess.
Can this monitor multiple parts of the sheet?
The trigger monitors a specified A1 range. Set up the trigger for the range that contains the expense data you want to watch.
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.