Complete walkthrough for connecting Shopify to Google Sheets via webhooks. Sync orders, inventory, and customer data in real time — no CSV exports, no apps, no code.
Shopify's analytics are designed for store operators — not for finance teams, external agencies, or custom reporting workflows. Getting order data out of Shopify means manual CSV exports that age the moment you download them, or expensive Shopify app subscriptions for features Google Sheets can handle natively.
With Autometon connecting Shopify to Google Sheets via webhooks, every order, inventory change, and customer event writes to your sheet the moment it happens. Build custom dashboards with the exact metrics Shopify Analytics can't surface — SKU velocity, customer LTV by cohort, multi-channel attribution — using formulas your team already knows.
Shopify supports webhooks for all major store events. Here are the most useful ones to route to Google Sheets:
orders/create — fires when a new order is placed. Contains order ID, customer details, line items, total price, and fulfilment status. Use this for your primary order log.
orders/updated — fires when an order is edited, fulfilled, or cancelled. Use to track fulfilment status changes.
orders/paid — fires specifically when payment is captured. Useful for revenue tracking.
inventory_levels/update — fires on every stock level change. Use for real-time inventory tracking and low-stock alerts.
customers/create — fires on new customer registration. Use to track acquisition and build customer lists.
Recommendation: Start with orders/create and inventory_levels/update. These two cover 80% of ecommerce reporting needs.
Log in to Autometon, click New Pipeline, select Shopify. Copy your unique webhook URL.
In Shopify Admin: Settings → Notifications → Webhooks → Create Webhook. Select the event (Orders: Create to start). Paste your Autometon URL. Format: JSON. Save.
Place a test order in your Shopify store or use Shopify's "Send test notification" button. Autometon receives the JSON payload and auto-detects all fields — order_id, customer, line_items, total_price, and more.
Autometon's visual mapper shows every detected field. Map id → Order ID, total_price → Revenue, customer.email → Customer Email, line_items[0].title → Product. Confirm and save.
Share your Google Sheet with Autometon's service account email and click Activate. Every Shopify order now writes a row to your sheet in under 5 seconds.
=SUMIF('Raw Data'!A:A,TODAY(),'Raw Data'!C:C)
Where column A is the order date and column C is revenue. Shows today's revenue, updating with every new order.
Use a pivot table: rows = Product, values = Quantity (Sum). Sort descending. Updates automatically as orders come in.
In your inventory sheet: =IF(C2<=10,"⚠️ REORDER","OK") where C2 is stock level. Apply red conditional formatting on "REORDER". Every inventory webhook re-evaluates this automatically.
Use SUMIF on customer email to total all orders per customer. Sort descending for a live LTV leaderboard.
| Event | Field | Recommended Column |
|---|---|---|
| orders/create | id | Order ID |
| orders/create | total_price | Revenue |
| orders/create | customer.email | Customer Email |
| orders/create | fulfillment_status | Fulfilment Status |
| inventory_levels/update | available | Stock Level |
| customers/create | email, created_at | Customer Email, Sign-up Date |
Connect Shopify to Sheets in minutes. Orders, inventory and customers in real time.
Real-time stock alerts in Google Sheets. Low-stock flags, automated.
How ecommerce teams use Autometon to automate their Google Sheets.
Set up your first real-time integration in under 5 minutes. No code required.
Get Started Free