Auto Fetch by using Google Spreadsheet
Open a Google Drive Spreadsheet
Download TrackingMore Full Sample V2
Copy and Paste the template to Google Drive Spreadsheet
Click Share to change share settings
Note: Please DO NOT delete/add/move any columns
Change Access Settings
Click Get shareable link
Choose Anyone with the link can edit
Click Copy link and Done
Connect with TrackingMore
Go to Trackingmore backend, click APPS → Add Apps → Google Fetch CSV
Paste the link, choose sync time, fill in store name and click Install App
Click Import Now or the small green refresh button to sync all the orders that you fulfilled in your Google spreadsheet
1. Each Google Sheet only supports up to 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 unlimited Google Sheets binded.
2. Auto sync time is 00:00 (GMT+0) and you can also customize your own sync time at max 3 different sync times per Google Spreadsheet.
3. Feed URL & Sync time is required, while store name is optional.
Updated on: 01/11/2023
Thank you!