Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Airtable with Xero - no code necessary. See how you can get setup in minutes.
100%
Help
Airtable
Airtable
1. Choose trigger event
Xero
Xero
2. Choose action
1. Select the event
Setup
Test
Airtable
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New Record" from Airtable.
Add your action
An action happens after the trigger—such as "Add Items to Existing Sales Invoice" in Xero.
You’re connected!
Zapier seamlessly connects Airtable and Xero, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Create a new record or update an existing record in your app.
Organization
Required
Credit Note ID
Required
Invoice ID
Required
Amount
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
From Account
Required
To Account
Required
Amount
Required
Date
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Code
Required
Name
Required
Type
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Type
Required
Contact
Required
Date
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Invoice ID
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Mark Item as a Sales Item?
Mark Item as a Purchase Item?
Item Name
Item Code
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact_name
Required
Email_address
Contact_account_number
Primary Person - First Name
Primary Person - Last Name
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
Contact Address Type
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Contact_tax_number
Bank Account Number
Contact Number
Status
Date
Due_date
Currency
Url
Attachment
Branding_theme
Number
Reference
Sent_to_contact
Shipping_cost_copy
Shipping Cost
Shipping Description
Shipping Cost Tax Rate (If Applicable)
Line_items_type
Item Code
Description
Quantity
Required
Unit Price
Discount %
Discount Amount
Account
Tax Rate
Tracking
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact
Required
Project Name
Required
Deadline for the project
Project Estimate
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact
Required
Repeated Invoice Schedule
Invoice Creation: Frequency Type
Required
Invoice Creation: Frequency (Period)
Required
Due Date Type: Payment Terms
Required
Set Due Dates (Days)
Required
Start Date:
Required
End Date
Status
Required
Currency
Branding_theme
Reference
Mark as approved for sending?
Email a copy to Sender?
Include PDF
Line Amount Types
Shipping_cost_copy
Shipping Cost
Shipping Description
Shipping Cost Tax Rate (If Applicable)
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Purchase Order
Required
Contact
Update Method for Line Items
Date
Delivery_date
Line Amount Types
Purchase Order Number
Reference
Branding Theme
Currency
Status
Sent to Contact
Delivery Address
Attention To
Telephone
Delivery Instructions
Expected_arrival_date
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Organization
Required
Invoice_id
Required
Contact
Status
Date
Due_date
Expected_payment_date
Reference
Branding_theme
Url
Currency
Sent_to_contact
Attachments
Invoice_number
Line_amount_types
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Stop on error
Required
HTTP Method
Required
URL
Required
Query string parameters
Additional request headers
Body
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Search_by
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Invoice ID
Required
Include PDF File
Include Online Invoice URL
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Contact ID
Quote Number
Status
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search_by
Required
Include Online Invoice URL
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search_by
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search_by
Required
Mark Item as a Sales Item?
Mark Item as a Purchase Item?
Item Name
Item Code
Required
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
For AI agents & developers
Use Airtable and Xero with AI agents and code
Beyond Zap workflows. Call Airtable and Xero actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Airtable and Xero actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Add Comment to Record
Add Items to Existing Sales Invoice
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Practical ways you can use Airtable and Xero
Sync new Airtable records to Xero invoices
For a Business Owner managing inventory or customer orders in Airtable, Zapier can save time by automatically creating Xero invoices when a new record is added to a designated Airtable table. This streamlines billing and reduces manual data entry.
Track marketing spending between Xero and Airtable
A marketing team can automate the tracking of advertising expenses logged in Xero by sending them to Airtable. This facilitates better budget management and creates a single source for campaign cost data without requiring constant updates.
Project managers can keep track of project-related expenses recorded in Xero by automating their addition to an Airtable base. This ensures real-time visibility into project finances, reducing oversight issues and saving hours of manual entry.
Level up your Airtable to Xero integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Airtable + Xero integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Airtable and Xero
Can I sync new records from Airtable to Xero automatically?
Yes, you can set up a trigger in Airtable to automatically sync new records to Xero as they are created. Using our integration, configure an action in Xero that captures this data and processes it according to your accounting needs.
How do I update an invoice in Xero when a record is modified in Airtable?
When a record is updated in Airtable, we can trigger an action that automatically updates the corresponding invoice in Xero. By mapping fields correctly during setup, any changes made in your Airtable database will reflect on the respective invoices without manual intervention.
Is it possible to create a contact in Xero whenever I add a new client in Airtable?
Absolutely. By setting up triggers based on new client entries in your Airtable base, we can automate the process of creating contacts within Xero. This ensures that all relevant information is seamlessly transferred between both platforms.
What happens if there is an error during data transfer between Airtable and Xero?
In case of any errors during data transfer, we provide detailed logs that specify what went wrong and why. Users can view these logs to troubleshoot and apply necessary fixes or re-run failed actions.
Can I use custom fields from Airtable when creating entries in Xero?
Yes, our integration allows you to map custom fields from your Airtable records when creating entries or documents like invoices or contacts in Xero. Ensure proper field mapping during setup for accurate data transfer.
How often does the synchronization between Airtable and Xero occur?
The synchronization frequency can be adjusted based on your needs – ranging from near real-time updates as changes happen, to scheduled intervals such as hourly or daily sync sessions.
Are there any limitations on the number of records I can sync between Airtable and Xero?
While you can usually sync a substantial number of records at once, being aware of certain limits depending on plan specifics is important. These may affect the volume of data processed within specific time frames due to API constraints.
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.
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.
