Shopify orders to Google Sheets

Set up an automation: every new Shopify order is added as a row to my Google Sheet with its items and total

Build it

It builds an automation that writes only to your sheet, so nothing needs approval.

How to send Shopify orders to Google Sheets

  1. Tell Captain if you want one row per order or one per item. It asks which sheet to use.

    Captain

    Set up an automation: every new Shopify order is added as a row to my Google Sheet with its items and total

    I’ll set that up. A couple of quick questions first.

  2. New Order starts it, the line items are listed, and Add New Row or Add Multiple Rows writes them. Cancellations can be a second automation.

    Orders sheetAutomation · every Shopify order, rows you choose
    Runs
    When a new order is placed in Shopify
    Does
    Lists each item, variant and quantity · Adds one row per order or item · Writes the order total
    Uses
    ShopifyGoogle Sheets
    Asks first
    Nothing outside your own sheet
  3. Connect both once and pick the spreadsheet and tab. Put your column headings in row one so each value lands in its column.

    ShopifyConnected
    Google SheetsConnect
  4. Per order, you get one row with the items joined in a cell. Per item, each line gets its own row with the order number repeated.

    Orders sheetLive
    • Today, 12:18Added 2 item rows for order 1047
    • Today, 11:02Added 1 item row for order 1046
    • Yesterday, 20:15Added 3 item rows for order 1044

    Example runs

  5. Filter by item, total a day's sales, or hand the sheet to whoever packs the orders.

    Rows added to Orders
    • 1047 | Grace Liu | Linen tote, Natural | 2 | 86.00
    • 1047 | Grace Liu | Enamel mug, Blue | 1 | 86.00
    • 1046 | Ben Ortiz | Wool socks, Medium | 1 | 24.00

    Example

Works with Shopify, Google Sheets and 2,300+ apps

ShopifyGoogle SheetsRazorpayThriveCartWooCommercePayHereFourthwallLemon SqueezyEbayikasVeeqoTagMangoGiftUpZenCommerceStoreHippoSquare
WIXwizishopBoxHeroBigCommerceBase.comFuseDeskDripJumpsellerEcwidMemberfulHubSpotTodoistGoogle DocsSangam CRMSlackFreshsales ClassicAvazaJibble

Make it yours

Change one thing, and Captain builds that version instead.

Questions people ask

Should I use one row per order or one row per item?

One row per order suits daily totals. One row per item suits stock counts and best sellers, since you can filter by product or variant. Say which you want in your ask.

What happens when an order is cancelled?

Shopify has an Order Cancelled event. Build a second automation on it that finds the order's rows and marks them cancelled, so the totals stay honest.

What if the customer edits the items after ordering?

Shopify has an Order Line Items Are Edited event. A second automation on it can update the rows for that order. Without it, the sheet keeps the items from the moment the order was placed.

Can it only add paid orders?

Yes. New Order fires when an order is created, and Order Paid fires when it is paid. Tell Captain you want paid orders only.

Does it add my past orders?

No. It starts with the next order after you build it. For earlier ones, use Shopify's own export and paste the file into your sheet.

What does it cost to start?

50agents is free to start. Tell Captain what you want, read the steps, and tap Build it.

What if a row is wrong or an order is missing?

The automation writes only to your own sheet, so you can fix any row by hand. Check that your headings sit in row one, and ask Captain to adjust the columns if a value lands in the wrong place.

Can I send orders to Airtable or WooCommerce instead?

A variation on this page writes to Airtable, and both Airtable and WooCommerce are in the catalog. Name your tools in your sentence to Captain.

How do I stop or change it?

Tell Captain what to change, such as paid orders only or a new column. Because it writes only to your sheet, a change never asks for approval.

More things Captain can build

Shopify orders to Google Sheets

One sentence to Captain. Free to start.

Build it with Captain
Shopify orders to Google SheetsBuild it