Articles on: TrackingMore App on Shopify

Sync order status to Google Sheets automatically

How to sync order status to Google Sheets automatically from TrackingMore Shopify App?

Go to TrackingMore Integration navigation
Integration

Search "google sheets" or choose category > data to find Google Sheets App
Search "google sheets"
Or
Or choose ategory > data to find "google sheets"

Setting
Setting

Input Google sheet link & connect
Please make sure your Google Sheet shared to us service-account-sheet@tmshopify.iam.gserviceaccount.com with Editor access.
Input Google sheet link & connect

Export by changing time zone or by creating new view page
Change time zone & choose view to export
Export all, shipping statuses or new view page


Tips:
1. You can export any view that exists on Orders > Shipments page & create a new view by customizing your filter conditions and saving it as a view. Here is the guidance on creating a new view: https://support.trackingmore.com/en/article/how-to-filter-your-shipments-or-orders-save-it-on-trackingmore-shopify-app-ixhlej/
2. This sheet will be updated every day at 6:00 am in your timezone & you can change the timezone in settings > sync order
change timezone

Note: "Connect Google Sheets" is only available in Pro & higher plans. If you are under below Pro plan, you can upgrade your plan by choosing "upgrade" on the right top or going to settings > plan > change plan
change plan

Updated on: 25/09/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!