Turn Airtable booking requests into calendar invites and confirmations

Build a deterministic code workflow (no LLM needed) that turns Airtable booking requests into real calendar invites, sends a confirmation email to the guest, and logs each booking to a Google Sheet.

Trigger: poll Airtable for New Record on my "Booking Requests" table. The table has these columns: guest_email, guest_name, requested_start_iso (an ISO 8601 timestamp with timezone), duration_minutes (integer), and topic (short text).

For each new record, run these steps in order:

1. Call Nylas Create Event on my default calendar. Use a timespan when object built from requested_start_iso and requested_start_iso + duration_minutes (converted to epoch seconds). Set the title to the topic value, add the guest as a participant using guest_email and guest_name, enable conferencing (autocreate), and pass notify_participants=true so Nylas sends the calendar invite to the guest automatically.

2. Read the conferencing join link from the created event response (conferencing.details.url or the equivalent field for the provider) so we can include it in the confirmation email.

3. Call Nylas Send Message to send a plain-language confirmation email to guest_email. Subject should be something like "Confirmed: {topic} on {formatted date/time}". The body should thank them, restate the topic, show the meeting time formatted in the timezone from requested_start_iso, include the conferencing join link from step 2, and sign off warmly. Plain text is fine, no fancy HTML.

4. Call Google Sheets Append Values on my "Booking Audit Log" sheet to append one row with these columns in order: guest_email, event_id (from the Nylas event), scheduled_time (the ISO start time), created_at (the current ISO timestamp when this run executed). Use USER_ENTERED so timestamps parse as dates.

Error handling: if Create Event fails, do not send the confirmation email or write the audit row. If Send Message fails after the event is created, still write the audit row so we know the booking exists. Keep the whole workflow idempotent by using the Airtable record ID as an idempotency key on the Nylas event create.

Configuration to expose to the user: the Airtable base + table for the trigger, the Nylas grant (calendar/email account), and the Google Sheets spreadsheet ID + sheet name for the audit log. Do not add any AI or LLM steps. This is a straight pipeline.