Back to work
MakeCase study

Equipment Sync: Paint Booth & Lift Scheduling

Scheduling workflow that watches Trello cards moved to a Ready‑for‑Paint list, parses custom‑field dates, creates a Google Calendar paint‑booth block, writes the event ID back to the card, and marks it as scheduled, with error comments on the same card if booking fails.

Make · workflow canvasproduction build
Equipment Sync: Paint Booth & Lift Scheduling workflow

Context

Operations teams managing paint‑booth usage needed to avoid double‑booking while manually reading Trello cards, calculating dates, and updating calendars, which slowed down scheduling and increased conflicts.

Approach

Built a single Make.com scenario that triggers when a card is moved into the Ready‑for‑Paint list, retrieves and parses custom‑field scheduling data, resolves an end date (or defaults to +3 days), creates a paint‑booth block in Google Calendar, stores the event ID on the Trello card, applies a scheduled label, and adds a confirmation comment; if scheduling fails, an error comment is added instead.

Architecture

  1. Watch for Cards Moved to Ready for Paint (Trello)
  2. Set Card and List ID
  3. Get Card Data
  4. Extract Custom Fields
  5. Parse Custom Field Values
  6. Parse End Date or Default +3 Days
  7. Build Calendar Event Title and Description
  8. Create Paint Booth Block (Google Calendar)
  9. Store Calendar Event ID in Custom Field
  10. Apply Booth Scheduled Label
  11. Add Scheduling Confirmation Comment
  1. On failure
  2. Add Scheduling Error Comment

Results

~3 hrs/weekScheduling time saved
EliminatedBooking conflicts
100% (linked to card)Event traceability