API using Zapier to transfer call data to a Google Sheet

10 months ago by Dhrushil

Hi. I wanted to transfer my call analytics such as number of calls made per day, inbound and outbound, and call length over to a google sheet at the end of the day. I have tried using Zapier to do so, but I can not find the correct variables to utilise and use to transfer them over. Where do I look for them? Or is there another way to do this?

10 months ago by Gabriel TimmAdmin

Hey there. The best resource to obtain analytics is the Stats API POST https://developers.dialpad.com/reference/statscreate.

There isn't a Zapier Action for this but since it's just an API call, you can technically use the Zapier Generic HTTP/API Request and hit this endpoint.

That said, this API will return a token that you need to exchange for an URL to download a CSV report using the GET method, so orchestrating this via Zapier might not be that simple. I would suggest contacting a developer to build a simple app or script that would help you with that instead.

Another method you could try is to download the Export or Schedule Exports via Dialpad Analytics.
https://help.dialpad.com/v1/docs/en/export-your-analytics-data

﻿