Airtable + Xero

Create records in Airtable with line item support when new sales invoices arise in Xero

When a new sales invoice is generated in Xero, this workflow simplifies your workflow by instantly creating corresponding records in Airtable, complete with detailed line items. This automation allows for more efficient record management and saves you valuable time, ensuring your databases are always up-to-date and eliminating the need for manual data entry across platforms.

When this happens...
New Sales Invoice
Triggers when you add a new sales invoice. (Accounts Receivable).
TriggerScheduled
automatically do this!
Create Records (With Line Item Support)
Creates up to 10 multiple new records with line item input
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Quote Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Scheduled
Try It

- OrganizationRequired
- InvoiceRequired
Action
Write
- OrganizationRequired
- From AccountRequired
- To AccountRequired
- AmountRequired
- Date
Action
Write

- OrganizationRequired
- ContactRequired
- Date
- Expiry
- Quote Number
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
- Terms
Action
Write
- OrganizationRequired
- Invoice NumberRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Reference
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- Document Type
- Document ID or NumberRequired
- Paid ToRequired
- Date
- Currency Rate
- AmountRequired
- Reference
Action
Write
- OrganizationRequired
- Contact (supplier)Required
- Date
- Delivery Date
- Order Number
- Reference
- Theme
- Currency
- Tax Type
- Delivery Address
- Attention
- Telephone
- Delivery Instructions
- Attachments
- Purchase Order Status
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- BaseRequired
- TableRequired
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Lookup FieldRequired
- Secondary Lookup Field
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
Action
Search or write

- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
- Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Purchase Order Status
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write
- OrganizationRequired
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
Action
Write
- OrganizationRequired
- TypeRequired
- ContactRequired
- Date
Action
Write
- OrganizationRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Write
- OrganizationRequired
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Number
- Reference
- Sent To Contact
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Discount Amount
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- ContactRequired
- Project NameRequired
- Deadline for the project
- Project Estimate
Action
Write
- OrganizationRequired
- ContactRequired
- StatusRequired
- Currency
- Branding Theme
- Reference
- Mark as approved for sending?
- Email a copy to Sender?
- Include PDF
- Line Amount Types
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
- Contact NameRequired
- Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
Action
Search or write
- BaseRequired
- TableRequired
- Help Text
- Which timestamp field should this Zap use to check for updates?Required
- Limit to View
- Include file contents?
Trigger
Scheduled
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search for Exact Match?
- Search Formula
- Limit to View
- Include file contents?
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more Help

Related categories

Databases

Similar apps

Quickbase

Databases

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

About Xero

Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

Learn more Help

Related categories

Accounting

Similar apps

QuickBooks Online

Accounting

FreeAgent

Accounting

Wave

Accounting

PRODUCTS

CAPABILITIES

By team

Airtable + Xero

Create records in Airtable with line item support when new sales invoices arise in Xero

New Bank Transaction

New Contact

OrganizationRequired

New Payment

OrganizationRequired

Payment Type

New Quote

OrganizationRequired

Quote Status

New Sales Invoice

OrganizationRequired

Status

Add Items to Existing Sales Invoice

OrganizationRequired

InvoiceRequired

Create Bank Transfer

OrganizationRequired

From AccountRequired

To AccountRequired

AmountRequired

Date

Create New Quote Draft

OrganizationRequired

ContactRequired

Date

Expiry

Quote Number

Reference

Theme

Title

Summary

Currency

Amounts Are

Terms

Send Sales Invoice by Email

OrganizationRequired

Invoice NumberRequired

Create Bill

OrganizationRequired

Contact NameRequired

Email Address

Status

Date

Due Date

Currency

Url

Attachment

Branding Theme

Reference

Line Items Type

Item Code

Description

QuantityRequired

Unit Price

Account

Tax Rate

Tracking

Create Payment

OrganizationRequired

Document Type

Document ID or NumberRequired

Paid ToRequired

Date

Currency Rate

AmountRequired

Reference

Create Purchase Order

OrganizationRequired

Contact (supplier)Required

Date

Delivery Date

Order Number

Reference

Theme

Currency