API Implementation

To export data from Metricool using our API to other platforms such as Excel, Google Sheets, MySQL, and others, you can follow these general steps:

Obtain the Access Token: Before starting, you must obtain the API access token, available for Advanced and Custom plans. See the details here.

Set Up the HTTP Client: Use an API integration tool like Postman or a programming language (e.g., Python with requests) to send HTTP requests. Configure the authentication headers with your access token; in this case, the token must be sent in a custom header called “X-Mc-Auth.”

Make a Request to Metricool’s API: Depending on the data you want to export (posts, metrics, reports), you need to send a GET request to Metricool’s API.

Note that all calls to our endpoints require userId and blogId. Check out the API documentation here (available in English), where you can find .yaml and .json files for detailed endpoint descriptions, usage examples, and recommendations to use the browser inspector to view all calls and their parameters.

Example:


Format the Data: The data will usually come in JSON format. You’ll need to process it and format it properly for the target platform. This may require field mapping based on the API data structure from Metricool.

Export the Data to the Target Platform

| Keep in mind that each platform has its unique integration method, but the general flow follows this scheme.

Documentation

Here are links to the documentation for APIs of the most commonly used platforms for data management:

Microsoft Graph API para Excel
Google Sheets API
MySQL Connector
Oracle Database API
Microsoft SQL Server API
PostgreSQL API
MongoDB API
Snowflake API
Amazon Redshift API
Tableau API
Power BI API
BigQuery API
Databricks API

Updated on: 24/03/2025