> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.trackingmore.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_15aqjqp.png)

2. Search "google sheets" or choose category > data to find Google Sheets App
![Search "google sheets"](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_18d8jgo.png)
Or
![Or choose ategory > data to find "google sheets"](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_6e36nu.png)

4. Setting 
![Setting](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_1kq84yl.png)

5. Input Google sheet link & connect
| Please make sure your Google Sheet shared to us **service-account-sheet@tmshopify.iam.gserviceaccount.com** with ${color}[#e00606](**Editor**) access. 
![Input Google sheet link & connect](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_1cf0qj6.png)

6. Export by changing time zone or by creating new view page
![Change time zone & choose view to export](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_qsg2up.png)
![Export all, shipping statuses or new view page](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_1hodyf3.png)


| 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 ${color}[#fb1313](6:00 am) in your timezone & you can change the timezone in ${color}[#208f0a](settings > sync order )
![change timezone](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_4j6uik.png)

||| 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](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_1opwqw4.png)