Create Elorus Invoices from New Google Sheets Rows
Keep billing moving as soon as a complete invoice request lands in your sheet.
Trigger
New Rows in Google Sheet
Fires when new rows are added to a sheet.
Action
Create Invoice
Create an invoice or receipt, saved as a draft by default.
Why this helps
Invoice requests sit in a spreadsheet while you manually transfer customer and line item details into billing.
- Reduce retyping between the request tracker and billing.
- Catch incomplete invoice details before creating a document.
- Keep new billing requests moving without checking the sheet manually.
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 create an Elorus invoice from each new row that contains all required customer, item, quantity, price, currency, and due date details; ask it to report missing details without creating an invoice.
- 4Pick New Rows in Google Sheet as the trigger and choose where run reports should go.
- 5Test with one real, complete row and review the created invoice.
Questions about this workflow
What should a row contain?
Include the customer identity and the invoice details Elorus requires, such as items, quantities, prices, currency, and due date. Ask Notis to flag any missing information before invoice creation.
Will it create an invoice for every new row?
The instruction can tell Notis to create invoices only for rows that clearly contain complete invoice requests and to report rows that need clarification.
Can Notis send the invoice to the customer too?
This workflow creates an invoice. Emailing it is a separate action and requires the relevant contact details.
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.