GOOGLE SHEET TO GET COURIER TRACKING STATUS
Budget: ₹1,500 – ₹12,500 INR
pickrr.com/
Test credentials
User id –
Pass- aaa@123
Auth token - e2495ab1f1aa403c0fcb12e9e7fffed9135608
I WANT THIRD PARTY API INTIGRATION IN GOOGLE SHEET
THE GOOGLE SHEET WILL CONTAIN 4 COLOUMS LIST OF TRACIG ID / AWB NUMBERS FOR COURIER/LOGISTIC SERVICE FOR TRACKING PURCHASE
USING PICKRR API (https://docs.pickrr.com/) YOU HAVE TO CREATE A APP SCRIPT OR GOOGLE APP SCRIPT FUNCTION THAT TRACKS UNDELIVERED / IN PROCESS SHIPPENTS THAT ARE DELAYED FROM THE PROMISED DATE.
THE LIST OF AWBS WILL BE UPDATED EVERY DAY AT RANDOM TIME
THE CUSTOM APP SCRIPT SHOULD RUN EVERY DAY AT ON A SCDDULE TIME AND ANALYIS THE UNDELIVERED / IN PROCESS SHIPPENTS THAT ARE RUNNING LATE / DEALYED FROM THE PROMISED DATE AND TRIGGER A GIVEN WEBHOOK
GOOGLE SHEET SMAPLE LINK
https://docs.google.com/spreadsheets/d/1UP_gn_6ovslSGHfjHFrum5zf5CBKVUzUfsr4KhTG5ss/edit?usp=sharing
TO SUMMARIES WITH RESPECT TO GOOGLE SHEET
- THERE ARE 4 COLOUMS THAT UPDATE EVERY DAY
- EACH COLOUM MAY OR MAY NOT AHVE UNIQUE TRACKING ID
- THE 4 COLUMNS SHOULD BE CONSOLITED INTO A SINGLE COLUMN INTO THE RESULT TABLE
- THE RESULT TABLE CONTACINS
- SNO
- TRACKING NUMBER
- JSON OBJECT FROM API
- CURRENT STATUS
- PROMISED DATE
- IS THE PARCEL LATE
- THE GOOGLE APP SCRIPT HAVE API USAGE LIMITS AND I HAVE OTHER APP BUILT AROUND APPP SCRIPT
- THE CODE SHOULD MINIZE THE API CALLS SMARTLY
- EXAMPLE - NOT MAKE API CALLS FOR ALREADY DELIVERED PARCEL
- DELIVERED PARCELS WOULD HAVE BEEN DISCOVRED IN THE PREVIOUS DAYS API LOOKUPS
- THE APP WOULD RUN AUTOMATICALLY IN A CONFIGURABLE SCHDULE
- THE APP WILL DERIVE CONFIRATION FROM THE "CONTANTS" SHEETS
- THE CONTANTS WILL HAVE A TABLE CALL CONFIURATION
THAT GIVE SCHDULE TIME
OTHER DATA
- THE GOOGLE SHEET WHERE DATA GET POPULATED MAY NOT BE EVEN OPEND FOR MONTHS BUT THE WORK N API CALL SHOULD GO ON AS USUAL DAILY
- ON DETECTED A DELAYED SHIPMENT A WEBHOOK NEEDS TO BE TRIGGERD - CAN BE FOUND IN CONFIG TABLE
- WE ALSO HAVE TO DETET PARCEL THAT ARE STUCK IN 1 PLACE WITHIN THE PROMISED DATE
-
Test credentials
User id –
Pass- aaa@123
Auth token - e2495ab1f1aa403c0fcb12e9e7fffed9135608
I WANT THIRD PARTY API INTIGRATION IN GOOGLE SHEET
THE GOOGLE SHEET WILL CONTAIN 4 COLOUMS LIST OF TRACIG ID / AWB NUMBERS FOR COURIER/LOGISTIC SERVICE FOR TRACKING PURCHASE
USING PICKRR API (https://docs.pickrr.com/) YOU HAVE TO CREATE A APP SCRIPT OR GOOGLE APP SCRIPT FUNCTION THAT TRACKS UNDELIVERED / IN PROCESS SHIPPENTS THAT ARE DELAYED FROM THE PROMISED DATE.
THE LIST OF AWBS WILL BE UPDATED EVERY DAY AT RANDOM TIME
THE CUSTOM APP SCRIPT SHOULD RUN EVERY DAY AT ON A SCDDULE TIME AND ANALYIS THE UNDELIVERED / IN PROCESS SHIPPENTS THAT ARE RUNNING LATE / DEALYED FROM THE PROMISED DATE AND TRIGGER A GIVEN WEBHOOK
GOOGLE SHEET SMAPLE LINK
https://docs.google.com/spreadsheets/d/1UP_gn_6ovslSGHfjHFrum5zf5CBKVUzUfsr4KhTG5ss/edit?usp=sharing
TO SUMMARIES WITH RESPECT TO GOOGLE SHEET
- THERE ARE 4 COLOUMS THAT UPDATE EVERY DAY
- EACH COLOUM MAY OR MAY NOT AHVE UNIQUE TRACKING ID
- THE 4 COLUMNS SHOULD BE CONSOLITED INTO A SINGLE COLUMN INTO THE RESULT TABLE
- THE RESULT TABLE CONTACINS
- SNO
- TRACKING NUMBER
- JSON OBJECT FROM API
- CURRENT STATUS
- PROMISED DATE
- IS THE PARCEL LATE
- THE GOOGLE APP SCRIPT HAVE API USAGE LIMITS AND I HAVE OTHER APP BUILT AROUND APPP SCRIPT
- THE CODE SHOULD MINIZE THE API CALLS SMARTLY
- EXAMPLE - NOT MAKE API CALLS FOR ALREADY DELIVERED PARCEL
- DELIVERED PARCELS WOULD HAVE BEEN DISCOVRED IN THE PREVIOUS DAYS API LOOKUPS
- THE APP WOULD RUN AUTOMATICALLY IN A CONFIGURABLE SCHDULE
- THE APP WILL DERIVE CONFIRATION FROM THE "CONTANTS" SHEETS
- THE CONTANTS WILL HAVE A TABLE CALL CONFIURATION
THAT GIVE SCHDULE TIME
OTHER DATA
- THE GOOGLE SHEET WHERE DATA GET POPULATED MAY NOT BE EVEN OPEND FOR MONTHS BUT THE WORK N API CALL SHOULD GO ON AS USUAL DAILY
- ON DETECTED A DELAYED SHIPMENT A WEBHOOK NEEDS TO BE TRIGGERD - CAN BE FOUND IN CONFIG TABLE
- WE ALSO HAVE TO DETET PARCEL THAT ARE STUCK IN 1 PLACE WITHIN THE PROMISED DATE
-