Automations

How to send Shopify orders to Google Sheets

The short answer

Use Shopify Flow's "Add row to spreadsheet" action or an automation that adds a row on each new order. Decide one row per order or per item first, and catch cancellations, which a new-order trigger never sees.

4 min read

Which setup do you need?

How often do you need the orders in a sheet?

Use Shopify's CSV export

Orders, Export. Up to 50 orders download at once; bigger exports are emailed to you. Extra line items already sit on their own rows.

What will you do with the sheet?
Automation

One row per order

Order number, date, customer, items joined in one cell, total. SUM the total column. In Flow, one Add row action.

Automation

One row per item

Repeat the order number on each item row. Sum line prices, never the order total. In Flow, wrap Add row in For each.

Three ways to do it

WayPlanWatch out for
Orders, Export (CSV)Every Shopify planBy hand, each time
Shopify Flow, Add row to spreadsheetFree on Basic, Grow, Advanced, PlusCommas in names split the row
An automation toolThe tool's own planNew order and order paid differ

How to send Shopify orders to Google Sheets

  1. 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.

  2. 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 it

    Captain 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Read next

Or let Captain build it

One sentence to Captain. Free to start.

Build it with Captain
How to send Shopify orders to Google SheetsBuild it