Airtable Automation Script Integration

**Overview** I need a short Airtable scripting automation built to receive a Typeform webhook payload and map collision fields into a unified Airtable Leads table. **Background** I have a multi-persona Typeform survey (8 audience segments) where the same logical question (e.g. Use Cases, Markets, Risks) appears under different question IDs depending on which branch the respondent takes. The native Typeform → Airtable connector cannot resolve these collisions. The script handles this. **What's needed** - Airtable Automation triggered by incoming Typeform webhook - Script parses raw JSON payload - Coalesces persona-specific question IDs into canonical Airtable fields - Searches for existing record by Typeform Response ID before writing - Updates existing record if found; creates new record if not - Handles multi-select (choices), single-select (choice), and free-text field types **Collision fields to resolve (10 fields, ~80 question ID variants)** Use Cases, Use Cases (Other), Markets, Markets (Other), Risks/Concerns, Current Registration Process, SMS Providers, Compliance Opex Burden, International Markets Count, Pilot Interest **Deliverables** - Working Airtable script with inline comments - Tested against at least one live Typeform submission per persona branch - Brief handover note explaining any field name dependencies