Shopify is the leading eCommerce platform that allows entrepreneurs to create their own online stores. It’s easy to use, so you can create your own store even if you don’t have any experience. Plus, it’s a SaaS (Software as a Service) solution, so you don’t have to worry about hosting or maintenance. In case you have any issues, they also provide exceptional phone, chat, and email support.
Shopify is perfect for entrepreneurs who want to launch their own online store without any hassle or large financial investments. This service also offers various free/paid customizable themes, professionally designed for various business industries. You can also choose from over 1,400 different apps to customize the functionality of your store.
Google Sheets is a spreadsheet service that is part of the free office suite offered as part of Google Drive. The service can be used online, through any modern browser, as well as through mobile apps for Android and iOS or a desktop app for ChromeOS.
This service is extremely popular and can be used for personal needs, education, business, or website development. It’s widely used by large and small companies all over the world. Google Sheets lets you create and edit spreadsheets and connect other apps to collaborate in real-time. It has a user-friendly interface and a wide variety of features, including formulas and data visualization via charts and graphs.
Data exports can help you report and analyze any data from your Shopify store. Hundreds of merchants use data exports for sales, inventory, refunds, taxes, billing, fulfillment, accounting, payments, and many other custom reports. Data exports can be used to create a custom dashboard using Google Sheets.
Today we’re going to discuss how you can connect your Shopify orders to Google Sheets. Let’s get started!
How You Can Import Shopify Orders to Google Sheets
Of course, the Internet is full of different apps and services like Zapier or Automate.io, which you can use to synchronize data between Shopify and Google Sheets. But today we’d like to focus on a single service that we’ve tried out ourselves.
Thus, let’s discuss how you can use Coupler.io. The goal of this service is to synchronize data between various popular business tools, including Google Sheets.
Coupler.io will allow you to import customer, product, and order data from Shopify to Google Sheets on a set schedule. With this tool, you can easily keep an eye on your warehouse inventory (product titles, SKU, stock quantities, etc.) to track your sold-out and reserved products.
Coupler.io will also help you make sales forecasts on past purchases and mix Shopify data with various information. Thus, you can pull your order data to Google Sheets, add a tracking number from your local carriers, and track their updates.
To link Shopify to Google Sheets, follow these steps:
- Select Shopify as your data source;
- Enter the name of your store and the generated API key;
- Pick a data entity to export from Shopify;
- Choose the data destination in Google Sheets;
- Set data refreshes;
- Run the importer and review the progress.
Now, if you need to import your Customer, Product, Orders, and Orders with line items data, you can connect Shopify to Google Sheets.
Choose a name that will make in-app navigation easy for you and your team, e.g.”Shopify Importer,” “Shopify Customer Base,” “Open Shopify Orders,” etc.;
2. Data Source Setup
This is where you should enter your online store name and paste your API key. To generate the latter in Coupler.io Demo, you should go to Apps, scroll down to Manage private apps, and click Create a new private app. Next, in the App details section, you should enter the name of the private app and your email address. This is how Shopify can contact the developer in case there are any issues with the private app (e.g. an API change).
After that, in the Admin API Permissions, choose the online store areas that you want to import to Google Sheets. Provide “Read access” level to Customers, Inventory, Orders, and Products to ensure that you can pull all data supported by Coupler.io. You can find more insights on this step here.
After you’ve generated the API key, you should copy the pass and paste it into the corresponding field (API password). Your pass can always be found on the Private apps page after you select your private app.
Now you can import information about your:
Customers (first and last names, emails, total spend per customer, product ID, last order ID, etc.);
Products (product ID, product title, product vendor, published/updates dates, variation IDs and titles, prices, SKU, etc.); Orders (order ID, email, creation/update date, number, token, total price/weight/tax, currency, financial status, etc.);
Orders with line items (order ID, email address, token, total price/weight/tax, financial status, total discounts, total line items, status, line item’s id, line item’s title, line item’s variant ID, line item’s variant title, etc.).
In case you want to pull your summarized Order data, then choose “Orders”. Alternatively, if you need your Order’s data with all line items included, choose “Orders with line items”. Coupler.io will then create a new row for every separate line item in your order. By clicking Show advanced, you can set up additional parameters for your data source.
Once done, you should fill out the following fields:
- Filter after ID. This is where you can specify the ID of your chosen data entity (e.g. Order’s ID, Customer’s ID, or Product’s ID) to use as a starting point for your imported data set. Couplier.io will then pull all data that was created after the specified data entity ID;
- Created before/after date. This is where you can specify the timeframe for your data entity’s creation date that you want to import to Google Sheets;
- Changed before/after date. Specify the timeframe when your data entity was last changed;
- Order status. Specify the status of orders that you want to pull from Shopify. This filter applies only to the Orders data entity. The same goes for the Orders financial status, Orders fulfillment status;
- Product status. This is where you can specify the status of products to pull from Shopify. This filter applies to the Products data entity only;
- Fields. This is where you should specify all the fields you want to import to Google Sheets. The fields must be comma-separated (e.g. created_at, id). This feature is only available for Customers and Orders data entities.
3. Data Destination Setup
Safely connect your Google Account to import data to (Destination):
- Choose an account you want to connect to;
- Sign in to the chosen account;
- Check the access rights that you grant to Coupler.io and press Allow;
- Confirm your choices;
- Read the “Good job!” popup and close it.
Fill out the “Sheet name” field
Name the sheet, which will receive data. If there’s no sheet with the given name, Coupler.io will generate one for you.
You can also click Show advanced to set up extra parameters for your data destination.
Fill out the “Cell address” field
Type in the address of the first cell where you will import the data range. A1 is the default value.
4. Configure Importer’s Settings.
The final step includes four easy mini-steps to follow.
First, you should enable the Automatic data refresh and choose the frequency depending on your needs. Thus, you can set it to refresh every hour or every 3, 6, 12 hours, as well as daily, weekly, or monthly. You can find more information on Automatic data refresh here.
The next step will be choosing the data import mode (e.g. replace or append data). You can read about the mode here.
Once done, you can then add the “Last Update” column (toggle that switch) that will specify the date of the last data refresh.
That’s it! Now you can click Save to save the settings and parameters. Alternatively, you can click Save & Import to save and run the initial import immediately. In case you have any questions left, you can send an email to Couplier.io here.
Coupler.io offers 4 packages to choose from including:
- Free ($0);
- Professional ($24/month; $19/year);
- Squad ($49/month; $39/year);
- Business ($99/month; $79/year).
Every paid package includes features like unlimited users and every-hour data refresh. The number of rows is increased according to the chosen plan. Thus, the Free plan will give you 50,000 rows (i.e. a group of cells laid out horizontally in a spreadsheet) you can import per month. This can be enough for a small business team to import data from Shopify to Google Sheets for a long period of time. Plus, you don’t have to provide your bank card details when you sign up for this plan. Moreover, you can also invite other team members to join it.
As for other (paid) plans, the Professional plan will give you 500,000 rows, Squad offers 5,000,000 rows, and Business – 25,000,000 rows.
Additionally, with any paid subscription plans (both monthly and annual), you will get a free 14-day trial period to check if you like the product. You can cancel any time before the trial is over. And if you like everything, after the testing period is over, you will be charged by Coupler.io according to the chosen paid plan.
You can easily use Coupler.io to pull your Orders data from Shopify to Google Sheets on a set schedule with no coding or tech skills. Plus, you are able to sync your customer data and automate your entire order processing. Create new rows, search, and update them in Google Sheets. All you have to do is follow our guide and know what information you want to transfer from Shopify to Google Sheets. Try it for free and have no worries about your data safety!