Skip to content
Use case· 3 steps

How do I send Shopify orders to Google Sheets automatically?

Build a real-time order log without exporting CSVs. Every new Shopify order appends to a Google Sheet you can pivot, share and analyze.

How it works

Set up "Log every Shopify order to a Google Sheet" in 3 steps

  1. 1
    Trigger on a new order
    Add the Shopify → New Order trigger and pick your store.
  2. 2
    Pick your sheet
    Add the Google Sheets → Append Row action and select the target sheet and tab.
  3. 3
    Map fields
    Map order number, customer email, total, line items count and created date to columns.
FAQ

Common questions about this recipe

Can I split line items into separate rows?
Yes. Add a Loop node over the order's line_items array and append one row per item.
What about cancellations and refunds?
Add separate workflows that listen for the Shopify → Order Cancelled and Order Refunded triggers.