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?


  1. Go to TrackingMore Integration navigation
    Integration


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


  1. Setting
    Setting


  1. 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


  1. 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:
  • 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/
  • 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!