Coming soon
Shopify to Google Sheets.
Connect Shopify orders, products, inventory, customers, and more to Google Sheets. Bring your store data into the spreadsheets your team already uses.
Shopify data in Google Sheets
Orders, sales, and draft orders
Bring order dates, line items, quantities, taxes, shipping charges, and payment status into Sheets. Review sales by product and period, and follow draft orders alongside completed orders.
Products, variants, and collections
Review titles, SKUs, barcodes, variant options, prices, product status, and collections together. Build catalog reports at the product or variant level without assembling separate exports.
Inventory by location
Bring stock quantities into Sheets by inventory item and location. Keep available, on-hand, and committed stock distinct, and use the data alongside sales to plan replenishment.
Customers and order activity
Work with permitted customer records, tags, and order activity in your own customer reports. Available personal fields depend on Shopify permissions and approved customer-data access.
Discounts, refunds, and returns
Review discount codes and applications, refunded items and amounts, and return records against their orders. Keep returns and refunds separate so your reports reflect both the product movement and the money returned.
Fulfillment and shipping
Follow fulfillment status, shipped items, tracking details, and their related orders. Build an operations view for orders waiting to ship, partial fulfillments, and delivery follow-up.
Payments, transactions, and payouts
Review payment transactions and status, and compare Shopify Payments payouts, fees, and adjustments with your orders where available. Financial coverage depends on the payment provider and your store permissions.
Metafields and store content
Bring permitted metafields and metaobjects into Sheets alongside your catalog. Review store pages and blog posts, so your team can work with content and custom data in one sheet.
What you can build in Google Sheets
Sales and margin reporting
Start regular reporting with scheduled Shopify imports. Add your own product costs and operating expenses, then build sales, discount, refund, and margin calculations that fit your business.
Inventory and replenishment planning
Review stock by location alongside units sold. Add supplier lead times and incoming stock to your sheet to build the purchasing and replenishment plan your team needs.
Catalog and content reviews
Keep products, variants, collections, and custom fields in a shared review sheet. Find missing information or inconsistent values, and give your team a clear list of items to investigate.
Amazon and Shopify in one workbook
Bring Shopify store data into the same reporting workflow as your Amazon data. Compare channel sales and product performance in Sheets with your own formulas and metrics.
Frequently asked questions
Hopted brings Shopify store data into your Google Sheets workbook. Use your own formulas, tables, and dashboards to review orders, products, inventory, customers, and financial data.
Import orders, draft orders, products, variants, collections, inventory, customers, discounts, refunds, returns, fulfillment, payments, and permitted custom and store-content data. Available datasets and fields depend on Shopify permissions and your store's data.
Shopify makes the most recent 60 days of orders available to apps by default. Access to older orders requires additional approval. Historical coverage depends on the permissions granted to the connector.
Import permitted customer records and order activity into Google Sheets. Access to personal customer fields depends on your permissions and Shopify approval.
Bring available Shopify Payments financial data into Sheets alongside order transactions. Shopify Payments payouts and fees are specific to Shopify Payments; other payment providers may have different data available.
Hopted imports accessible Shopify store records into Google Sheets. Shopify Analytics reports can use their own metric definitions and calculations. Use the imported data to build reports with the metrics your team needs.
Use scheduled refreshes to keep your Shopify data updated in Google Sheets. Data freshness also depends on Shopify's data availability.
This connector imports Shopify data into Google Sheets for reporting and analysis. Bulk edits, store migrations, and sending changes back to Shopify are outside the scope described here.
Yes. Bring Shopify data into the same workbook as your Amazon Seller Central, Amazon Vendor Central, or Amazon Ads data. Compare channels with your own formulas, charts, and reporting models.
No. Enter your email in the form above to receive the launch notification. Signing up is free and does not start a trial or subscription.