Turn changed spreadsheet cost results into expenses
Capture new or updated cost items surfaced by a saved spreadsheet query.
Trigger
Table Query Result Changed
Rows in a saved table query result are added, removed or changed.
Action
Create Expense
Creates an expense from categorized line items.
Why this helps
Cost rows can change inside a report without making it obvious that an expense still needs to be recorded.
- Use changed query results as a signal for expense capture.
- Follow your categorization rules for line items.
- Record relevant costs in Elorus with less copying.
Setup
Build it in a few focused steps.
- 1Connect Google Super and Elorus once in the Notis portal.
- 2Create an automation in the portal or tell Notis from any channel what outcome you want.
- 3In one instruction, specify which changed rows qualify, how to categorize them, and how to handle incomplete expense details.
- 4Pick the Table Query Result Changed trigger and choose where run reports should go.
- 5Test with one real query result change and review the created expense in Elorus.
Questions about this workflow
Will any changed row become an expense?
No. Your instruction should identify qualifying cost rows and exclude unrelated changes.
Can it determine a missing expense category?
Only if you provide categorization rules or a default. Otherwise, missing details should be reviewed before creating the expense.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Elorus. A trigger fires from one place; an action lands in another.
Google Super 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
Triggers when an aggregate calculation in a spreadsheet changes.
CREATE_PRODUCT
Create a product or service in the catalog.
Attendee Response Changed
Triggers when an attendee accepts, declines, or tentatively responds to an invitation.
Email Invoice
Email an existing invoice to selected contacts.
Cell Range Values Changed
Triggers when values change in a specified spreadsheet range.
Get Bills
Retrieve bills for viewing and managing expenses or purchases.
Comment Added (Docs/Sheets/Slides)
Triggers when someone adds a comment to a document, sheet, or presentation.
Delete Invoice
Permanently deletes a draft invoice; issued invoices cannot be deleted.
Conditional Format Rule Changed
Triggers when spreadsheet conditional formatting rules are added, changed, or removed.
Get Contacts
Retrieve your contacts.
Data Validation Rule Changed
Triggers when spreadsheet data validation rules change.
Get Credit Notes
Retrieve credit notes.
Connect any two apps with Notis in the middle.
Google Super 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.