Mailchimp + Airtable + QuickBooks Online Integrations
How to connect Mailchimp + Airtable + QuickBooks Online
Zapier lets you send info between Mailchimp and Airtable and QuickBooks Online automatically—no code required. With 5,000+ supported apps, the possibilities are endless.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Mailchimp + Airtable + QuickBooks Online
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Mailchimp, Airtable, and QuickBooks Online. And don’t forget that you can add more apps and actions to create complex workflows.
Audience
LinkRequired
Select a link from your campaign to track. It's not currently possible to trigger on all link clicks for a campaign with a single Zap.
Trigger on every click from a subscriber?
If no (and by default) this trigger will only fire the first time a user clicks a link in your campaign.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStoreRequired
To prevent timeout errors, please ensure the list of customers for this store does not exceed 3000.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planStore
If specified, will only trigger on orders created in this store. Otherwise, will default to all orders in your account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAudienceRequired
Segment or TagRequired
To prevent timeouts, please ensure the list of subscribers in the segment/tag does not exceed 3000.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCampaign Name
AudienceRequired
Select the audience you want to send the campaign to.
Segment or Tag
Select which segment or tag you want to send the campaign to. If no segment/tag is selected, the campaign will be sent to the entire audience selected above.
Email SubjectRequired
Preview Text
This snippet will appear in the inbox after the subject line.
From NameRequired
From Email AddressRequired
To Name
Supports
*|MERGETAGS|*for recipient name, such as*|FNAME|*,*|LNAME|*,*|FNAME|* *|LNAME|*, etc.Template
Select either a template or provide HTML email content, you cannot provide both. If both fields are left blank, the campaign draft will have no content.
Email Content (HTML)
Select either a template or provide HTML email content, you cannot provide both. If both fields are left blank, the campaign draft will have no content.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Email AddressRequired
The email address of the subscriber for the custom event. The email address must already be subscribed to the audience.
Custom Event NameRequired
Must be 2-30 characters in length. Note: Letters, numbers, underscores, hyphens, and any spaces between are considered valid characters. Any invalid characters will be ignored.
Properties
Additional properties for this event (e.g. "User Type: Premium", "Preferred Communication: Email", etc). Note: Letters, numbers, underscores, hyphens, and any spaces between are considered valid characters. Any invalid characters in the first column only will be ignored.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Subscriber EmailRequired
The email address of the subscriber you want to unsubscribe from this audience.
Delete Member
Completely delete this contact from MailChimp? (No: just unsubscribe them)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CampaignRequired
A Custom Value is typically used here to pass in the Campaign ID from a "Create Campaign" or "Find Campaign" step. Learn more
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
TagRequired
The tag to which the subscriber will be added.
Email AddressRequired
The email address of the person you want to add to this segment. Note: the email address must already be subscribed to the audience, or this will fail.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Mailchimp are located here https://mailchimp.com/developer/reference/
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StoreRequired
Email AddressRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearchRequired
The email address of the Subscriber you want to find.
Audience
Limit your search to this specific Audience.
ActionThis is an event a Zap performs.SearchFind existing data in your appAudienceRequired
Tag nameRequired
Examples: Conference Lead, Influencer, or Donor (Tag length is limited to 100 characters).
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundBaseRequired
TableRequired
Limit to View
(Optional) Limit to records added to a specific View, and return records in the View order.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBaseRequired
Base in which to create the record.
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Pick the Airtable base containing the records you wish to update.
TableRequired
Pick the Airtable table containing the records you wish to update.
RecordRequired
Pick the Airtable record that you wish to update.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Airtable are located here https://airtable.com/api
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Base to search for a record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
You can optionally limit the search to a specific view id.
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
Base in which to create the record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
You can optionally limit the search to a specific view id.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Bill
Triggers when a new bill is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Estimate
Triggered when you add a new estimate.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggered when you add a new invoice.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggered when a new sales receipt is added (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Purchase Order
Triggers when a new purchase order is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggered when an existing customer is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planVendorRequired
Specifies the vendor for this bill.
Bill Number
Line Item
Line Description
AmountRequired
Amount of the line item.
Qty
Quantity of the line item.
Unit Price
Unit Price of the line item.
Line Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
AP Account
Customer
Specifies the customer associated with the bill.
Due Date
Transaction Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Specifies the vendor for this bill.
Terms
Transaction Date
Due Date
Bill Number
Department
Global Tax Calculation
Product/Service
Description
Qty
Rate
AmountRequired
Billable?
If a line item is billable, please use the Customer field to specify which customer.
Customer
Line Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
Display Name
If not set, Full Name will be used here.
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
Only available if multicurrency is enabled.
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Choose a Parent Customer if you're creating a Job/sub-customer.
Bill with Parent?
If no, this customer will be billed.
Preferred Payment Method
Preferred Delivery Method
Terms
Customer Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payee TypeRequired
Is the payee a Vendor, Customer, or Employee?
Payment TypeRequired
Bank/Credit AccountRequired
Payment Date
Defaults to today's date if not specified.
Payment Method
Reference Number
Will be used as check number if payment type is check.
Print Later?
Only applicable if payment type is check.
Account
Description
Amount
You must enter an amount here or in the "Amount" field under "Item Details."
Billable Status
Tax Code
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Product/Service
Description
Quantity
Rate
Amount
You must enter an amount here or in the "Amount" field under "Account Details."
Billable Status
Tax Code
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Journal Date
Defaults to today's date if not specified.
Journal Number
AccountRequired
Debit AmountRequired
Total amount of "Debits" line items must equal the total amount of "Credits" line items.
Description
Customer Name
Vendor Name
Employee Name
Department
Only available if your preferences allow tracking of department.
Class
AccountRequired
Credit AmountRequired
Total amount of "Credits" line items must equal the total amount of "Debits" line items.
Description
Customer Name
Vendor Name
Employee Name
Department
Only available if your preferences allow tracking of department.
Class
Memo
Currency
Only available if multicurrency is enabled. Defaults to your home currency if left blank.
Exchange Rate
Only available if multicurrency is enabled.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Customer
Select a specific customer, or, use the below field to look up a customer on demand.
Find Customer by Name/Email
If you just have access to the customer's name or email, use this.
Email
Send Later?
Note
Message
Line AmountRequired
Should not include tax.
Service Date
Line Description
Product/Service
Line Item Quantity
Line Item Unit Price
Should not include tax.
Line Item Tax Code
Line Item Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Transaction Date
Total Discount
Will be added as a Discount Line item. The company preference Sales Form Entry | Discounts must be enabled.
Payment Method
Payment Reference Number
Deposit To Account
A.K.A. Income 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
Only available if multicurrency is enabled.
Exchange Rate
The number of home currency units it takes to equal one unit of currency specified above. Only available if multicurrency is enabled.
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Shipping Tax
Shipping Cost
Department
Only available if your preferences allow tracking of department.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.VendorRequired
Purchase Order Status
Mailing Address
Address to which the payment should be sent.
Shipping Address
Address to which the vendor shipped or will ship goods associated with purchase.
Purchase Order Date
Ship Via
Purchase Order Number
Account
Description
Amount
You must enter an amount here or in the "Amount" field under "Item Details."
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Product/Service
Description
Quantity
Rate
Amount
You must enter an amount here or in the "Amount" field under "Account Details."
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Your Message to Vendor
Memo
For internal use. Will not appear on purchase order to vendor
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
EmailRequired
Send to an explicit email address instead of the invoice billing one, and updates the one on the invoice to this.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Time Activity TypeRequired
Is this for an Employee or Vendor?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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
Should not include tax.
Amount
Should not include tax.
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Apply Tax After Discount?
Discount Value
Discount values must be positive (e.g.
.10for a 10% discount)Discount Percent
Shipping Tax
Shipping
Deposit
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Department
Only available if your preferences allow tracking of department.
Location
Only available for France locales.
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Account NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice NumberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Enter the vendor's display name exactly as it appears in QuickBooks Online.
ActionThis is an event a Zap performs.SearchFind existing data in your appFull NameRequired
Enter the vendor's display name exactly as it appears in QuickBooks Online.
PhoneRequired
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Audience
Trigger on every open from a subscriber?
If no (and by default) this trigger will only fire the first time a user opens an email.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Audience
Triggers when a new audience is added to your MailChimp accounts.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAudienceRequired
Note About Samples
When samples are pulled in the next step for this trigger, the GROUPINGS data will be static, dummy data ("Example Group Category 1"). Use the example Group values to setup your Zap, and the data should reflect appropriately when the Zap runs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.AudienceRequired
Note About Samples
When samples are pulled in the next step for this trigger, the GROUPINGS data will be static, dummy data ("Example Group Category 1"). Use the example Group values to setup your Zap, and the data should reflect appropriately when the Zap runs.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.AudienceRequired
Tag nameRequired
Examples: Conference Lead, Influencer, or Donor (Tag length is limited to 100 characters).
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Subscriber EmailRequired
The email address of the subscriber you want to subscribe to this audience. Please don't type an email address in this field, instead this should use a value from a previous step in your Zap. Learn more here.
Double Opt-In
If yes, a confirmation email will be sent to the address before they appear on the chosen audience.
Update Existing
If no, the Zap will skip/halt this step if the subscriber exists, otherwise overwrites data sent.
Replace Groups
Determines what changes to make to the subscriber's groups/interests.
- Add Only The group(s) specified below will be added to the subscriber's existing groups/interests.
- Replace All All of the subscriber's existing groups will be cleared, and replaced with the groups selected below.
- Replace Matching Clears any existing group selections only for the groups specified below. Learn more here.
Groups
Language Code
This should be a two letter language code (ISO639-1) See here for the list of language codes.
Tag(s)
The tag(s) to which the subscriber will be added. Tags will be added to any existing tags on existing subscribers.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
TagRequired
Email AddressRequired
The email address of the person you want to remove from this tag. Note: the email address must already be subscribed to the audience, or this will fail.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.AudienceRequired
Email AddressRequired
The email address of the subscriber you want to add a note to. The email address must already be subscribed to the audience.
NoteRequired
The content of the note. Note length is limited to 1,000 characters.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
The name of the Campaign to find
ActionThis is an event a Zap performs.SearchFind existing data in your appAudienceRequired
Tag nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
The name of the Campaign to find
Campaign Name
AudienceRequired
Select the audience you want to send the campaign to.
Segment or Tag
Select which segment or tag you want to send the campaign to. If no segment/tag is selected, the campaign will be sent to the entire audience selected above.
Email SubjectRequired
Preview Text
This snippet will appear in the inbox after the subject line.
From NameRequired
From Email AddressRequired
To Name
Supports
*|MERGETAGS|*for recipient name, such as*|FNAME|*,*|LNAME|*,*|FNAME|* *|LNAME|*, etc.Template
Select either a template or provide HTML email content, you cannot provide both. If both fields are left blank, the campaign draft will have no content.
Email Content (HTML)
Select either a template or provide HTML email content, you cannot provide both. If both fields are left blank, the campaign draft will have no content.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearchRequired
The email address of the Subscriber you want to find.
Audience
Limit your search to this specific Audience.
AudienceRequired
Subscriber EmailRequired
The email address of the subscriber you want to subscribe to this audience. Please don't type an email address in this field, instead this should use a value from a previous step in your Zap. Learn more here.
Double Opt-In
If yes, a confirmation email will be sent to the address before they appear on the chosen audience.
Update Existing
If no, the Zap will skip/halt this step if the subscriber exists, otherwise overwrites data sent.
Replace Groups
Determines what changes to make to the subscriber's groups/interests.
- Add Only The group(s) specified below will be added to the subscriber's existing groups/interests.
- Replace All All of the subscriber's existing groups will be cleared, and replaced with the groups selected below.
- Replace Matching Clears any existing group selections only for the groups specified below. Learn more here.
Groups
Language Code
This should be a two letter language code (ISO639-1) See here for the list of language codes.
Tag(s)
The tag(s) to which the subscriber will be added. Tags will be added to any existing tags on existing subscribers.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundBaseRequired
TableRequired
Help Text
You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.
Which timestamp field should this Zap use to check for updates?Required
When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.
Limit to View
Filter on updates to a specific View in your Table.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBaseRequired
Base in which to create the record.
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Owner
Determines which App Extensions will appear in the dropdown below.
App ExtensionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
Base to search for a record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
Limit the search to a specific view. Useful for sorting results.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
Base in which to create the record.
TableRequired
Pick an Airtable table that you want to search.
Search by Field
Pick a field from the base to match against the search value.
Search Value
The value of unique identifier for the record.
Search Formula
(ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.
Limit to View
Limit the search to a specific view. Useful for sorting results.
Include file contents?
Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Account
Triggered when you add a new account.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggered when you add a new customer.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Expense
Triggers when a new expense is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice
Triggered when you add a new invoice (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Payment
Triggered when a payment is received (with line item support).
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Receipt
Triggered when a new sales receipt is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Vendor
Triggered when a new vendor is added.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planVendorRequired
Terms
Transaction Date
Due Date
Bill Number
Department
Currency
Only available if multicurrency is enabled.
Global Tax Calculation
Description
AmountRequired
Billable?
If a line item is billable, please use the Customer field to specify which customer.
Customer
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
AccountRequired
Tax Code
AP Account
Memo
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
Send Later?
Billing Address
Credit Memo Date
Defaults to today's date if not specified.
Credit Memo Number
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
AmountRequired
Service Date
Product/Service
Description
Quantity
Rate
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed On Credit Memo
Memo
Apply Tax After Discount?
US versions of QuickBooks only.
Discount Value
Discount Percent
Sales Tax Rate
Shipping Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Select a specific customer.
Number
Max of 21 characters. If empty, Quickbooks will generate one by incrementing the last number, but only if you have custom transaction numbers disabled. number automatically. Max of 21 characters.
Line AmountRequired
Should not include tax.
Line Description
Line Item/Product
Line Item Quantity
Line Item Tax Code
Line Item Service Date
Format: YYYY-MM-DD
Rate
When using this field, the Rate * Quantity must be equal to the line amount
Expiration Date
Message displayed on estimate
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Shipping Address
If the customer you enter in the "Customer" field has a default shipping address, that address will be used if this field is left blank.
Shipping amount
Bill Email
Email address where estimate is sent. Separate emails with commas for multiple addresses
Send later
If set to true, the Bill Email field should also be provided
Discount Value
Discount values must be positive (e.g.
10for a 10 value discount)Discount Percent
Discount values must be positive (e.g.
10for a 10% discount)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TypeRequired
NameRequired
Description On Sales Forms
Sales Price/Rate
Description On Purchase Forms
Cost
SKU
Category
Is Taxable?
Only applicable to US companies.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Email
If not set, the customer's primary email will be used.
Cc
Bcc
Send Later?
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Shipping Address
If the customer you enter in the "Customer" field has a default shipping address, that address will be used if this field is left blank.
Terms
Invoice Date
Defaults to today's date if not specified.
Due Date
Ship Via
Shipping Date
Tracking Number
Invoice Number
If empty, no Invoice number is added. Max of 21 characters or put AUTO_GENERATE to let QuickBooks increment this automatically.
Service Date
Product/Service
Description
Quantity
Rate
Should not include tax.
AmountRequired
Should not include tax.
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed on Invoice
Message Displayed on Statement
Accept Payment Via Bank Transfer
Accept Payment Via Credit Card
Tax Code
Total Tax
Requires choosing a Tax Code above.
Tax Calculation
Method in which tax is applied.
Apply Tax After Discount?
Discount Value
Discount values must be positive (e.g.
.10for a 10% discount)Discount Percent
Shipping Tax
Shipping
Deposit
Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Department
Only available if your preferences allow tracking of department.
Location
Only available for France locales.
Currency
Only available if multicurrency is enabled. Defaults to your home currency if left blank.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Total AmountRequired
Unapplied Amount
The amount that has not been applied to pay amounts owed for sales transactions.
Transaction Date
Payment Method
Payment Reference Number
Deposit To Account
A.K.A. Income Account
Line Amount
Should not include tax.
Memo
Line Linked Invoice
Only choose an invoice if this payment is linked to one.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Refund FromRequired
Customer
Email
Billing Address
If the customer you enter in the "Customer" field has a default billing address, that address will be used if this field is left blank.
Refund Receipt Date
Defaults to today's date if not specified.
Refund Receipt Number
Transaction Class
Only available if class tracking is enabled and assigned using the "one to entire transaction" option.
Payment Method
Check Number
Print Later?
Product/ServiceRequired
AmountRequired
Service Date
Description
Quantity
Rate
Tax
Class
Only available if class tracking is enabled and assigned using the "one to each row in transaction" option.
Message Displayed On Refund Receipt
Memo
Apply Tax After Discount?
US versions of QuickBooks only.
Discount Value
Discount Percent
Sales Tax Rate
Shipping
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales ReceiptRequired
Email
Send to an explicit email address instead of the receipt billing one, and updates the one on the sales receipt to this.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Company
Email
Title
First name
Middle name
Last name
Suffix
Display name as
Must be unique for every customer.
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
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Full NameRequired
PhoneRequired
Email
Website
Address Line 1
Address Line 2
Address City
Address State Code
Address Zip Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Quickbooks are located here https://developer.intuit.com/app/developer/qbo/docs/develop
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Search FieldRequired
Search ValueRequired
Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch FieldRequired
Search ValueRequired
Depending on which "Search Field" you selected, the search value must exactly match the "Display name as" field or "Email" field in Quickbooks.
Full NameRequired
Display Name
If not set, Full Name will be used here.
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
Only available if multicurrency is enabled.
Tax Registration Number
Tax Resale Number
Job/Parent Customer
Choose a Parent Customer if you're creating a Job/sub-customer.
Bill with Parent?
If no, this customer will be billed.
Preferred Payment Method
Preferred Delivery Method
Terms
Customer Type
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
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.
How Mailchimp + Airtable + QuickBooks Online Integrations Work
- Step 1: Authenticate Mailchimp, 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.
