Skip to main content

Abandoned carts worth a call

Every Monday this workflow picks up to 3 valuable carts that customers left behind in the webshop and creates an action in the Action Hub for each one, so a sales rep can call the buyer before the sale is lost.

In short
Where you use itIn the background. The results show in the Action Hub
StartsBy itself, every Monday at 08:00
Changes in PropellerCreates actions. It changes no cart and no order
Uses AINo
TextsEnglish and Dutch
Runs in n8nAbout 4 a month
DifficultyMedium. You set who gets the actions

What you get​

Each action shows the buyer's name, email and phone number, the cart value excluding VAT, how many days the cart has not changed and its 3 most valuable products. The View company button opens the company page.

An abandoned cart action in the Action Hub under Everyone, with the cart, the contact and the View company button

What you need​

  • An n8n account with the credential Propeller API key. See Set up n8n.
  • An API key with Viewer access on Order Data and Owner access on User management. The workflow reads carts and orders. Owner access on User management is what lets it create actions.

How it works​

The workflow looks at open carts that belong to a company, have not changed for 3 to 30 days and are worth at least € 250 excluding VAT. It picks the 3 most valuable, at most one per company. It skips a cart when:

  • it was flagged before and has not changed since
  • its company got an action from this workflow in the last 28 days
  • its buyer placed an order after the cart was last changed

Completing or archiving an action does not bring the cart back.

Good to know

The workflows and agents in the Agent Hub are free to use and adapt. They are examples, not supported product features. Test them in a test environment and check the results before you use them on real customers.

Install it​

Install a workflow from the library explains each step.

  1. Import the file into n8n.
  2. Check that the six nodes that talk to Propeller use the credential Propeller API key.
  3. Open the Settings node and set ASSIGN_TO_ADMIN_USER_ID to the colleague who gets the actions. The number is in the Id column under Admin > Backoffice Users. With null the actions go to nobody and show under Everyone.
  4. Click Execute workflow to run it once.
  5. Click Publish.

After a run you find up to 3 new actions in the Action Hub. A test run is a real run: the actions are real and the carts count as flagged from then on. If nothing appears, no cart qualified.

Make it yours​

SettingDefaultWhat it does
MIN_IDLE_DAYS3Days without changes before a cart counts as abandoned
MAX_IDLE_DAYS30Carts unchanged for longer are left out
MIN_VALUE250Carts worth less, excluding VAT, are left out
TOP_N3Actions per run, at most one per company
COMPANY_COOLDOWN_DAYS28Days before a company can get a new action
ASSIGN_TO_ADMIN_USER_IDnullThe colleague who gets the actions
ORDER_STATUSESNEW, CONFIRMED, VALIDATED, ARCHIVEDThe statuses that count as an order when the workflow checks whether the buyer ordered. See Fill in order status codes

To change the day or the time, open the node Every Monday 8am. Leave SOURCE_NAME as it is: with another name the workflow forgets every cart it flagged.

Limits​

  • A run can take long, because Propeller calculates the price of every cart the workflow reads. In a test with 429 open carts a run took between 7 and 26 minutes.
  • A run checks at most 5,000 carts. The actions say so when that limit is reached.
  • Amounts show in euros.