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
Item Code
Required
Name
Required
Description
Is Sold
Required
Sales Unit Price
Sales Account
Sales Tax Type
Is Purchased
Required
Purchase Description
Purchase Unit Price
Purchase Account
Purchase Tax Type
Is Tracked
Required
Inventory Asset Account
Cost of Goods Sold Account
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Transaction_type
Required
Contact
Required
Bank Account
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
Contact Name
Required
Account_number
Sales Default Account Code
Purchases Default Account Code
Contact Requirements
Primary Person - First Name
Primary Person - Last Name
Primary Person - Email
Secondary Person - First Name
Secondary Person - Last Name
Secondary Person - Email
Include secondary person in emails sent to contact?
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
Contact_number
Company_number
Payment Terms - Invoice Due (days)
Payment Terms - Type for Sales Invoices
Payment Terms - Bill Due (days)
Payment Terms - Type for Purchase Invoices
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
Date
Expiry
Quote Number
Reference
Theme
Title
Summary
Currency
Amounts Are
Terms
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Warning_message
Credit Note ID
Required
Allocation ID
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Organization
Required
First Name
Required
Middle Names
Last Name
Required
Date of Birth
Required
Title
Email
Required
Gender
Phone Number
Mobile Number
Twitter Username
Job Title
Classification
Termination Date
Termination Reason
Income Type
Employment Type
Status
CopyEmployment
Employment Basis
Start Date
Payroll Calendar
Employee Group Name
Is Authorised to Approve Leave
Is Authorised to Approve Timesheets
Super Fund
Employee Number
CopyTaxDeclaration
Tax File Number
TFN Exemption Type
Residency Status
Tax Scale Type
Tax Offset Estimated Amount
Upward Variation Tax Withholding Amount
Approved Withholding Variation Percentage
CopyBankAccount
Statement Text
Account Name
BSB Number
Account Number
Remainder
CopyAddress
Address Line 1
Address Line 2
City/Suburb
State/Region
Postal Code
Country
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
Status
Date
Due_date
Currency
Url
Attachment
Branding_theme
Reference
Line_items_type
Item Code
Description
Quantity
Required
Unit Price
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
Document Type
Document ID or Number
Required
Paid To
Required
Date
Currency_rate
Amount
Required
Reference
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Contact (supplier)
Required
Date
Delivery_date
Order Number
Reference
Theme
Currency
Tax_type
Delivery_address
Attention
Telephone
Delivery_instructions
Attachments
Purchase Order Status
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Organization
Required
Employee
Required
First Name
Required
Middle Names
Last Name
Required
Date of Birth
Required
Title
Email
Required
Gender
Phone Number
Mobile Number
Twitter Username
Job Title
Classification
Termination Date
Termination Reason
Income Type
Employment Type
Status
CopyEmployment
Employment Basis
Start Date
Payroll Calendar
Employee Group Name
Is Authorised to Approve Leave
Is Authorised to Approve Timesheets
Super Fund
Employee Number
CopyTaxDeclaration
Tax File Number
TFN Exemption Type
Residency Status
Tax Scale Type
Tax Offset Estimated Amount
Upward Variation Tax Withholding Amount
Approved Withholding Variation Percentage
CopyBankAccount
Statement Text
Account Name
BSB Number
Account Number
Remainder
CopyAddress
Address Line 1
Address Line 2
City/Suburb
State/Region
Postal Code
Country
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Quote ID
Required
Quote Number
Status
Contact
Required
Date
Expiry
Reference
Theme
Title
Summary
Currency
Amounts Are
Terms
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Organization
Required
Resource type
Required
File
Required
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
Email
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Search By
Required
Order ID or Number
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Organization
Required
Invoice ID
Required
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
Contact Name
Required
Account_number
Sales Default Account Code
Purchases Default Account Code
Contact Requirements
Primary Person - First Name
Primary Person - Last Name
Primary Person - Email
Secondary Person - First Name
Secondary Person - Last Name
Secondary Person - Email
Include secondary person in emails sent to contact?
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
Contact_number
Company_number
Payment Terms - Invoice Due (days)
Payment Terms - Type for Sales Invoices
Payment Terms - Bill Due (days)
Payment Terms - Type for Purchase Invoices
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.
