Skip to content
Workflow · Clean and combine · Opening soon

Airtable to Excel with linked records resolved

Export the Orders table from Airtable as a file and upload it. Mammoth splits the linked customer and product fields, looks up the names, and keeps the order rows in place.

Early access opens shortly. Check back soon.

Someone typed

“export our airtable orders table to excel with the linked customer and product records shown by name instead of record ids, and flag orders whose linked customer or product record no longer exists and orders linked to more than one customer”

The agent read it as

Export our Orders to Excel with the linked customer and product records shown by name instead of record IDs, and flag orders whose linked customer or product record no longer exists and orders linked to more than one customer.

What the agent built

7 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Orders
    CSV export · 40 rows
  2. File
    Customers
    CSV export · 15 rows
  3. File
    Products
    CSV export · 12 rows
  4. Step
    Split customer links
    Step 3
  5. Step
    Prepare customer lookup
    Step 1
  6. Step
    Prepare product lookup
    Step 2
  7. Join
    Show customer names
    40 of 42 paired
  8. Step
    Split product links
    Step 5
  9. Join
    Show product names
    43 of 46 paired
  10. Step
    Flag missing and multiple links
    Step 7
  11. Result
    Order Link Flags
    40 rows
  12. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 40 rows.

What you get back

The result of that run, the rows to look at first.

Order Link FlagsSample data40 rows
Order IDCustomerProductsCustomer link statusProduct link statusTotalOrder date
ORD-1021·Linden FrameMissing customerLinked143.502026-11-05
ORD-1036Lumen HomeCobalt LampLinkedMissing product2672026-11-21
ORD-1037·Drift CandleMissing customerLinked812026-11-21
ORD-1038Oakstone Supply, Newcrest OutfittersElm TrayMultiple customersLinked1542026-11-21
ORD-1040Riverton Co, Quarry Nine·Multiple customersMissing product2302026-11-21
ORD-1001Northwind AtelierAster MugLinkedLinked1252026-09-26
ORD-1002Bluebell MarketCobalt LampLinkedLinked89.502026-09-28
ORD-1003Cedarline GoodsDrift Candle, Bramble NotebookLinkedLinked2142026-09-30
ORD-1004Harbor & PineElm TrayLinkedLinked642026-10-02
ORD-1005Juniper TrailFjord BlanketLinkedLinked178.252026-10-04
ORD-1006Lumen HomeGrove ToteLinkedLinked1322026-10-06
ORD-1007Maple DistrictHarbor TumblerLinkedLinked2452026-10-08
40 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Order Link Flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Order Link Flags: questions

How do you export Airtable orders to Excel with linked records resolved?
Export the Orders table from Airtable as a file and upload it. Mammoth splits the linked customer and product fields, looks up the names, and keeps the order rows in place. It also flags orders where a linked customer or product is missing, or where an order links to more than one customer.
Which Airtable export should you use?
Use the export of the table that holds the rows you want to work with, here the Orders table. The file should include the linked customer and product fields you want to resolve.
What happens to rows that do not match?
Rows stay in the file. If a linked record cannot be found, or if a row has more than one linked customer where that should not happen, it is flagged so you can review it.
How do you change the rules?
You change the steps in words. You can adjust which fields are split, which lookup fields are used for names, and which rows are flagged by changing the workflow instructions.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.