Spreadsheet order to shipping label in EasyPost
The ops team adds an order row. This flow verifies the address in EasyPost, buys the cheapest label and writes the tracking number back to the row.
The prompt
When the ops team adds a new order row to our order sheet in Google Sheets, set up the parcel in EasyPost from the weight and dimensions in the row, then save the ship-to address and verify it. If the address fails verification, mark the row Address failed verification and stop. If it passes, get rates from our warehouse address, buy the cheapest label, and write the status, carrier, postage, tracking number and label link back to the row.
FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.
The flow
Download the file, then in FlowRunner click + beside Flows, pick it under Import a Flow Version and click Create. How importing works
What each step does
- New order in the sheet Checks the order sheet in Google Sheets every 5 minutes and starts once for each new row.
- Set up the parcel Creates the parcel in EasyPost from the weight and dimensions in the row.
- Verify the address Saves the customer's address from the row in EasyPost and asks whether it can be delivered to.
- Address deliverable? A deliverable address goes on to rating. When the check fails or EasyPost rejects the address outright, the row's status is set to Address failed verification, so someone can correct it before a label is bought.
- Get rates Creates the shipment from your warehouse address to the verified address and gets rates from the carriers on your EasyPost account.
- Buy the label Buys the label at the lowest rate and gets back the tracking number and the label file.
- Write the tracking number to the row Writes the status, carrier and service, postage, tracking number and label link into the order's row, so the team sees every label in the sheet they already use.
Before you turn it on
- Connect your Google account and enter your EasyPost API key.
- Save your warehouse address in EasyPost and put its ID, which starts with adr_, in the flow setting Ship-from address ID.
- Pick your order spreadsheet and tab in the three Google Sheets steps. The flow reads the columns Name, Street, Street 2, City, State, ZIP, Country, Weight in ounces, and Length, Width and Height in inches. It writes Status, Carrier, Postage, Tracking and Label.