Background: I have a Google Sheet, call the tab “pending deliveries” where each row contains customer details and a courier tracking code that I add in when the courier comes to pick up a delivery.
I want to use the courier API to check if the item has been delivered, then move the row to a different tab, or leave it there until it’s been delivered.
My thinking is I would like to periodically (every 4 hours or so) query every row in the “pending deliveries” google sheet tab, get the courier tracking code from the tracking code column in each row, then check via the courier API if it’s delivered, then if it’s not been delivered move onto the next row, if it has been delivered move the row to another tab in the sheet and move onto the next row.
How might I do this?
The courier doesn’t seem to offer me a hook to grab when the delivery has been made - I need to query their system periodically.