Get next week's office event groceries ready to order

Every Thursday at 9am, look ahead at next week's team events and have the office grocery order ready before anyone has to think about it. Run this on a cron trigger at 9:00am every Thursday in the office time zone. Thursday timing is deliberate, it leaves lead time to get an order placed before the following week starts.

Start with the Google Calendar List Events action against the shared office calendar. Pull every event from the coming Monday through Friday. Expand recurring events into individual instances so each occurrence is judged on its own, and include attendee details so headcount is available.

Decide which events actually need food by reading the title, description and attendee count. All-hands meetings, client lunches, onboarding days and team offsites are in scope. Regular 1:1s, external video calls, personal holds and focus time blocks are skipped. Use judgement on anything ambiguous, leaning on what the title and description say about whether people will be in the office together around a meal.

For each qualifying event, build a shoppable list with the Instacart Create Shopping List Page action. Size quantities to the confirmed attendee count, meaning people who have accepted rather than everyone invited. Cover a spread that works for common dietary needs, including vegetarian, gluten free and non-dairy options. Line items use line_item_measurements and only the supported units: each, lb, oz, g, kg, ml, L, cup, tbsp, tsp, gallon. Apply health filters such as VEGAN, GLUTEN_FREE and ORGANIC where they help match the right products. Set expires_in to roughly 14 days so each link stays live comfortably through the week it covers, and name each list after the event it belongs to.

Post the results to the office operations channel using the Slack Bot Send a Message action, with one block per event showing the event name, the date, the headcount and its one-click Instacart link. The office manager reviews the blocks and places the order. Do not try to purchase anything: the Instacart Developer Platform can only create a shareable list page, never place an order, and the human approval step is the point of the workflow.

Call out any event that has no attendee count set on its own clearly marked line, so someone can confirm numbers before ordering rather than guessing. If nothing next week needs food, post a short note saying the week looks clear instead of staying silent.