Skip to main content

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.

@atomicnick - Sure thing! Come back anytime you need more help.


Hey Andrew. Been on the backburner of todos. I also see Zapier has a repeatable workflow option in beta too. Will get round to it soon, and this page is bookmarked :)


@atomicnick 
Just checking in to see if you still need help with this? 


Here’s how to create a looping Zap that may be applicable to your use case with GSheets: