Discussions

Ask a Question
Back to All

API using Zapier to transfer call data to a Google Sheet

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?

Admin

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

ο»Ώ