Automation | Displaying status of the NP package
Task: Create a display of the status of Nova Poshta parcels in a separate column in Google Sheets.
Implementation: Using the Nova Poshta API key, a script was developed that iterates through each tracking number (TN) in the column (conditionally N) and adds the status of the parcel for that tracking number in the same row of the adjacent column (conditionally I).
Also, for the convenience of running the script, a custom button "Update TN Data" was added to the Google Sheets menu.
The implementation took only 10 minutes.
Do you want to automate your business processes?
- I am waiting for you in my DMs to discuss your project!
Implementation: Using the Nova Poshta API key, a script was developed that iterates through each tracking number (TN) in the column (conditionally N) and adds the status of the parcel for that tracking number in the same row of the adjacent column (conditionally I).
Also, for the convenience of running the script, a custom button "Update TN Data" was added to the Google Sheets menu.
The implementation took only 10 minutes.
Do you want to automate your business processes?
- I am waiting for you in my DMs to discuss your project!