Integrating 17Track with Google Sheets using Google Apps Script

Description

17Track (https://www.17track.net/en) is a package tracking platform.

API docs: https://api.17track.net/en/doc

What we'd like to build:

1. Refer to this Google Sheets: https://docs.google.com/spreadsheets/d/xxx/edit#gid=0

2. Column A - D is filled manually. Input data: "client", "store", "tracking_number", "tracking_url"

3. Column E - K is filled automatically. Data: "created_at", "status", "first_updated_at", "last_updated_at", "days_in_processing", "days_in_transit", "days_since_last_update"

-- "status" : should be sync real-time with 17Track

-- "last_updated_at" : show the last update time from 17Track

-- "days_in_processing" : the duration 17Track shows 'processing' status, instead of 'in_transport'

-- "days_in_transport" : the duration 17Track shows from status 'in_transport' to 'delivered'

-- "days_since_last_update" : the duration when there is not any update at all, so that we could know whenever a transport is lost

Please let me know that you have read the job description carefully by writing cold brew coffee in your cover letter. And, it will be a plus point if you could also briefly describe the way you solve this problem.

Works with Apps

Google Sheets

From Ashton

In this project, we leverage Google Apps Script to seamlessly integrate the 17Track API with Google Sheets, enabling us to effectively track package transportation data. This integration serves as a prime example of how Google Apps Script can be utilized to collaborate with third-party APIs.

Hire Me on Upwork

From Client

Truly professional and get the job done perfectly in a timely manner!

Google Apps Script Projects Shared On YouTube

Links

Work with Me on Upwork YouTube Twitter / X Automate The Boring (Blog)