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 itIt builds an automation that writes only to your sheet, so nothing needs approval.
How to send Shopify orders to Google Sheets
Tell Captain if you want one row per order or one per item. It asks which sheet to use.
CaptainSet 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.
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
Shopify
Google Sheets- Asks first
- Nothing outside your own sheet
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 SheetsConnectPer 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
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
Make it yours
Change one thing, and Captain builds that version instead.
- “Set up an automation: every new Shopify order over $100 is added as a row to my Google Sheet with its items and total”Only orders over $100
- “Set up an automation: every paid Shopify order is added as a row to my Google Sheet with its items and total”Adds orders once they are paid
- “Set up an automation: every new Shopify order is added as a record to my Airtable base with its items and total”Records go to Airtable, not Sheets
- “Set up an automation: every new Shopify order is added as a row to my Google Sheet and posted in a Slack channel”Each order in Slack too, after your OK
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.