Skip to content

Vendor Deadline Tracker

Example prompt: "Every weekday morning, check our vendor tracker in Airtable for any deadlines in the next 14 days. If a deposit or confirmation is still outstanding, message the responsible team member on Slack with the vendor name, what's due, and when. Post a weekly summary to #event-ops every Monday."

The Problem

Events involve dozens of vendors — caterers, AV companies, florists, rental firms, photographers — each with their own deposit deadlines, final confirmation dates, and delivery milestones. Coordinators track these in spreadsheets, but it is remarkably easy to miss a deposit deadline and lose a booking, or forget to confirm final headcounts by the catering cutoff. A single missed vendor deadline can cascade into serious problems on the day of the event.

How GloriaMundo Solves It

We build a scheduled workflow that runs each weekday morning. An integration step reads your vendor contract tracker from Airtable, pulling all deadlines within the next 14 days. A code step identifies which deadlines have outstanding actions — deposits not yet paid, confirmations not yet sent, deliveries not yet scheduled. For each one, an LLM step drafts a clear, actionable reminder. Integration steps send these to the responsible team member via Slack, tagging them directly. On Mondays, an additional LLM step generates a weekly summary of all vendor statuses — on track, at risk, or overdue — and posts it to a shared channel. Glass Box preview lets you review every message and the weekly summary before they go out.

Example Workflow Steps

  1. Trigger (scheduled): Runs every weekday at 8:30am.
  2. Step 1 (integration): Read vendor contract tracker from Airtable, filtering for deadlines within the next 14 days.
  3. Step 2 (code): Identify outstanding actions — unpaid deposits, unconfirmed headcounts, unscheduled deliveries — and calculate days remaining.
  4. Step 3 (LLM): Draft a concise reminder for each outstanding item, including vendor name, deadline date, and required action.
  5. Step 4 (integration): Send each reminder to the assigned team member via Slack direct message.
  6. Step 5 (conditional): If today is Monday, proceed to the weekly summary step.
  7. Step 6 (LLM): Generate a weekly vendor status summary grouped by status (on track / at risk / overdue).
  8. Step 7 (integration): Post the weekly summary to #event-ops on Slack.

Integrations Used

  • Airtable — vendor contract tracker with deadlines, payment status, and assigned team members
  • Slack — individual reminders and weekly summary posts

Who This Is For

Event coordinators and operations managers running events with 10 or more vendors, where a single missed deadline could mean losing a booking or facing day-of surprises.

Time & Cost Saved

Manually reviewing vendor contracts and chasing team members for updates takes roughly 2-3 hours per week for a mid-sized event. This workflow replaces that with automated daily checks and a weekly digest, reducing the effort to reviewing the Glass Box preview — about 10 minutes per day. The combination of integration, code, LLM, and conditional steps costs a moderate number of credits per run.