Track Order Confirmations from Gmail in Airtable

Every online purchase generates a confirmation email, followed by shipping updates and delivery notifications. Buried across your inbox, these are hard to find when you need to check a tracking number or return an item. By forwarding them to Airtable, you get a single base that tracks every order from purchase to delivery.

Why Track Orders in Airtable?

• Kanban by status — See orders move from "Ordered" to "Shipped" to "Delivered" at a glance
• Calendar view — Visualize expected delivery dates on a timeline
• Grouped grid by vendor — See all Amazon orders together, all Shopify orders together
• Automations — Get notified when an order status changes or a delivery is overdue
• Filtering — Instantly find any order by vendor, date, or tracking number

Setting Up Your Order Tracker

Create an Airtable base with an Orders table:

Connecting Your Email (via Quicktion)

Method 1: Email Forwarding

Best for automatic logging. Set up Gmail filters for common order confirmation senders and forward them to your Quicktion address.

Common filters to create:

• from:auto-confirm@amazon.com — Amazon orders
• from:*@shopify.com subject:confirmation — Shopify store purchases
• from:transaction@notice.etsy.com — Etsy orders
• from:no_reply@email.apple.com subject:receipt — Apple purchases
• from:*@ebay.com subject:order — eBay purchases

Combine them into a single filter if you prefer:

from:(auto-confirm@amazon.com OR *@shopify.com OR transaction@notice.etsy.com)

Each matching email automatically appears as a row in your Orders table. See our Airtable email setup guide for detailed instructions.

Method 2: Gmail Add-on

Best for selectively saving specific orders. Open a confirmation email in Gmail, click the Quicktion add-on, and save it. Useful when you only want to track certain purchases (e.g., business expenses but not personal orders). Check out our Gmail-to-Airtable integration guide for setup.

Order Tracking Workflow

Status Board (Kanban View)

Create a kanban view grouped by Status. As shipping updates arrive, drag orders from "Ordered" to "Shipped" to "Delivered." You get a real-time overview of everything in transit.

Delivery Calendar

Use calendar view on the Date field to see when orders were placed. If you add an "Expected Delivery" date field, you can use that for a delivery timeline instead.

Vendor Summary (Grouped Grid)

Group by Vendor in grid view to see all orders from each store together. Add a summary row to total the Amount field per vendor — useful for spotting how much you spend at each retailer.

Overdue Shipments

Create an automation: if Status is "Shipped" and the date is more than 7 days ago, send yourself a reminder to check tracking. This catches delayed deliveries before they become problems.

Tips

1. Update status with shipping emails — When a "Your order has shipped" email arrives, update the existing record rather than creating a new one. Use the order number to match them.
2. Add a "Category" field — Tag orders as "Personal", "Business", or "Gift" to separate expenses.
3. Use the Amount field for budgeting — Add a summary bar in grid view to see your monthly spending total.
4. Save attachments — Many confirmation emails include PDF receipts. Quicktion saves these in the Attachments field for easy access during returns or reimbursements.
5. Archive delivered orders — Move "Delivered" orders to a separate view to keep your active tracker clean.

Get Started

Sign up for Quicktion, create a destination linked to your Orders table, and set up Gmail filters for your most common retailers. Your order confirmations will start logging automatically.

Prefer a different tool? See how this works with Notion or Google Sheets.