I need a Zapier flow that pulls each new Google Forms submission from my existing Sheet, feeds the data to OpenAI and instantly sends a personalised email back to the sender. The very first priority is getting those replies out automatically; calendar creation and other follow-ups can come right after we prove the core loop works. Here is what the reply must contain every time: • Order confirmation details drawn from the spreadsheet entry • Available appointment slots plus a link to book (Google Calendar / Google Meet) • A short line with our customer-support phone and the help page on dothanmassageschool.com Rather than canned templates, I want the wording generated dynamically by GPT so each message sounds human and matches the information the client gave us. Feel free to add guardrails or system prompts to keep tone consistent and on-brand. Technical expectations – Trigger: new row in Google Sheets. – Action 1: format the data for OpenAI (model choice is up to you, GPT-4 is preferred if we hit token limits). – Action 2: send the composed email through Gmail. – Logging: write the full outbound message back to the sheet for auditing. Once that pipeline is live and stable, I will extend the same architecture to automatically set calendar events and have GPT handle follow-up questions, so please build with modular steps in Zapier. Deliverable: a working Zap, documented with screenshots or a brief Loom walkthrough, plus the final system prompt you used so I can fine-tune it later.