Turn Jotform registrations into calendar invites, emails, and a roster

Build a deterministic code workflow that fans out every new Jotform event or webinar registration to three downstream tools in a fixed order. No judgement, no summarization, no scoring. Every step is a known node and the field mapping is fixed.

Trigger: Jotform webhook. The webhook fires on every new submission to the registration form. The workflow reads the submission ID from the incoming payload.

Step 1. Call Jotform's Get Single Submission using the submission ID from the webhook payload. Pull the attendee's name, email, ticket type, and any session selections out of the answers.

Step 2. Call Google Sheets Append Values to add a row to the registration log spreadsheet. Columns, in order: timestamp (submission created_at), name, email, ticket type, session, source (form name or ID).

Step 3. Call Google Calendar Create Event on the configured calendar. Set the summary to the session name, start and end times to the session time, and add the attendee's email as a guest so they get an invite and a calendar hold.

Step 4. Call Gmail Send a Message to the attendee. Subject should confirm the session and ticket type. Body should include the session date, time, calendar event link from step 3, and any pre-event resources (welcome link, agenda, prep doc) defined as workflow inputs.

Configurable inputs: the Jotform form ID, the question IDs for name, email, ticket type, and session, the target Google Sheet ID and tab name, the Google Calendar ID, the session start and end times (or a mapping from session selection to time), the from address for the Gmail message, and the pre-event resource block for the email body.

Run the steps in order. If Get Single Submission fails, stop and surface the error. If Append Values, Create Event, or Send a Message fails, log the failure with the submission ID so it can be retried, but do not roll back the earlier steps.