Auto Export Shopify Sales to Google Sheets

# Daily aggregation of Shopify sales into Google Sheets by brand and SKU

This workflow automates the collection and aggregation of sales data from Shopify stores. It fetches orders from the last 30 days via GraphQL API, groups line items by vendor and SKU, calculates totals, and exports the summary to Google Sheets — eliminating manual exports. Designed for store owners, analysts, and procurement teams who need up-to-date sales insights.

## Who it´s for
- Shopify store owners needing regular sales analysis
- E-commerce analysts compiling reports
- Marketers evaluating brand and product performance
- Logistics and procurement specialists planning inventory based on sales data

## What the automation does
- Triggered on a schedule (cron)
- Fetches all Shopify orders from the last 30 days using GraphQL API with pagination
- Parses line items to extract vendor and SKU
- Aggregates data by vendor and SKU, calculating total sales and quantities
- Exports results to a specified Google Sheet
- Runs daily — for example, every morning at 8:43

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic
- Integrations with Shopify (GraphQL) and Google Sheets
- JavaScript code node for data aggregation
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account (cloud or self-hosted)
- Shopify Admin access with GraphQL API permissions
- Shopify API private access token
- Google account with Google Sheets access
- Shareable link to the target Google Sheet

## Benefits and outcomes
- Saves time otherwise spent on manual Shopify exports
- Ensures consistent, hands-free reporting
- Enables trend visualization by brand and SKU
- Supports data-driven decisions on assortment and restocking
- Improves visibility into vendor performance
- Automates foundation for weekly or monthly reports

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat