CSV Auto Fetch using Google Drive Spreadsheet
You can automatically import tracking numbers to AfterShip using Google Drive Spreadsheet via CSV Auto - Fetch. Google doc allows you to invite other users (e.g. fulfilment house or drop shippers) to work on the same CSV file.
In order for our system to download the CSV file, you need to follow this guide to generate a download link for the CSV file of Google Drive Spreadsheet.
1. Open a Google Drive Spreadsheet
2. Change Access Settings
Change... to change access settings.
Anyone with the link.
3. Publish to the web...
File at the top navigation.
Publish to the web....
c. Make sure the option
Automatically republish when changes are made is checked.
Document Link to
CSV File Link.
4. Setup CSV Auto-Fetch at AfterShip
CSV file link to AfterShip - CSV Auto-Fetch settings.
Fetch now and schedule.
c. If successfully connected, you should be able to see a green sign of the connection.