Connecting Zendesk with google sheets


Hi! Today, I have come up with another interesting topic of zendesk and google sheets integration. The use case here is, whenever a new ticket is created in zendesk, automatically add a new row in google sheets with all the ticket information.

Let's understand what these two software applications are all about. Zendesk is a customer service and support ticketing software whereas google sheets is an online spreadsheet program.

The issue here is that zendesk and google sheets don't have any integration between them. That's why we are going to use a software named 'Pabbly connect'. It is an integration software that will help you to transfer data between zendesk and google sheet.

So let's get started...

First go to the link and sign up for free, and click on 'Pabbly Connect' > 'Access now'.

In the dashboard, on the top right corner; click on 'Create Workflow'. You can give any appropriate name according to your choice and click on create.

Next, choose the app as zendesk. In the trigger events, we have to chose 'New Ticket' trigger event among all. That's because our motive is to send ticket information to google sheet whenever a new ticket is created. This automation can be termed as trigger.

Coming down, we can see 'Webhook URL'. It is an essential way to get data from an external software at pabbly's end. This helps you to make a connection between the trigger software application and pabbly connect.

After choosing the app and trigger event, we copy the webhook URL and paste it in the trigger software application i.e. zendesk.

Now, we have to follow the given instructions and paste the URL in zendesk. I will be explaining the process through pictures in the further steps.

  • Login to your Zendesk account.
  • Click the Admin in the sidebar, then select Extensions.
  • Go to the Targets tab and Click on Add target link.
  • Select the HTTP target from all of the target options are listed.
  • Add New Ticket Webhook name in the Title field.
  • Copy the Webhook URL above & paste it under the URL field.
  • Choose the Method type POST from the dropdown and the Content type should be JSON.
  • Select Create Target from the dropdown list at the bottom of the page.
  • Click the Submit button.
  • Once you've set up targets, navigate to Settings > Business Rules > Triggers.
  • Click the Add trigger button.
  • Enter a trigger name in the Trigger name field.
  • Click on Add condition from Meet ALL of the following conditions. and create Ticket Is Created condition.
  • Click on Add action and choose to Notify target. then select New Ticket Webhook from the dropdown.
  • Copy and paste this JSON in the JSON body.
  • Create it.
  • As you can see it is waiting for webhook response, so that means we have to go create a ticket. So, let's go back to our zendesk account and create a new ticket as shown below.

    Now, let's go back to pabbly connect. We can see that it has already captured the data. You can check all the parameters and click on save.

    So here we have successfully finished our first step pf integration; and let's start start our second step of integration i.e. integrating with google sheets.

    Scroll down and click on '+' button and add and action step. Let's choose google sheet. so whenever a new ticket is created in zendesk, we want to add a new row in google sheets. That is why let's select 'Add New Row' as the action event. Then click on 'Connect'.

    Next, click on 'New Credentials'. Go to google sheets and create a new blank google sheet and create few fields as shown below.

    Now click on connect with google sheets and allow. Here we can see that there are few fields same as the headings in google sheets. We have to fill these fields with webhook response we got and click on save.

    So we have got our API response, that means we have successfully integrated zendesk and google sheets. Let's click on save.

    Now let's go to google sheets and see if we have all our details recorded.

    That should be a yes!
    So we have successfully finished our integration.
    Hope you liked this blog. Thank you for your time!