Integration
Connect Airtable and QuickBooks Online
When New or Updated Record fires in Airtable, your agent runs Find customer by name in QuickBooks Online, or New or updated customer in QuickBooks Online to Create or Update Record in Airtable. Describe the whole flow and it is built, tested on every scenario and kept running.
What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.
Build solutions, not workarounds.
What do you want Airtable and QuickBooks Online to do together?
Ask the assistant
Connect your AI client
Give your AI client this address.
https://mcp.apiant.aiOne connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.
Set it up in your client
Claude Code
Run this in the directory you want to work in.
claude mcp add --transport http -s project apiant-ai https://mcp.apiant.aiStart Claude Code there, approve the server, and sign in in the browser page it opens.
Claude Code guide (opens in a new tab)Claude, web and desktop
Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.
Setup guide (opens in a new tab)Cursor
Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.
Setup guide (opens in a new tab)Zed
Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.
Setup guide (opens in a new tab)Codex and the ChatGPT desktop app
Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.
Setup guide (opens in a new tab)Any other MCP client
Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.
Setup guide (opens in a new tab)Connecting Airtable and QuickBooks Online lets the table your team works in drive the books. Jobs, quotes and clients tracked in Airtable can raise customers, estimates, vendors and invoices in QuickBooks Online, and payments or customer edits in QuickBooks can write straight back onto the matching Airtable record.
Example flows
What Airtable and QuickBooks Online can do together
From Airtable to QuickBooks Online
When New or Updated Record in Airtable
then Find customer by name in QuickBooks Online
When New Record in Airtable
then Create customer in QuickBooks Online
From QuickBooks Online to Airtable
When New or updated customer in QuickBooks Online
then Create or Update Record in Airtable
When New paid invoice in QuickBooks Online
then Update Record in Airtable
Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships.
Everything your agent can do with Airtable and QuickBooks Online
Triggers and actions 13 triggers · 59 actions
Trigger
New or Updated RecordTriggers when a record is created or updated.
Trigger
New RecordTriggers when a new record is created or new or existing records when first added to a selected view.
Action
Add Comment to RecordAdd a comment to an existing record in Airtable.
Action
Create BaseCreate a new Airtable base in your workspace.
Action
Create or Update RecordFind and update an existing record, or create a new one.
Action
Create RecordCreates a new record with auto-populating fields.
Action
Create TableCreate a new table in an existing Airtable base.
Action
Delete RecordDelete a record in a table.
Action
Find RecordFind a record in a table.
Action
Find Record by IDFind a specific record using its unique ID.
Action
Find TableFind tables by searching for a keyword in table name or description.
Action
Get All RecordsList all records from a table with pagination support.
Action
Get Base SchemaRetrieve the complete schema for a base, including all tables and their field definitions.
Action
List basesLists every Airtable base the connected account can see. Takes no search criterion.
Action
Update Multiple RecordsUpdate up to 10 records at once in a specific table.
Action
Update RecordUpdate a record in a specific table.
Trigger
New billPolls for newly created bills (accounts payable), most recent first.
Trigger
New customerPolls for newly created customers, most recent first.
Trigger
New estimateFires when a new estimate is created in QuickBooks Online.
Trigger
New invoicePolls for newly created invoices, most recent first.
Trigger
New or updated customerFires when a QuickBooks customer is created or any of its details change.
Trigger
New or updated estimateFires when a QuickBooks estimate is created or edited.
Trigger
New or updated invoiceFires when a QuickBooks invoice is created or edited — line items, amounts, due date, or status.
Trigger
New or updated itemFires when a QuickBooks product or service item is created or edited.
Trigger
New or updated vendorFires when a QuickBooks vendor is created or any of its details change.
Trigger
New paid invoicePolls for invoices that are fully paid (Balance = 0), most recently updated first.
Trigger
New paymentPolls for newly created customer payments, most recent first.
Action
Create accountCreate an account in the QuickBooks chart of accounts — name, account type, and detail type.
Action
Create billCreates a new bill (accounts payable) for a vendor with a single account-based line item.
Action
Create credit memoCreates a new credit memo for a customer with a single line item.
Action
Create customerCreates a new customer in QuickBooks Online.
Action
Create estimateCreate a QuickBooks Online estimate (quote) for a customer.
Action
Create expense (purchase)Creates a new expense (Purchase) paid from a bank/credit-card account with one account-based line.
Action
Create invoiceCreates a new invoice for a customer with a single line item.
Action
Create item (product/service)Creates a new product or service item.
Action
Create journal entryCreate a QuickBooks journal entry with balanced debit and credit lines against the chart of accounts.
Action
Create paymentRecords a customer payment, optionally applied against a specific invoice.
Action
Create refund receiptCreates a new refund receipt for a customer with a single line item.
Action
Create sales receiptCreates a new sales receipt for a customer with a single line item.
Action
Create vendorCreates a new vendor in QuickBooks Online.
Action
Delete billPermanently delete a QuickBooks bill by Id.
Action
Delete credit memoPermanently delete a QuickBooks credit memo by Id.
Action
Delete estimatePermanently delete a QuickBooks estimate by Id.
Action
Delete invoicePermanently delete a QuickBooks invoice by Id. Unlike voiding, this removes the transaction entirely.
Action
Delete sales receiptPermanently delete a QuickBooks sales receipt by Id.
Action
Find account by nameLook up an account in the QuickBooks chart of accounts by its name.
Action
Find customer by nameSearches for a customer by display name and returns its Id and SyncToken.
Action
Find invoice by numberLook up a QuickBooks invoice by its document number (the invoice number customers see) rather than its internal Id.
Action
Find item by nameLook up a QuickBooks product or service item by its name.
Action
Find vendor by nameLook up a QuickBooks Online vendor by display name.
Action
Get bill balanceReturns the outstanding balance for a bill by its Id.
Action
Get customer by IDRetrieves a single customer by its Id.
Action
Get estimate by IDRetrieve a QuickBooks Online estimate by its ID.
Action
Get estimate PDFDownload the rendered PDF of a QuickBooks estimate by Id.
Action
Get invoice by IDRetrieves a single invoice by its Id, including its balance.
Action
Get invoice PDFDownload the rendered PDF of a QuickBooks invoice by Id, for emailing or archiving.
Action
List accountsList the accounts in the QuickBooks chart of accounts, with their type, detail type, and current balance.
Action
List attachmentsList the files attached to a QuickBooks transaction or record, with their download links.
Action
List employeesList employees recorded in QuickBooks Online.
Action
List itemsList products and services (items) defined in QuickBooks Online.
Action
Pay billRecords a bill payment against a vendor bill, paid from the specified bank/credit-card account.
Action
Run queryRuns an arbitrary read-only QuickBooks Online query (QBO SQL-like syntax) and returns the raw QueryResponse.
Action
Send estimateEmail a QuickBooks Online estimate to the customer.
Action
Send invoiceEmails an invoice to the supplied email address (or the invoice's billing email if omitted).
Action
Update customerUpdates an existing customer (sparse update). Requires the customer Id and current SyncToken.
Action
Update estimateUpdate an existing QuickBooks estimate by Id, changing only the fields supplied.
Action
Update invoiceUpdate an existing QuickBooks invoice by Id — a sparse update that changes only the fields supplied and leaves the rest of the invoice intact.
Action
Update itemUpdate an existing QuickBooks product or service item by Id — name, description, price, income account, or active flag.
Action
Update vendorUpdate an existing QuickBooks vendor by Id — contact details, billing address, terms, or active flag.
Action
Upload attachmentUpload a file to QuickBooks and attach it to a transaction or record — a receipt on an expense, a contract on an invoice.
Action
Void invoiceVoids an existing invoice. Requires the invoice Id and current SyncToken.
Action
Void paymentVoids an existing customer payment. Requires the payment Id and current SyncToken.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews
What our customers say
More from Airtable
Airtable to HubSpotHubSpot is your all-in-one stop for all of your marketing software needs.
Airtable to SlackSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Airtable to Google CalendarGoogle Calendar is a time management tool providing scheduling features, event reminders, and integration...
Airtable to Google DriveGoogle Drive is a cloud storage solution for uploading, sharing, and collaborating on files across devices...
Airtable to ShopifyShopify is a commerce platform for online stores and retail point-of-sale.
Airtable to PipedrivePipedrive is a sales CRM and pipeline management tool.
More into QuickBooks Online
HubSpot to QuickBooks OnlineHubSpot is your all-in-one stop for all of your marketing software needs.
Slack to QuickBooks OnlineSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Google Sheets to QuickBooks OnlineGoogle Sheets
Gmail to QuickBooks OnlineGmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...
Google Calendar to QuickBooks OnlineGoogle Calendar is a time management tool providing scheduling features, event reminders, and integration...
Google Drive to QuickBooks OnlineGoogle Drive is a cloud storage solution for uploading, sharing, and collaborating on files across devices...
Questions
Airtable and QuickBooks Online, answered
Can an Airtable record create an invoice against the right customer in QuickBooks Online?
Yes. The agent can use Find customer by name with the name on the Airtable record, and only continue to Create invoice when a match comes back, so invoices are not raised against an unknown customer.
Will Airtable show when an invoice has been paid?
Yes. The New paid invoice trigger fires when an invoice's balance reaches zero, and the agent can then run Update Record in Airtable to set the status and any date or amount fields you keep on the job record.
What can start an automation from Airtable?
Any of Airtable's 2 triggers in the catalog, including New or Updated Record and New Record. Describe the moment in plain language and your agent picks the right one.
What can your agent do in QuickBooks Online when something happens in Airtable?
Any of QuickBooks Online's 45 actions, including Create estimate, Create vendor, Find customer by name and Create account. Your agent maps the data both ways and tests every scenario before it ships.
Can it also run from QuickBooks Online to Airtable?
Yes. When something happens in QuickBooks Online, your agent can act in Airtable too. This page covers both directions: QuickBooks Online's triggers and Airtable's actions are listed here as well.
Do I have to build a connector for Airtable or QuickBooks Online?
No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running.
Can my AI client use Airtable and QuickBooks Online without building an automation?
Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both.
What happens when something fails?
Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.
Is there a free plan?
Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.