How it works
To create Microsoft Excel 365 records from yclients without manual input, use a ready-made scenario.
- Starts when: Airtable Endpoint
- Then: Extract Airtable Data
- Then: Create Airtable Data
- Check: Check if user found
- If yes: Respond to Webhook with Customer Data
- If no: Set Error Data
- Starts when: Respond to Webhook with Error
- Check: Check if available
- If yes: Create Calendar Event
- Then: Set Calendar Success Message
- Starts when: Respond with Success
- If no: Set Calendar Error Data
- Starts when: Respond With Calendar Error data
- Check: Check for malformed date
- If yes: Check Calendar Availability
- If no: Set Invalid Data Error
- Starts when: Respond with Generic Error
- Then: Create Ticket
- Check: Check if submitted succesfully
- If yes: Ticket Created Successfully
- If no: Error Creating Ticket
- Then: Create Customer in DB
- Starts when: Gcal Endpoint
- Then: Extract Gcal Data
- Starts when: Zendesk Endpoint
- Then: Extract Zendesk Fields
- Starts when: Voiceflow Endpoint
- Then: Extract Phone Number
- Then: Query Google Sheets for Phone
You can launch this yclients + Microsoft Excel 365 integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.