Automate Customer Support with n8n and Zendesk Integration

What This Workflow Does

This workflow automates customer support tasks by connecting Voiceflow, Google Sheets, Zendesk, Google Calendar, and Airtable.

It uses a phone number from an AI agent to find customer info in Google Sheets.

If the customer exists, it sends details back to Voiceflow.

If not found, the workflow creates or updates user info in Zendesk, makes a support ticket, schedules meetings, and stores call transcripts in Airtable.

This saves about 3 hours daily, reduces mistakes, and speeds up customer service.

Who Should Use This Workflow

Customer support managers or teams needing faster and error-free customer handling should use this workflow.

It is ideal for companies managing data across multiple tools and wanting to reduce manual work.

Tools and Services Used

• Voiceflow: AI agent sending phone numbers via webhooks.
• Google Sheets: Stores customer database for lookup.
• Zendesk: Manages customer profiles and support tickets.
• Google Calendar: Checks availability and books meetings.
• Airtable: Records call transcripts and summaries.
• n8n: Automates and connects all these services.

Inputs, Processing, and Outputs

Inputs

• Phone number from Voiceflow Webhook node.
• Meeting request data including date, name, email.
• Call transcript data with summary and customer type.

Processing Steps

• Normalize phone number to remove extra characters.
• Query Google Sheets for matching customer record.
• Decide if customer exists or not using an If node.
• For new customers, create/update Zendesk user and make tickets.
• Check Google Calendar availability before scheduling meetings.
• Store transcripts in Airtable for analysis.

Outputs

• Customer details sent to Voiceflow or error messages if not found.
• Zendesk tickets created for new issues.
• Google Calendar events booked with status messages returned.
• Call transcripts safely saved in Airtable tables.

Beginner Step-by-Step: How to Use This Workflow in n8n

Step 1: Import Workflow

1. Download the workflow from this page using the Download button.
2. Open your n8n editor.
3. Use “Import from File” option to load the downloaded workflow.

Step 2: Configure Credentials and Settings

1. Go to Credentials in n8n and add API Keys for Google Sheets, Zendesk, Google Calendar, and Airtable.
2. Update spreadsheet IDs, sheet names, calendar IDs, Airtable base and table names if required.
3. Check and update any email addresses or user IDs needed by the workflow.

Step 3: Test Workflow

1. Send test data to the Voiceflow webhook URL to verify customer lookup works.
2. Try creating a Zendesk ticket and scheduling a calendar meeting to confirm actions.
3. Check Airtable for inserted transcript records after simulated calls.

Step 4: Activate for Production

1. Turn the workflow ON inside n8n.
2. Ensure webhook URLs are accessible publicly or routed correctly (see self-host n8n if needed).
3. Monitor runs for errors and adjust credentials or data as needed.

How the Workflow Works

The workflow starts with receiving a customer’s phone number from Voiceflow via a Webhook node.

It cleans the number using a Set node to remove extra characters.

Google Sheets is queried to find matching customer data.

An If node checks if the customer exists.

If found, customer details go back to Voiceflow through a Respond to Webhook node.

If not found, the workflow creates or updates the customer in Zendesk using HTTP Request nodes.

It creates support tickets in Zendesk, checking if the ticket was made successfully and responding with success or error messages.

For meetings, another Webhook node accepts booking requests.

The workflow validates the date, checks calendar availability, then either books the event or sends failure notice.

Call transcripts and summaries are received by a Webhook node and saved into Airtable records.

Edge Cases and Failures

• If the Zendesk API credentials are wrong or expired, the workflow returns a 401 Unauthorized error.
• If no matching row is found in the Google Sheets lookup, the customer is treated as new.
• If the Google Calendar event overlaps or date is badly formatted, the system can reject the meeting.
• Make sure webhook paths match exactly the URLs used in Voiceflow to avoid missed triggers.

Customizations

• Edit the JSON in the Zendesk ticket creation node to add custom ticket tags or priorities.
• Change the Google Calendar event duration if needed by adjusting the time settings.
• Add extra customer info from Google Sheets like customer tier or status for better responses.
• Add email nodes after calendar booking to send confirmation emails.
• Add Slack nodes after ticket creation to notify support teams quickly.

Summary of Benefits ✓

✓ Saves about 3 hours daily by automating data lookups and ticket creation.

✓ Reduces manual errors by automatic data transfer and validation.

✓ Speeds up customer service with faster responses from AI agent integration.

✓ Stores transcript data for easier product team analysis.

✓ Improves meeting scheduling by validating calendars before booking.