Operations · Easy
Keep a live sheet of every online order
A shared spreadsheet of orders is still the easiest way for a small team to pack, chase and report. Filling it automatically means no copying and no missed orders.
Software used
Has a free plan
Shopify
Google Sheets
What happens
When
A new order comes into your Shopify store.
Then
- Make reads the order.
- It adds a row to Google Sheets with the customer, items, total and date.
How the tools connect
With a built-in integration. Make lists Shopify as an integration on its website.
Set it up
In Make, create a scenario that starts with Shopify's new order module.
Add Google Sheets' add-a-row module and map the order fields to columns.
Run it once with a test order, then schedule it.
Menus change, so these steps say what to do rather than where to click. Each company's help pages have the current screens.
Watch out for
- Keep customer details in a sheet only the people who need them can open.
- Each run uses Make credits; check your plan.
Track these tools in My stack
Add the software you pay for and see which automations you can set up with it.
Ideas for my stackRelated automations
Operations · Easy · Built-in integration
Add a video link to every booking automatically
Copying meeting links by hand causes wrong links and late starts. With the two connected, each booking gets its own link in the invitation.
Operations · Easy · Built-in integration
Turn chat requests into tracked tasks
Requests made in chat get lost once the conversation scrolls away. Creating a task from the message keeps a link to it, with an owner and a due date.
Operations · Some setup · Automation tool
Start a client onboarding project when a deal closes
The hand-over from sales to delivery is where details get lost. Creating the project from a template when the deal is won means every client gets the same first steps.