Email Each Vendor Their Items When an Order Is Paid

5 min setup
No coding required
Runs automatically

Drop-ship and multi-vendor stores have to tell each supplier what to ship. This workflow splits every paid order by vendor, looks up each vendor's email in a Google Sheet, and emails each one only their items with the shipping address.

Shopify logo icon
An order's payment goes through
Go through each vendor
google sheets logo icon
Look up the vendor's email in Google Sheets
email icon
Email the vendor their items

How it works

5 steps to send each supplier only their part of every order

Shopify logo icon

An order's payment goes through

App connector: Shopify • Time to complete: 1 minute

Runs when an order is paid.

Group the order's items by vendor

App connector: Loop • Time to complete: 1 minute

Group the line items by their vendor field, so each vendor has one list of titles, SKUs and quantities.

Go through each vendor

App connector: Loop • Time to complete: 1 minute

Loop over the vendor groups.

google sheets logo icon

Look up the vendor's email in Google Sheets

App connector: Google Sheets • Time to complete: 1 minute

Find the row in your Vendors sheet whose Vendor column matches, and read its Email column. Skip vendors with no row, such as items you ship yourself.

email icon

Email the vendor their items

App connector: Email • Time to complete: 1 minute

Email the vendor the order number, their items with SKUs and quantities, and the shipping address.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to send each supplier only their part of every order

Get setup in 5 minutes.

Use this template →

FAQs

Will vendors see each other's items?

No. Each vendor's email lists only their own line items.

Why keep vendor emails in a Google Sheet?

So anyone can add or change a vendor without editing the workflow.

Can I attach a packing slip?

Not as a PDF, but the email can include everything a packing slip shows.

Personalize this template

Customize this workflow even further:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

send each supplier only their part of every order

5 min setup • Fully supported if you need help