Give your chat assistant a reliable back office. The system finds customers, logs support tickets, books meetings, and stores transcripts for product review. It suits support teams that want one place to handle requests from a voice or chat bot.

Four webhook endpoints accept data from your assistant and apps. One route checks a phone number against Google Sheets, then sends back customer details or a clear not found flag. Another route creates or updates a user in Zendesk and opens a ticket, then returns success or error. The calendar path validates dates, checks Google Calendar availability, creates an event, and replies with a success message. A separate path saves transcripts to Airtable for the product team.

Setup needs Google and Zendesk credentials and an Airtable token. Teams reduce manual work by removing double entry and handoffs between tools. Ticket creation drops from minutes to seconds and bookings are confirmed in one pass. Use this when a bot needs to verify customers, open tickets, schedule calls, and share transcripts without switching tabs.

• Webhook endpoints for Voiceflow, Zendesk, Google Calendar, and Airtable to accept requests from external apps
• Google Sheets phone lookup to find and return customer records
• Conditional path returns customer data or a clear not found response
• Zendesk user create or update followed by ticket creation with subject and comment
• Date validation catches malformed dates before scheduling begins
• Google Calendar availability check and event creation with success message
• Structured error handling that replies with helpful messages for each route
• Airtable record creation to store transcripts for product analysis

• Reduce manual ticket work from 5 minutes to under 30 seconds
• Automate 80 percent of booking steps by checking availability and creating calendar events
• Improve data accuracy by validating dates and required fields before actions run
• Connect five systems in one place to remove tab switching
• Capture and store transcripts for product review with no extra steps
• Handle high request volume from bots with consistent responses

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Voiceflow, Zendesk, Google Calendar, Google Sheets and Airtable. See the Tools Required section above for links to create accounts with these services.
3. Open the Google Sheets node and create credentials: double click the node, choose Create new credential, then follow the on screen steps to connect your Google account. Pick a sheet that holds phone numbers and customer details.
4. Open the Google Calendar nodes and create credentials the same way. Approve calendar scopes so the workflow can read availability and create events.
5. Open the Zendesk HTTP Request nodes and set credentials: double click, choose Create new credential, then follow the steps to connect your Zendesk subdomain with an API token or OAuth. Use a service account that can manage users and tickets.
6. Open the Airtable node and create a Personal Access Token in your Airtable account. In n8n, create a new Airtable credential and paste the token. Select the base and table for transcripts.
7. For each credentialed node, select the new credential in the Credential to connect with dropdown and save.
8. Copy the Production URL from each webhook node: Voiceflow Endpoint, Zendesk Endpoint, Gcal Endpoint, and Airtable Endpoint. In Voiceflow, add HTTP request steps that post the required JSON fields to these URLs.
9. Map fields in the Set nodes: ensure the phone value is passed to Extract Phone Number, ticket subject and body go to Extract Zendesk Fields, date and time fields go to Extract Gcal Data, and transcript fields go to Extract Airtable Data.
10. In Google Calendar nodes, choose the correct calendar ID and timezone. Send test dates in ISO format like 2025-09-01T10:00:00Z to avoid invalid date errors.
11. Test each route with Postman or curl. Verify user lookup returns the right data, Zendesk shows a new or updated user and a ticket, Google Calendar shows the event, and Airtable receives a new record.
12. If you get permission errors, check OAuth scopes, API tokens, and selected calendars. If dates are rejected, review the date format. If lookup fails, confirm sheet column names and the phone normalization rules.