Log Shopify orders in Google Sheets and flag big ones in Slack

Every new Shopify order becomes a row. Orders over your threshold also post a short note to a Slack channel.

Updated .

A guide, not professional advice. Test before you use it for real. See terms.

A Shopify store owner who wants a running order sheet and a heads-up on big orders.

Not sure which one to use? See Make vs n8n.

Problem

Large orders sit in the Shopify admin until someone happens to look.

What you need

ShopifyGoogle SheetsSlackMaken8n

How it connects

Steps

  1. Set up the sheet

    Columns: order number, date, customer email, total, currency, and a Slack column for "sent". Keep one row per order.

  2. Watch new orders

    Make: Shopify Watch orders. n8n: Shopify Trigger on order creation. Place a test order so the fields show up for mapping.

  3. Add the row

    Make: Google Sheets Add a Row. n8n: Google Sheets Append Row. Map the order number, total, and currency as they come from Shopify.

  4. Check the threshold

    Make: a filter on the route to Slack, total greater than your number. n8n: an If node with the Number condition is greater than. Start with a number your team agrees on.

  5. Post to Slack

    Make: Slack Send a Message. n8n: Message > Send. Post the order number, total, and a link to the order in the Shopify admin. Leave out the customer's address.

Time

Build time is about 30 minutes, estimated by the recipe’s author. It is not a measured average.

Saves copying orders into a sheet and checking the admin for large ones.

Cost

Your Shopify plan, a Google account, Slack, and Make or n8n per their current pricing.

What it doesn’t do

It doesn’t fulfill, refund, or edit orders. It doesn’t watch for fraud. Edits made to an order later don’t update the row.

Build it

The account is yours. The Make link is an affiliate link.

Create a Make accountSee n8nMore e-commerce recipes

Sources