Hey there @cclark2! In addition to what @BérangèreL gave you for resources, here’s a little from what I know as a HubSpot advisor and partner (and long time user). First, some level setting on the tools. Help Desk is just a workspace sitting on top of the Tickets object, so tickets don’t “move” from a pipeline into Help Desk. They either meet the criteria to show there or they don’t. You almost certainly do not need to rebuild the Airtable integration, but you may need to tweak ticket properties (pipeline, status, source, etc.) and Help Desk settings so those API-created tickets qualify.
Help Desk displays tickets from your ticket pipelines based on the Help Desk configuration (connected channels, routing, and which pipelines/statuses are considered “open”). A ticket created via API or workflow will appear in Help Desk as long as it is in a pipeline and status that Help Desk is using and it meets any routing filters (for example, ticket source, channel, or team).
So why are you only seeing two tickets? Those are likely the only ones that match the Help Desk routing configuration (for example, they came from a connected inbox or have the right status/pipeline combo), while the others differ slightly in properties like pipeline, status, source, or owner. Tickets created via API can default to “Unknown” ticket source or land in a different status than email/chat-generated tickets, which can exclude them from Help Desk queues/views depending on how you have things filtered.
Here’s where I’d suggest you check. In Settings > Objects > Tickets > Pipelines, confirm which pipeline and statuses you use for IT support and that these are the ones your Help Desk workspace is organized around. And in Service > Help Desk, review the views/filters (pipeline, status, owner, team) and confirm they are not inadvertently excluding your Airtable-created tickets.
So I don’t think you need to rebuild anything. You should be able to keep the Airtable → “Create ticket via API” setup. What you may need to do is “just” standardize the ticket properties so they align with Help Desk expectations (correct pipeline, initial status, and any required routing properties). This can be done either directly in your integration mapping or via a HubSpot ticket workflow.
A common pattern is: workflow triggers on Ticket creation where “Source is API” (or a specific property you set from Airtable), then sets the correct Pipeline, Ticket status, and any Help Desk routing properties so they immediately show in the appropriate Help Desk view.
I hope that helps!