Can I export my Shopify Analytics Reports directly to Google Sheets?

Yes, you can!

EZ Exporter supports an Analytics export via the ShopfyQL API and also has a direct Google Sheets integration.

This allows you to create multiple templates/export profiles for different Shopify Analytics Reports (simply copy/paste the same ShopifyQL query from the Shopify Admin into the app) and schedule them to push the data automatically to a specific sheet/tab of an existing Google Sheets spreadsheet.

We also have pre-built Analytics templates in the app you can use to get started very quickly and can be customized further.

Some examples:

  • Inventory Adjustment History (Last 30 Days)
  • Items Bought Together (Year to Date)
  • Net Payments by Order (Last 90 Days)
  • Products by Sell-Through Rate (Last 30 Days)
  • Sessions and Pageviews by Hour (Last 24 Hours)
  • Sessions by Landing Page (Last 30 Days)
  • Sessions by UTM Campaign (Last 30 Days)
  • Total Sales by Bundle (Last 90 Days)
  • Total Sales by Discount Codes (Last 365 Days)
  • Total Sales by Product Variant (Last 30 Days)
  • Total Sales by Sales Channel (Year to Date) 
  • Total Sales by UTM Campaign (Last 30 Days)
  • Total Sales by UTM Source (Last 30 Days)
  • UTM Parameters by Order (Last 30 Days)

You can run the export manually or schedule them to run automatically every 15 minutes, every 30 minutes, hourly, daily, weekly, or monthly.

Feel free to contact us if you have any questions about this functionality!


App: EZ Exporter

Tags: analytics, google sheets, shopify analytics, shopify analytics reports