Airtable + QuickBooks Online Integrations

How to connect Airtable + QuickBooks Online

Zapier lets you send info between Airtable and QuickBooks Online automatically—no code required. With 5,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

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

Discover your first Zap

Quickly automate Airtable and QuickBooks Online workflows with Zapier's templates

Our most popular Zap! arrow pointing down

Create Airtable records for new QuickBooks Online invoices

Premium

Details

Try it

Create Airtable records for new QuickBooks Online expenses

Premium

Details

Try it

Create Airtable records for new QuickBooks Online invoices

Premium

Details

Try it

Create new QuickBooks Online vendors from new Airtable records

Premium

Details

Try it

Create Airtable records for new QuickBooks Online bills

Premium

Details

Try it

Create Airtable records for new QuickBooks Online customers

Premium

Details

Try it

Create Airtable records for new QuickBooks Online invoices

Premium

Details

Try it

Create Airtable records for new QuickBooks Online expenses

Premium

Details

Try it

Create Airtable records for new QuickBooks Online invoices

Premium

Details

Try it

Create new QuickBooks Online vendors from new Airtable records

Premium

Details

Try it

Create Airtable records for new QuickBooks Online bills

Premium

Details

Try it

Create Airtable records for new QuickBooks Online customers

Premium

Details

Try it

Create new Airtable records for new QuickBooks Online payments
Premium
Details
Try it
QuickBooks Online + Airtable
Create new QuickBooks Online customers from new Airtable records
Premium
Details
Try it
Airtable + QuickBooks Online
Add new QuickBooks Online vendors to Airtable as records
Premium
Details
Try it
QuickBooks Online + Airtable
Create Airtable records with line item support for new QuickBooks Online invoices
Premium
Details
Try it
QuickBooks Online + Airtable
Add new QuickBooks Online accounts to Airtable as records
Premium
Details
Try it
QuickBooks Online + Airtable
Create Airtable records with line item support for new QuickBooks Online estimates
Premium
Details
Try it
QuickBooks Online + Airtable
Create sales receipts in QuickBooks Online from new Airtable records
Premium
Details
Try it
Airtable + QuickBooks Online

Create new Airtable records for new QuickBooks Online payments

Premium

Details

Try it

QuickBooks Online + Airtable

Create new QuickBooks Online customers from new Airtable records

Premium

Details

Try it

Airtable + QuickBooks Online

Add new QuickBooks Online vendors to Airtable as records

Premium

Details

Try it

QuickBooks Online + Airtable

Create Airtable records with line item support for new QuickBooks Online invoices

Premium

Details

Try it

QuickBooks Online + Airtable

Add new QuickBooks Online accounts to Airtable as records

Premium

Details

Try it

QuickBooks Online + Airtable

Create Airtable records with line item support for new QuickBooks Online estimates

Premium

Details

Try it

QuickBooks Online + Airtable

Create sales receipts in QuickBooks Online from new Airtable records

Premium

Details

Try it

Airtable + QuickBooks Online

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

Supported triggers and actions

What does this mean?

- 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
- Welcome
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search Formula
- Limit to View
- Include file contents?
Action
Search

- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search Formula
- Limit to View
- Include file contents?
Action
Search or write
New Account
Triggered when you add a new account.
Trigger
Scheduled
Try It

New Customer
Triggered when you add a new customer.
Trigger
Scheduled
Try It
New Expense
Triggers when a new expense is added.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice (with line item support).
Trigger
Scheduled
Try It
New Payment
Triggered when a payment is received (with line item support).
Trigger
Scheduled
Try It
New Sales Receipt
Triggered when a new sales receipt is added.
Trigger
Scheduled
Try It
New Vendor
Triggered when a new vendor is added.
Trigger
Scheduled
Try It
- VendorRequired
- Terms
- Transaction Date
- Due Date
- Bill Number
- Department
- Currency
- Global Tax Calculation
- Description
- AmountRequired
- Billable?
- Customer
- Class
- AccountRequired
- Tax Code
- AP Account
- Memo
Action
Write
- CustomerRequired
- Email
- Send Later?
- Billing Address
- Credit Memo Date
- Credit Memo Number
- Class
- AmountRequired
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Credit Memo
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping Cost
Action
Write
- CustomerRequired
- Number
- Line AmountRequired
- Line Description
- Line Item/Product
- Line Item Quantity
- Line Item Tax Code
- Line Item Service Date
- Rate
- Expiration Date
- Message displayed on estimate
- Billing Address
- Shipping Address
- Shipping amount
- Bill Email
- Send later
- Discount Value
- Discount Percent
Action
Write
- TypeRequired
- NameRequired
- Description On Sales Forms
- Sales Price/Rate
- Description On Purchase Forms
- Cost
- SKU
- Category
- Is Taxable?
Action
Write
- CustomerRequired
- Email
- Cc
- Bcc
- Send Later?
- Billing Address
- Shipping Address
- Terms
- Invoice Date
- Due Date
- Ship Via
- Shipping Date
- Tracking Number
- Invoice Number
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- AmountRequired
- Tax
- Class
- Message Displayed on Invoice
- Message Displayed on Statement
- Accept Payment Via Bank Transfer
- Accept Payment Via Credit Card
- Tax Code
- Total Tax
- Tax Calculation
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Shipping Tax
- Shipping
- Deposit
- Class
- Department
- Location
- Currency
Action
Write
- CustomerRequired
- Total AmountRequired
- Unapplied Amount
- Transaction Date
- Payment Method
- Payment Reference Number
- Deposit To Account
- Line Amount
- Memo
- Line Linked Invoice
Action
Write
- Refund FromRequired
- Customer
- Email
- Billing Address
- Refund Receipt Date
- Refund Receipt Number
- Transaction Class
- Payment Method
- Check Number
- Print Later?
- Product/ServiceRequired
- AmountRequired
- Service Date
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Refund Receipt
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping
Action
Write
- Sales ReceiptRequired
- Email
Action
Write
- CustomerRequired
- Company
- Email
- Title
- First name
- Middle name
- Last name
- Suffix
- Display name as
- Phone
- Mobile
- Fax
- Other
- Website
- Print On Check As
- Notes
- Billing Address - Street
- Billing Address - City/Town
- Billing Address - State/Province
- Billing Address - ZIP code
- Billing Address - Country
- Shipping Address - Street
- Shipping Address - City/Town
- Shipping Address - State/Province
- Shipping Address - ZIP code
- Shipping Address - Country
- Exemption Details
Action
Write
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search FieldRequired
- Search ValueRequired
Action
Search
- Product NameRequired
Action
Search
- Search FieldRequired
- Search ValueRequired
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
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
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
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 Formula
- Limit to View
Action
Search
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search Formula
- Limit to View
Action
Search or write
New Bill
Triggers when a new bill is added.
Trigger
Scheduled
Try It
New Estimate
Triggered when you add a new estimate.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice.
Trigger
Scheduled
Try It
New Sales Receipt
Triggered when a new sales receipt is added (with line item support).
Trigger
Scheduled
Try It
New Purchase Order
Triggers when a new purchase order is added.
Trigger
Scheduled
Try It
Updated Customer
Triggered when an existing customer is updated.
Trigger
Scheduled
Try It
- VendorRequired
- Bill Number
- Line Item
- Line Description
- AmountRequired
- Qty
- Unit Price
- Line Class
- AP Account
- Customer
- Due Date
- Transaction Date
Action
Write
- VendorRequired
- Terms
- Transaction Date
- Due Date
- Bill Number
- Department
- Global Tax Calculation
- Product/Service
- Description
- Qty
- Rate
- AmountRequired
- Billable?
- Customer
- Line Class
- Tax Code
- AP Account
- Memo
Action
Write
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
Action
Write
- Payee TypeRequired
- Payment TypeRequired
- Bank/Credit AccountRequired
- Payment Date
- Payment Method
- Reference Number
- Print Later?
- Account
- Description
- Amount
- Billable Status
- Tax Code
- Customer
- Class
- Product/Service
- Description
- Quantity
- Rate
- Amount
- Billable Status
- Tax Code
- Customer
- Class
- Memo
Action
Write
- Journal Date
- Journal Number
- AccountRequired
- Debit AmountRequired
- Description
- Customer Name
- Vendor Name
- Employee Name
- Department
- Class
- AccountRequired
- Credit AmountRequired
- Description
- Customer Name
- Vendor Name
- Employee Name
- Department
- Class
- Memo
- Currency
- Exchange Rate
Action
Write
- Customer
- Find Customer by Name/Email
- Email
- Send Later?
- Note
- Message
- Line AmountRequired
- Service Date
- Line Description
- Product/Service
- Line Item Quantity
- Line Item Unit Price
- Line Item Tax Code
- Line Item Class
- Transaction Date
- Total Discount
- Payment Method
- Payment Reference Number
- Deposit To Account
- Sales Receipt Number
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Currency
- Exchange Rate
- Class
- Tax Code
- Total Tax
- Tax Calculation
- Shipping Tax
- Shipping Cost
- Department
Action
Write
- VendorRequired
- Purchase Order Status
- Mailing Address
- Shipping Address
- Purchase Order Date
- Ship Via
- Purchase Order Number
- Account
- Description
- Amount
- Customer
- Class
- Product/Service
- Description
- Quantity
- Rate
- Amount
- Customer
- Class
- Your Message to Vendor
- Memo
Action
Write
- InvoiceRequired
- EmailRequired
Action
Write
- Time Activity TypeRequired
Action
Write
- InvoiceRequired
- Customer
- Email
- Cc
- Bcc
- Send Later?
- Billing Address
- Shipping Address
- Terms
- Invoice Date
- Due Date
- Ship Via
- Shipping Date
- Tracking Number
- Invoice Number
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- Amount
- Tax
- Class
- Message Displayed on Invoice
- Message Displayed on Statement
- Accept Payment Via Bank Transfer
- Accept Payment Via Credit Card
- Tax Code
- Total Tax
- Tax Calculation
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Shipping Tax
- Shipping
- Deposit
- Class
- Department
- Location
- Currency
Action
Write
- Welcome
Action
Write
- Account NameRequired
Action
Search
- Invoice NumberRequired
Action
Search
- NameRequired
Action
Search
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Search or write

