Workflow that captures Google Forms seminar registrations, validates required contact data, logs leads to a master Google Sheet, and creates a high‑priority Trello fulfillment card with a red label, while emailing the team if either the Sheets or Trello step fails.
Make · workflow canvasproduction build
Context
Seminar teams were manually logging sign‑ups, creating follow‑up tasks, and prioritizing them, which slowed down post‑event fulfillment and risked missing registrations during busy periods.
Approach
Built a single Make.com scenario that watches Google Forms registrations, validates required contact fields, writes the lead to a master tracking sheet, creates a Trello fulfillment card, moves it to the top of the board, and applies a red high‑priority label, with separate email error handlers for Google Sheets and Trello steps.
Architecture
Google Forms trigger
Validate required contact data
Log Lead to Master Google Sheet
Create Fulfillment Card in Trello
Move Card to TOP (High Priority)
Apply Red Label (High Priority)
Error Handler - Google Sheets
Email if logging fails
Error Handler - Trello
Email if card creation/update fails
Results
~2 hrs/weekLead logging time saved
Instant, down from end-of-day batchFulfillment card creation
