Which setup do you need?
Three ways to do it
| Way | Plan | Watch out for |
|---|---|---|
| Orders, Export (CSV) | Every Shopify plan | By hand, each time |
| Shopify Flow, Add row to spreadsheet | Free on Basic, Grow, Advanced, Plus | Commas in names split the row |
| An automation tool | The tool's own plan | New order and order paid differ |
How to send Shopify orders to Google Sheets
Step 1: Build the header row
Order number first, then date, customer, the columns for your choice above, and a Status column. Freeze the header.
Step 2: Pick the trigger on purpose
New order catches every order, paid or not; order paid catches only money in. In viaSocket's catalog Shopify has "New Order", "Order Paid" and "Order Cancelled" triggers.
Do this step in 50agents
Set up an automation: every new Shopify order is added as a row to my Google Sheet with its items and total
Build itCaptain reads a real order from your store to plan the columns, tests the steps on it, and keeps the automation as a draft until you make it live. See the ready-made version.
Step 3: Map line items deliberately
One row per order: join items in one cell ("2 x Oat Latte Blend, 1 x Grinder"). One row per item: loop over the line items and repeat the order number.
Step 4: Clean the text
Strip commas and line breaks from product names and notes, or quote them, so columns stay in place. In Flow, Shopify suggests a Liquid replace filter.
Watch out. Flow writes row contents comma-separated, so one comma in a product name shifts every column after it.
Step 5: Catch cancellations
A second automation on "Order Cancelled" finds the order number in the sheet and sets Status to Cancelled. Do the same for refunds if you report on them.
Step 6: Test with a real order
Place a test order with two products, one with a comma in its name, then cancel it. You should see one or two rows, then a Cancelled status.
What can go wrong
Edited orders leave old numbers
Items and quantities can change after an order is placed, and a new-order trigger never sees it. Add an update step, or reconcile from Shopify monthly.
Duplicate rows
Shopify retries webhooks up to 8 times over 4 hours when an endpoint does not answer within 5 seconds. Look the order number up before adding.
Only paid orders arrived
You picked "order paid" but wanted cash-on-delivery orders too. Switch to new order and keep a Status column.
The sheet slows down
Google Sheets holds up to 20 million cells, but a sheet full of formulas slows far sooner. Start a new tab each year.
Questions people ask
Can Shopify export orders straight to Google Sheets?
Not live from the Orders page, which exports CSV files. Shopify Flow's "Add row to spreadsheet" action can write each order into a Google Sheet as it arrives.
Is Shopify Flow free?
Yes, on Basic, Grow, Advanced and Plus. Its "Send HTTP request" action needs Grow or above, but adding sheet rows does not.
How do I get one row per product?
Loop over the order's line items and add a row for each, repeating the order number. In Flow that is the For each step around Add row.
What happens when an order is edited?
A new-order trigger saw only the first version, so the sheet keeps the old numbers. Add a step for edited or cancelled orders that finds the order number and updates its row.
How do I stop duplicate rows?
Look up the order number in the sheet before adding. If it is already there, update that row instead of adding a new one.
Should I trigger on new orders or paid orders?
New order catches every order, paid or not; order paid catches only money in. Pick the one your sheet reports on, and say which in the tab name.