Create Xero invoice from Google Sheets row
This action will create a sales invoice for the contact you specify in the organisation you select. The contact is created in Xero if it doesn't already exist.
Developer info
- API endpoint slug
- xero.create_invoice
- Filter code method
- Xero.createInvoice.skip(string?: reason)
- Runtime method
- runAction("xero.create_invoice", {})
Action fields
Organisation Dropdown list
- Label
- Which organisation?
- Helper text
- The Xero organisation to create the invoice in.
- Slug
- organisation
- Required
- true
- Can have default value
- false
Customer name Text input > Other
- Label
- Customer name
- Helper text
- Created in Xero if it doesn't already exist.
- Slug
- customer_name
- Required
- true
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setCustomerName(string: customer_name)
Line item description Text input
- Label
- Line item description
- Helper text
- Description of what is being invoiced.
- Slug
- line_item_description
- Required
- true
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setLineItemDescription(string: line_item_description)
Quantity Text input > Other
- Label
- Quantity
- Helper text
- e.g. 1
- Slug
- quantity
- Required
- true
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setQuantity(string: quantity)
Unit amount Text input > Other
- Label
- Unit amount
- Helper text
- Unit price, e.g. 250.00
- Slug
- unit_amount
- Required
- true
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setUnitAmount(string: unit_amount)
Account code Text input > Other
- Label
- Revenue account code
- Helper text
- e.g. 200; uses your default sales account if blank.
- Slug
- account_code
- Required
- false
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setAccountCode(string: account_code)
Due date Text input > ISO 8601 date and time
- Label
- Due date
- Helper text
- e.g. 2026-07-01
- Slug
- due_date
- Required
- false
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setDueDate(string: due_date)
Status Dropdown list
- Label
- Status
- Helper text
- Create as a draft or an approved invoice. Defaults to Draft.
- Slug
- status
- Required
- false
- Can have default value
- true
- Filter code method
- Xero.createInvoice.setStatus(string: status)