How Airtable + QuickBooks Online Integrations Work

Step 1: Authenticate Airtable and QuickBooks Online.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Airtable + QuickBooks Online

Airtable + QuickBooks Online Integrations

How to connect Airtable + QuickBooks Online

Create Airtable records for new QuickBooks Online invoices

Create Airtable records for new QuickBooks Online expenses

Create Airtable records for new QuickBooks Online invoices

Create new QuickBooks Online vendors from new Airtable records

Create Airtable records for new QuickBooks Online bills

Create Airtable records for new QuickBooks Online customers

Create Airtable records for new QuickBooks Online invoices

Create Airtable records for new QuickBooks Online expenses

Create Airtable records for new QuickBooks Online invoices

Create new QuickBooks Online vendors from new Airtable records

Create Airtable records for new QuickBooks Online bills

Create Airtable records for new QuickBooks Online customers

Create new Airtable records for new QuickBooks Online payments

Create new QuickBooks Online customers from new Airtable records

Add new QuickBooks Online vendors to Airtable as records

Create Airtable records with line item support for new QuickBooks Online invoices

Add new QuickBooks Online accounts to Airtable as records

Create Airtable records with line item support for new QuickBooks Online estimates

Create sales receipts in QuickBooks Online from new Airtable records

Create new Airtable records for new QuickBooks Online payments

Create new QuickBooks Online customers from new Airtable records

Add new QuickBooks Online vendors to Airtable as records

Create Airtable records with line item support for new QuickBooks Online invoices

Add new QuickBooks Online accounts to Airtable as records

Create Airtable records with line item support for new QuickBooks Online estimates

Create sales receipts in QuickBooks Online from new Airtable records

Connect your apps and automate workflows

New Record

BaseRequired

TableRequired

Limit to View

Include file contents?

Create Record

BaseRequired

TableRequired

Create or Update Record

BaseRequired

TableRequired

Lookup FieldRequired

Secondary Lookup Field

App Extensions (Beta)

Welcome

Find Many Records (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Include file contents?

Find or Create Record(s) (With Line Item Support)

BaseRequired

TableRequired

Search by Field

Search Value

Search Formula

Limit to View

Include file contents?

New Account

New Customer

New Expense

New Invoice

New Payment

New Sales Receipt

New Vendor

Create Bill (Account Based)

VendorRequired

Terms

Transaction Date

Due Date

Bill Number

Department

Currency

Global Tax Calculation

Description

AmountRequired

Billable?

Customer