New BigCommerce order alerts in Slack and Google Sheets

PromptCreate

When a new order comes in on BigCommerce, run this workflow. Trigger on the BigCommerce webhook for order events (store/order/statusUpdated and/or store/order/created) so every incoming order fires the automation the moment BigCommerce publishes it. The webhook payload carries the order id — use that as the input to the fetch steps below.

Step 1: Use Get an Order on BigCommerce with the order id from the webhook payload to fetch the full order record (customer name, email, order total, currency, order status, timestamps, billing/shipping address).

Step 2: Use List Order Products on BigCommerce with the same order id to fetch the line items — product name, SKU, quantity, and unit price for each item.

Step 3: Format a deterministic new-order summary and use Send a Message on Slack to post it to a single fixed sales-orders channel. Use Slack mrkdwn formatting. Include, every time: customer name (from the order), order id, order total (formatted with the store's currency), a bullet list of items with quantity and unit price, and the order status. Same channel every run.

Step 4: Use Append Values on Google Sheets to append exactly one row to a fixed tab in a fixed spreadsheet. Columns in this order: order timestamp, order id, customer name, customer email, order status, order total, items summary (concatenate the line items as "SKU x quantity" pairs separated by semicolons), and the BigCommerce order URL. Use valueInputOption USER_ENTERED so the timestamp parses as a date and the total parses as a number.

Keep it deterministic. Same fields every time, same Slack channel, same spreadsheet and tab. Every order must be posted to Slack and appended to Google Sheets — do not skip either destination on any run. If either the Slack post or the Sheets append fails, surface the error and stop so the operator can investigate rather than silently missing a log entry.

What does this prompt do?

Watches your BigCommerce store for new orders and reacts within seconds
Posts a formatted new-order summary to a Slack channel — customer name, order total, item list, and order status
Appends a matching row to a Google Sheet so you have a running log of every order
Uses the same fields, same channel, and same sheet every time so the log stays clean and filterable

What do I need to use this?

A BigCommerce store connected to General Input
A Slack workspace and a channel where the order alerts should land
A Google account with a spreadsheet and tab ready to receive rows

How can I customize it?

Swap the Slack channel or tweak the message format (emoji, bold labels, a link back to the order)
Add or remove columns in the Google Sheet to match whichever fields matter to you
Filter which orders trigger the alert — for example only orders above a certain amount, or only paid orders

FAQs

Will I miss orders if my computer is off?

No. The workflow runs on our servers and reacts the moment BigCommerce reports a new order, whether or not your machine is on.

How fast does the Slack alert land after an order comes in?

Usually within a few seconds of BigCommerce publishing the order event to us.

Can I use this with more than one BigCommerce store?

Yes. Connect each store as its own credential and either duplicate the workflow per store or route them into different Slack channels.

Does the Google Sheet need to exist first?

Yes. Create the spreadsheet and the tab with your header row before turning the automation on, then point the workflow at it.

Can I extend this to also send an email or create a task?

Yes. Adding an email step, a CRM update, or a task creation on top of the Slack and Sheets steps is a natural extension.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.