How can the matelso API call data be transferred to a Google Sheet?

Do you want to import your call data directly from matelso into your Google Sheets for further editing? #

This is very easy to do – simply create a Google Sheet and enter the following line in cell A1 to retrieve the matelso API data:


Code: #

=IMPORTXML(""; "//item/data")

Requirement: The matelso API must be activated for your account.

The matelso API activates or uses the method show_calls. See also the API documentation in the Control Panel.

To be added individually in the line:

1. Partner ID=xxx (note: user accounts do not work here, this must be the API account/partner ID)
2. API/partner password=xxx (caution: password must be URL-encoded! See for example:
3. Start/Enddatum=Gewünschter Call-Reportzeitraum (Format: DD.MM.YYYY)

In principle, all matelso API methods can be accessed this way.

matelso platform
matelso optimally connects telephony, chat, email or contact forms. Our intelligent lead management simplifies communication and enables you to achieve better marketing results.
matelso platform in detail
Call Tracking

MarTech phone call analysis software for companies, agencies & portals to get valuable data from inbound calls.

Call Tracking in detail
Marketing Use Case
How the matelso platform boosts your marketing.
Sales Use Case
How the matelso platform boosts your sales process.
E-Commerce Showcase

Showcase of the matelso platform in E-Commerce

What capabilities does our matelso platform offer? All features at a glance.
Do-it-with-me instead of DIY: Work with our consultants to really get the most out of the platform.
Do-it-with-me instead of DIY: Achieving more together with our consultants.
Use Cases

Three industries that should rely on call tracking: B2B, automotive and agencies!

Blog Through our blog, we share knowledge and insights with our readers - always useful, always interesting.
Webinars With our matelso webinars, you can experience our MarTech technologies and solutions and get valuable tips for your online marketing.
Knowledge Base On our matelso Knowledge Base you can delve deep into the engine room of our Call Tracking and MarTech technology.


Career Creating a new data-based era of communication - if you share this vision, we should get to know each other.
Partner model Help your customers better understand and manage their customer journey - while also generating a new revenue stream.


About Us The MarTech company matelso - we stand for innovative and simple solutions that make your marketing more efficient.
Newsroom News, press releases and more - all news about matelso at a glance.