Query, Post and Sync Data from Shopify
Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho etc.
It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.
Shopify is an e-commerce platform that helps individuals and businesses create and manage online stores easily. It provides tools for designing a store, adding products, accepting payments, managing inventory, handling shipping, and marketing. Businesses can sell physical or digital products, subscriptions, or services, and even connect their store with social media platforms. Shopify also offers a point-of-sale system for physical shops, making it a complete solution for selling both online and offline.
Choose the Shopify(Premium app) from the list and choose the service that you want to perform
If you're opening it for the first time on the sheet, then you won't be having any connections.
Don't worry Sheet director provides a way to create a connection easily
To create the connection you have to provide the following details.
Connection name - Provide a nice name for the connection you're creating
Provide the configuration details which are mandatory
Base URL: https://${storename}.myshopify.com/admin/api/2025-04
Once you have provided the credentials you can easily check the connectivity by clicking on the test connection button
Based on the credentials authenticity, you will be having the feedbacks from the test
Once after connecting successfully, you can save the connection and continue.
These connections can be reused anytime and from any services used on the same Google Sheets
Once after saving the connection successfully, you can select the table and fields that you want to present on the Google Sheets
You also have a refresh button to get the updated tables list from the database
You can limit how much no of records you want to fetch using a query
Configure the destination settings to save the records.
Switch on Run automatically to execute services automatically in the background.
Configure the Notification settings to set up the email templates and add attachments.
Click on execute to query the records in the Google Sheets.
Click save to save the service.
Select the service to Post
Choose the Source sheet where the data is located
Select the Status column
If the status column is not there, simply click the + button to add the status header on your sheet(A status column will be created in the Spreadsheet)
Select the Result column
If the result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)
You can manually map the sheet data with the Shopify fields
Click on execute to post the records into Shopify.
Click Save to save the service.
Click Execute to execute the service
After clicking on Execute you will be shown with the confirmation dialog of how many records will be posted, check that and click on "Post Now" to continue the posting
After successfully completeng the previous step you will be shown with the no successfully posted and failure records
You will also see that under the Result and the status column in the Google Sheet
Select Sync as a service
Synchronization Key
The keys will be used for matching rows in Google Sheets with data in Shopify; these keys will be your primary key. (This is identified automatically)
Conflict Resolution:
When Synchronization happens, there could be a conflict of data between Google Sheets and Shopify.
Shopify Wins
Google Sheet Wins
Shopify Wins: The latest data from Shopify will be updated in Google Sheets.
Google Sheet Wins: The latest data from Google Sheets will be updated in Shopify.
Note: The major requirement in synchronization is the synchronization keys. If any of the keys is not have a value in the Google Sheet, then the Sheet Director will create it in the Shopify
Select Shopify Wins.
The latest updated data from Shopify will be updated in Google Sheets.
Adding a new prodcut name in Shopify
Let's execute this to get the updated record from the Shopify
The number of records that are ready to be synchronized will be shown.
It will also show all the data that are ready to be updated.
Click on Sync Now to sync all the data and update it into Google Sheets.
Click on the Refresh icon to refresh the data.
Before Synchronizing
After Synchronizing
The value from Shopify is now updated on Google Sheets
Select Google Sheet Wins.
The latest updated data from Google Sheets will be updated into Microsoft SQL Server.
Let's execute this to Sync the updated record from Google Sheets
The number of records that are ready to be synchronized will be shown.
It will also show all the data that are ready to be updated.
Also, the number of data that needs to be updated into Shopify will also be updated.
No of new records found in Sheet which are not present in Shopify, that will be created in Shopify
Click on Sync Now to sync all the data and update it into Google Sheets.
Click on the Refresh icon to refresh the data.
In this sample, we will be updating a few more prodcut name from the Google Sheets
Before Synchronizing
The Status Fields are getting updated and the new row is going to be added in Shopify.
After Synchonizing