Skip to content

Sort shop mail: returns, delivery, after-sales, disputes

The order number is extracted first, then the AI routes the email to returns, delivery, after-sales or payment disputes. Every case is logged in a Table keyed by order number so the team sees all contacts for one order; payment disputes are also flagged and sent to Teams because bank deadlines are short. Table columns: Order, Type, Sender.

By
Loop & Roll team · Official
Copied
0 times
Steps
9
Version
1 · 18 October 2026
Requires
Loop & Roll 1.0.0 or later

Workflow graph

Sort shop mail: returns, delivery, after-sales, disputes Hover a node to see its role · Drag to move the graph
Customer email received — Email receivedCustomer email recei…Email receivedRead the order number — ExtractRead the order numberExtractModelFind the case type — CategorizeFind the case typeCategorizeReturnDeliveryAfter-salesPayment disputeotherModelLog the return — Table — insert or updateLog the returnTable — insert or updateLog the delivery issue — Table — insert or updateLog the delivery issueTable — insert or updateLog the after-sales case — Table — insert or updateLog the after-sales c…Table — insert or updateLog the payment dispute — Table — insert or updateLog the payment dis…Table — insert or updateFlag the dispute — FlagFlag the disputeFlagAlert finance — NotifyAlert financeNotifyOpenAI — OpenAI (GPT)OpenAIgpt-5-mini
Sort shop mail: returns, delivery, after-sales, disputes

How it works

  1. 1

    Customer email received

    trigger.email

  2. 2

    Read the order number

    ai.extract

  3. 3

    Find the case type

    ai.categorize

  4. 4

    Log the return

    table.upsert

  5. 5

    Log the delivery issue

    table.upsert

  6. 6

    Log the after-sales case

    table.upsert

  7. 7

    Log the payment dispute

    table.upsert

  8. 8

    Flag the dispute

    mail.flag

  9. 9

    Alert finance

    notify.send

What you will fill in after import

Nothing personal travels with a template: connections, mailboxes, tables and recipients are left blank for you to pick in your instance.

Tables to choose
Log the return · table Log the delivery issue · table Log the after-sales case · table Log the payment dispute · table
Connections to choose
OpenAI · connection (llm_provider)
Secrets to fill in
Alert finance · webhookUrl