How to Connect Shopify to Google Sheets (2026)

How to connect Shopify to Google Sheets, step by step

1. 1

   Create a sheet with a header row: Order ID, Date, Customer Email, SKU, Quantity, Line Total, Order Total, Fulfilment Status, Discount Code.

2. 2

   Add a Shopify 'New Order' trigger; use orders/paid rather than orders/create if you only want paid orders.

3. 3

   Connect Shopify with a custom app token scoped to read_orders and read_products only.

4. 4

   Add an iterator or loop over line_items — an order with three products should write three rows, not one.

5. 5

   Inside the loop, add 'Add Row' to Google Sheets and map SKU, quantity and line price from the current item, plus the shared order fields.

6. 6

   Add a formula column in the sheet (not in the automation) for margin, so it recalculates when you update cost data.

7. 7

   Place a test order in Shopify, verify the row count matches line items, then enable.

Common mistakes to avoid

• Writing one row per order loses line-item detail — always iterate if you care about SKU-level reporting.
• Google Sheets slows badly past ~50,000 rows; roll over to a new tab per quarter for busy stores.
• Cancelled and refunded orders need their own paths, or your revenue total will overstate.

Other tools that can do this

Frequently asked questions