Start free

AfterShip connector · Shipment tracking reports

Read & reportRead-only source

Spot stuck and failed deliveries before customers write in.

Bring every AfterShip shipment into your reports and AI assistants, with its courier, delivery status, the courier’s latest message, order number and transit days.

  • Find shipments stuck in Exception or a failed delivery attempt
  • Compare transit days and exceptions by courier and country
  • Ask ChatGPT or Claude which orders need a follow-up today
AfterShipSheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

AfterShip reportSample data
Order numberStatusCourier
#1042Deliveredups
#1047Exceptionusps
#1051InTransitdhl
Refreshes on your schedule in Google Sheets

AfterShip reporting for one account

One AfterShip account is the data source. Reports list the shipments created in your report dates, in UTC days, as they stand now.

Delivery status

Read each shipment’s status, such as InTransit, OutForDelivery, AttemptFail, Exception or Delivered, with the sub-status and the courier’s latest message.

Couriers and routes

See the courier, tracking number, origin and destination country for every shipment.

Orders

Match shipments to orders by order number, so support can reach the right customer.

Transit time

Compare created, updated and delivered dates, and the transit days AfterShip counts.

Report datasets and details

Reports you can build

1 reporting dataset with its own fields. Open it in the app, then choose your columns.

  • Trackings
What each dataset reports
  • Trackings

    AfterShip shipments created in the report dates (AfterShip keeps the last 120 days), with courier, delivery status and sub-status, order number, origin and destination, transit days and delivery date.

Metrics and dimensions

13 report fields across 1 dataset.

Search the available fields. Hover or tap a field to see what it means.

Send AfterShip data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAsk Claude about these numbers in a sentence.
ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect AfterShip to ChatGPT or Claude for delivery questions

Use Datapipe’s MCP access as your AfterShip reporting tool. Ask about late parcels, couriers and delivery exceptions.

Example

Which shipments from the last two weeks are in Exception or AttemptFail, and which orders are they?

List shipments created in the last 14 days with status Exception or AttemptFail, with the order number, courier, destination country and the courier’s latest message.

Start with AfterShip

What you need

An AfterShip API key from Settings, API Keys in AfterShip.

What to know

Read-only. Shipments created in the last 120 days, the period AfterShip keeps them, up to 20,000 per report. Trackings and customer notifications are never changed.

How it works

  1. Create your free account, then choose AfterShip in Data sources.

  2. Paste your AfterShip API key.

  3. Choose the shipments report and a destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with AfterShip

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Every shipment created in your report dates, with tracking number, courier, status and sub-status, the courier’s latest message, order number, origin and destination country, transit days and the created, updated and delivered dates.

Up to 120 days, the period AfterShip keeps shipments.

No. It only reads shipments. Trackings, couriers and customer notifications stay as they are.

Yes. Group shipments by courier to compare transit days and how many end in Exception or a failed attempt.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each AfterShip account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

Keep every parcel in view.

Start free, add AfterShip and bring shipment status into the tools you already use.

Start free See setup requirements