Google Sheets + Zendesk

Create Zendesk tickets from new rows in Google Sheets

Turn your Google Sheets data into an actionable ticket queue in Zendesk. Every time a new row is added to a designated worksheet, Zapier will automatically create a Zendesk ticket. That gives you an easy way to track customer complaints or issues in a spreadsheet, and have them be automatically turned into support tickets.

When this happens...
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create Ticket
Create a new ticket.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger
Instant
New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
Scheduled
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Trigger
Scheduled
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Trigger
Instant
New Worksheet
Triggered when you create a new worksheet in a spreadsheet.
Trigger
Scheduled
Create Spreadsheet Column
Create a new column in a specific spreadsheet.
Action
Write
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
Action
Write
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action
Zendesk
Triggers when a new group is created.
Scheduled
Trigger
Zendesk
Triggers when a new organization is added to Zendesk.
Scheduled
Trigger
Zendesk
Triggers when a new ticket is added (Zendesk may take an hour to make tickets available via their API with this trigger).
Scheduled
Trigger
Zendesk
Triggers when there is activity (an audit) on a specific ticket. Can only watch one ticket per Zap.
Scheduled
Trigger
Zendesk
Triggers when a new ticket is added to a view.
Scheduled
Trigger
Zendesk
Triggers when a new user is created.
Scheduled
Trigger
Zendesk
Triggers when a new view is created.
Scheduled
Trigger
Zendesk
Create a new organization.
Scheduled
Action
Zendesk
Create a new ticket.
Scheduled
Action
Zendesk
Attach a file to an existing ticket.
Scheduled
Action
Zendesk
Add a comment to an existing ticket.
Scheduled
Action
Zendesk
Add one or more tags to an existing ticket.
Scheduled
Action
Zendesk
Update an existing organization.
Scheduled
Action
Zendesk
Update an existing ticket status or add comments.
Scheduled
Action
Zendesk
Update an existing user.
Scheduled
Action
Zendesk
Create a new user.
Scheduled
Action
Zendesk
Finds an existing agent.
Scheduled
Action
Zendesk
Finds an existing group.
Scheduled
Action
Zendesk
Finds an existing organization.
Scheduled
Action
Zendesk
Finds an existing ticket.
Scheduled
Action
Zendesk
Finds an existing user.
Scheduled
Action
Zendesk
Finds or creates a specific organization.
Scheduled
Action
Zendesk
Finds or creates a specific ticket.
Scheduled
Action
Zendesk
Finds or creates a specific user.
Scheduled
Action