Turn a Google Sheets row into a Google Calendar event with a Gmail confirmation

Build me a deterministic code workflow that turns each new row in a Google Sheets spreadsheet into a real Google Calendar event and a Gmail confirmation to every attendee. This is a fixed pipeline with one trigger and two actions, no agent reasoning.

Trigger: Google Sheets new_row poll on the configured spreadsheet and tab (call the tab Scheduled Events). The row has these fixed columns in this order: Title, Description, Start (ISO 8601), End (ISO 8601), Attendees (comma-separated emails), and Location.

Step 1, Google Calendar Create Event on the primary calendar. Map the columns directly into the event payload: Title to summary, Description to description, Start to start.dateTime, End to end.dateTime, Location to location, and split the Attendees column on commas into the attendees array of email objects. Set sendUpdates to all so Google Calendar sends its standard invitations to every attendee. Capture the created event's htmlLink and id for the next step.

Step 2, Gmail Send a Message. Send one plain-text confirmation email to the same comma-separated attendee list (To header). Subject should be: Confirmed: {Title} on {Start}. Body should restate the title, the start and end times, the location, and include the htmlLink from the calendar event so recipients can jump straight to it. Use the connected Gmail account as the From address.

Keep the graph simple: trigger to Create Event to Send a Message, with the event id and htmlLink threaded from step 1 into step 2. No branching, no LLM calls, no retries beyond the platform default. Run it as code, not an agent.