The Scenario
You are a freight coordinator at a distribution company. Your team books LTL freight shipments through several connected LTL carriers in ShipEngine. The problem: nobody has a current list of which services, accessorials, and package types each carrier offers.
Reps book freight based on what they remember or what the carrier's sales rep told them last quarter. Accessorials get missed. Wrong service codes get entered. The carrier rejects the booking or adds fees at pickup.
The fix is a consolidated reference table in Google Sheets before the next booking cycle starts, listing every LTL carrier with their available services and accessorial options. The quarterly planning call is Thursday.
The bad version of building this table:
- Log into ShipEngine's LTL carrier section
- Click through to carrier one and screenshot the services list
- Repeat for each carrier
- Type it all into the sheet
- Realize carrier three's accessorials list does not match what they told you in a recent call
- Spend Wednesday building a table you should have had on Monday.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your connected LTL carrier accounts from ShipEngine and pulls their current service and accessorial data into the sheet.
Open the SheetXAI sidebar and type:
List all connected LTL carriers in ShipEngine and for each one fetch available services and accessorial options, then write carrier name, service name, and accessorial list into my Freight Options sheet. One row per service.
SheetXAI calls ShipEngine's LTL carrier endpoints, retrieves the service and accessorial data for each connected carrier, and writes the results into the sheet. Your reference table reflects the current state of your ShipEngine account.
What You Get
A populated Freight Options sheet:
- Carrier name — the LTL carrier (e.g. "Old Dominion," "XPO Logistics")
- Service name — the available service level for that carrier
- Accessorial list — the accessorials available for that service: liftgate, inside delivery, residential delivery, etc.
The table reflects your account's actual configured carriers, not a generic catalog. If you added a new LTL carrier account last week, it is in the table.
What If the Data Is Not Quite Ready
Freight reference data needs to be structured for the ops team that books the loads. SheetXAI builds the right structure in the same prompt.
When you want package types alongside services and accessorials
The ops team also needs to know which package types each LTL carrier accepts.
Fetch LTL carrier services and package types for all connected LTL accounts in ShipEngine. Write carrier name, service name, accessorial list, and available package types into my Freight Options sheet. One row per service per carrier.
When you want a separate section per carrier instead of one flat list
Your ops team prefers to look up by carrier, not scroll through a combined list.
Fetch LTL carrier services and accessorials for all connected LTL accounts in ShipEngine. Write the results into my Freight Reference sheet with one section per carrier, using the carrier name as a section header. List services and accessorials in rows below each header.
When you want to add a "notes" column for internal carrier preferences
Your team has a standing preference to use certain services over others for specific regions.
Fetch LTL carrier services and accessorials for all connected ShipEngine LTL carriers and write carrier name, service name, and accessorial list into my Freight Options sheet. Add a blank Notes column at the end so the team can annotate regional preferences.
When you need to pull the reference table and immediately cross-reference it against the past 30 days of LTL shipments to see which services are actually being used
You want to know which services are in the catalog but never booked.
Fetch LTL carrier services and accessorials for all connected ShipEngine LTL accounts and write them into the Freight Options sheet with carrier, service, and accessorial columns. Then fetch all LTL shipments from the past 30 days and write the distinct service codes used into a separate Used Services tab. In the Freight Options sheet, add a column indicating whether each service was used in the past 30 days.
The pattern: pull the reference data and usage data together so the planning call has actual numbers to work with.
Try It
Get the 7-day free trial of SheetXAI and ask it to fetch your ShipEngine LTL carrier services and write them into a reference sheet. The ShipEngine integration is included in every SheetXAI plan. For related workflows, see how to list carrier package types for parcel shipments or the ShipEngine in Google Sheets overview.