Mailhook and BigCommerce: Supplier Catalog Email to Products Template

This Spojit template turns a supplier catalog spreadsheet emailed to a Mailhook address into created or updated retail products in BigCommerce.

What It Builds

A Mailhook trigger gives the workflow its own inbound address. When a supplier emails a catalog, an Attachment node pulls the spreadsheet bytes, a CSV utility parses the rows, and a Loop walks each line. For every product, a BigCommerce Connector node creates a new listing or updates the matching SKU with the latest name, price, and stock.

The Prompt

Paste this into Miraxa and it builds the workflow, connecting the tools for you:

Build a workflow that triggers when a supplier emails a catalog spreadsheet to a Mailhook address. Fetch the attached CSV, parse each row for SKU, name, price, and stock quantity, then for each row create the product in BigCommerce if the SKU is new or update its price and inventory if it already exists.

Connectors Used

Mailhook - the trigger; the workflow gets a dedicated @mailhook.spojit.com address that suppliers email.
Attachment node - fetches the catalog file bytes from the inbound email.
CSV utility - parses the spreadsheet rows into structured fields.
BigCommerce - creates or updates each retail product by SKU.

Customize It

Tweak the prompt to match your catalog: change the column names (such as cost, barcode, or category), add a markup rule to set retail price from supplier cost, or restrict updates to price only so descriptions stay untouched. You can also have it skip rows with missing SKUs.

Tips

Give your BigCommerce connection write scope for products and inventory so create and update both succeed.
The Attachment node is Mailhook-only; it handles the file fetch so the catalog never needs a shared drive.
Use a Direct-mode BigCommerce node for predictable, no-AI-cost writes once the field mapping is settled.