> ## 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).

# Auto Fetch by using Google Spreadsheet

# Open a Google Drive Spreadsheet
1. Download TrackingMore [Full Sample V2](https://download.trackingmore.com/excel/sample-full-v2.csv?_gl=1*1serbp*_ga*OTEzNDkyNTk0LjE2OTAxODU0NTI.*_ga_5MX5LDQREB*MTY5ODgwNTg2Mi4zNTIuMS4xNjk4ODA1OTAxLjIxLjAuMA..)
2. Copy and Paste the template to Google Drive Spreadsheet 
3. Click **Share** to change share settings

||| **Note**: Please ${color}[#ed0707](**DO NOT**) delete/add/move any columns 
![Share google spreadsheet](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/0f34712966678a0eaab0f981cb4e4a_bqnp6e.png)

# Change Access Settings
1. Click **Get shareable link**
2. Choose Anyone with the link **can edit**
3. Click **Copy link** and **Done**
![Google spreadsheet permission](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_1lhmxiu.png)

# Connect with TrackingMore
1. Go to Trackingmore backend, click **APPS** → **Add Apps** → **Google Fetch CSV**
2. Paste the link, choose sync time, fill in store name and click **Install App**
![Google auto fetch](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_183iqat.png)
![Paste the link, choose sync time, fill in store name ](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_6hi8iv.png)
![Install App](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_3633lj.png)
3. Click **Import Now** or the small green refresh button to sync all the orders that you fulfilled in your Google spreadsheet
![Sync orders](https://storage.crisp.chat/users/helpdesk/website/e0174a0b5e49b000/image_1qk2vwt.png)


| 1. Each Google Sheet only supports up to ${color}[#fb0909](**10,000**) shipments and you'll need to bind different Google Sheets if you have more than 10,000 shipments to import once. And it supports ${color}[#f20202](**unlimited**) Google Sheets binded. 
| 2. Auto sync time is **00:00 (GMT+0) **and you can also customize your own sync time at ${color}[#f50a0a](**max 3**) different sync times per Google Spreadsheet.
| 3. **Feed URL** & **Sync time** is ${color}[#ec0909](**required**), while **store name** is ${color}[#9cc20f](optional).