Daily eBay morning order briefing to Slack and Sheets

Every weekday at 8am, give me a morning eBay order briefing so I start the day knowing what sold overnight and exactly what needs to ship today.

First, pull my recent eBay orders with Get Orders, filtering for orders that were created or last modified in the last 24 hours. Include each order's fulfillment status so you can tell what has already shipped from what is still awaiting shipment, along with the order total, buyer, line items, and ship-by (handling time) date.

Then read through the orders and write a clear briefing. Report how many new orders came in and the total revenue across them, then list which orders are still awaiting shipment. Group everything by fulfillment status so I can see at a glance what needs to ship today. Call out anything urgent or unusual: flag any order that is past its handling time or ship-by date, and highlight any order that is unusually high in value compared with the rest of the batch.

Post the formatted briefing to my Slack channel using Send a Message. Put the headline numbers, new order count and total revenue, at the top, then show the status groups as separate sections using Slack formatting so they are easy to scan, with the awaiting-shipment orders listed under their own heading and the flagged and high-value orders clearly marked.

Finally, log every order from this run as a new row in my Google Sheets sales ledger using Append Values, so I keep a running record over time. Each row should capture the order id, buyer, items, order total, ship-by date, and current status. Append below the existing rows rather than overwriting, so the ledger keeps growing day after day.

If no orders were created or updated in the last 24 hours, still post a short Slack note letting me know there were no new orders overnight, and skip the Google Sheets step for that run.