Export Shopify data into Google Sheets

Import data from Shopify into Google Sheets with Awesome Table. Schedule automatic refreshes to periodically update your data.
Shopify
Import data Google Sheets Add-onImport data Google Sheets Add-onImport data Google Sheets Add-on
Shopify data you can export into Google Sheets with Awesome Table
  • Abandoned checkouts
  • Customers
  • Discount codes
  • Inventory levels
  • Locations
  • Marketing events
  • Orders
  • Price rules
  • Product variants
  • Products
  • Transactions
Shopify
What you can do with Awesome Table
Icon solutions - Friendly authentication helper
Friendly authentication helperSign in with OAuth2, basic authentication and API keys.
Icon solutions - Multi accounts
Multi accountsSave and use multiple accounts on the same data source.
Icon solutions - Intuitive data fetcher
Intuitive data fetcherWe make it very easy for you to choose the data you want to import.
Icon solutions - Precise scheduler
Precise schedulerYour queries will run at the exact time you want them to run thanks to our top-notch scheduler.
Icon solutions - Interactive query history
Interactive query historyEasily track and reuse queries you've run before.
Icon solutions - Saved queries
Saved queriesSave queries for later, easily reuse in a different spreadsheet.
Icon solutions - Automatic pagination handling
Automatic pagination handlingEasily extract as many pages of data you need (as long as it fits in a Google Sheet).
Icon solutions - Advanced JSON to Sheet support
Advanced JSON to Sheet supportMultiple JSON to Sheet conversion options, and filtering with JMESPath.
Icon solutions - Email notifications for scheduled queries
Email notifications for scheduled queriesGet notified by email when your queries have run.
A growing number of user-friendly connectors
Awesome Table has a huge number of full connectors that is constantly increasing.
Also, you can connect your spreadsheet manually to any API.
Accounting
CRM, Customer Service
Dev & Design
Any REST APIAny REST API
FigmaFigma
GitHubGitHub
JiraJira
UnsplashUnsplash
VercelVercel
E-Commerce
Productivity
Crypto and Defi
Google Workspace
Social Media
Couldn't find the connector you were looking for?
We're constantly building new data source connectors based on our customers' needs.
If we don't yet offer a connector you'd like to use, please fill the request form.
Suggest a new connector
COMING SOON
CoinglassCoinglass
TikTokTikTok
TwitterTwitter
BigQueryBigQuery
SlackSlack
Google SearchGoogle Search
FirestoreFirestore
TrelloTrello
Google AnalyticsGoogle Analytics
Google My BusinessGoogle My Business