OTHER

Aging RMA photo-chaser and stale-case sweep

Runs on a schedule to find RMAs that are missing condition photos or stalled in intake, emails the customer a photo request via Front.

CategoryOther
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily scheduled sweep
  • ActionQuery Airtable for stalled or photo-missing RMAsAirtableAirtable
  • LogicSplit into photo-request and SLA-escalation buckets
  • ActionSend photo-request follow-up via FrontFront
  • ActionStamp last-contacted on the Airtable recordAirtableAirtable
  • OutputPost SLA-breach digest to Slack escalation channelSlack

What it does

This scheduled workflow sweeps the RMA tracker for cases stuck in intake — open RMAs with no condition photos uploaded, or graded RMAs sitting past their handling SLA. For photo-missing cases, it sends a templated photo-request reply through Front so the customer can complete the submission. For SLA-breaching cases, it compiles a digest and posts it to a Slack escalation channel so a lead can clear the backlog.

When to use it

Use it when return cases stall because customers never sent photos or because graded RMAs sit unprocessed. It keeps the return pipeline from accumulating silent dead cases.

How it works

  1. 1A daily schedule triggers the sweep.
  2. 2The flow queries Airtable for RMAs missing photos or past the SLA.
  3. 3A logic branch splits the results into photo-request and escalation buckets.
  4. 4For photo-missing cases, a follow-up message is sent through Front and the record's last-contacted field is stamped.
  5. 5SLA-breaching cases are compiled into a digest.
  6. 6The digest is posted to the Slack escalation channel for the returns lead.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect AirtableBases, tables, views, automations.
  2. 2
    Connect FrontShared inbox, conversations.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.