Back to work
MakeCase study

Interview Calendar Sync

Scheduling workflow that watches form responses, normalizes date/time, looks up the matching record, constructs a response URL, and creates a Google Calendar interview event with HR alerting if the event creation fails.

Make · workflow canvasproduction build
Interview Calendar Sync workflow

Context

Interview coordinators had to manually convert form times, look up submissions, and create calendar events, creating delays and a risk of inaccurate or missed appointments.

Approach

Built a single Make.com scenario that watches form responses, parses and enriches datetime data, retrieves the matching response record, builds a response URL, and creates the interview in Google Calendar, with dedicated error paths that email HR if the form or calendar step fails.

Architecture

  1. Watch Form Responses trigger
  2. Parse DateTime
  3. Calculate End DateTime
  4. Format Timestamp
  5. Get Form Response Data
  6. Build Response Row URL
  7. Create Interview Calendar Event
  8. If failed: Handle Calendar Error
  9. Send Alert to HR (Email)
  1. Handle Form Error
  2. Email path

Results

~3 hrs/weekScheduling time saved
EliminatedBooking errors
Reduced ~95%Time-zone/format mistakes