Basic Guide for API Integration
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: 12/06/2025
Thank you!