Import Offline Orders Into Shopify From a Google Sheet

4 min setup

No coding required

Runs automatically

Orders taken at trade shows, over the phone, or on another platform often end up in a spreadsheet or a CSV export instead of Shopify. This workflow creates a Shopify order for every new row added to a Google Sheet, so you can paste in a CSV export or log sales as they happen, then writes the new Shopify order number back into the row so nothing gets imported twice.

Use this template → Related article

Google Sheets Row Created (Trigger)

Filter

Shopify Create Order

Google Sheets Update Row

How it works

4 steps to turn every new spreadsheet row into a Shopify order automatically

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

Start when a new row is added to the chosen spreadsheet and sheet. Expect columns such as Customer Email, First Name, Last Name, SKU or Variant ID, Quantity, Price, Shipping Address, and Shopify Order.

App connector: Filter • Time to complete: 1 minute

Continue only if Customer Email and Variant ID are filled in and the Shopify Order column is empty, so blank or already-imported rows are skipped.

App connector: Shopify • Time to complete: 1 minute

Create a Shopify order for the customer email in the row, with the row's variant, quantity, price, and shipping address, and add an order tag such as imported-from-sheet so these orders are easy to find later.

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

Write the new Shopify order number into the Shopify Order column of the same row, so the sheet shows which order each row became and the row is never imported again.

Trusted by 1,000+ merchants

Ready to turn every new spreadsheet row into a Shopify order automatically

Get setup in 4 minutes.

Use this template →

FAQs

Can I import a CSV file of past orders this way?

Yes. Paste the CSV rows into the connected sheet, matching the column headers, and the workflow creates one Shopify order per new row.

Will this create duplicate orders?

The workflow only runs on new rows, and the filter skips any row that already has a value in the Shopify Order column, so editing a row doesn't create a second order.

Do imported orders send customer notifications?

That depends on how you configure the Create Order step. Leave customer notifications off when you're importing historical orders, and turn them on only for live orders you want the customer to hear about.

Personalize this template

Customize this workflow even further:

Alert the team on new imports

Add a Slack or email step after Create Order so whoever fulfills offline orders hears about each one as it lands in Shopify.

Mark orders as paid or pending

Add a Financial Status column and map it in the Create Order step, so prepaid and net-terms orders arrive with the right status.

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

PetFriendly

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

Zailys

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

Rothy's

turn every new spreadsheet row into a Shopify order automatically

4 min setup • Fully supported if you need help