Articles on: Third-party Application

Auto Fetch by using Google Spreadsheet

Open a Google Drive Spreadsheet



Download TrackingMore Full Sample
Copy and Paste the template to Google Drive Spreadsheet
Click Share to change share settings

Note: Please DO NOT delete/add/move any columns

Google Spreadsheet

Change Access Settings



Click Get shareable link
Choose Anyone with the link can edit
Click Copy link and Done

Google spreadsheet permission

Connect with TrackingMore



Go to Trackingmore backend, click APPSGoogle Fetch CSV
Paste the link and click Review
Google auto fetch
Review

Click Import Now or the small green refresh button to sync all the orders that you fulfilled in your Google spreadsheet

Sync orders

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.

Updated on: 12/09/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!