How to Connect Mercado Libre with Power BI, Looker Studio, and Spreadsheets
For Mercado Libre sellers and agencies managing marketplace operations across Latin America, centralizing sales, ads, shipping, and reputation data into a single view is no longer optional. Kondado replicates Mercado Libre data directly into Power BI, Looker Studio, Google Sheets, and Excel without code, without manual exports, and without touching the marketplace API. This guide walks through each of the three destinations and helps you pick the one that fits your team.
Kondado replicates Mercado Libre data into Power BI, Looker Studio, Google Sheets, and Excel on the schedule you choose, no code required. A single Mercado Libre pipeline exposes sales, listings, questions, messages, shipping, reputation, and paid-ads metrics. Power BI fits BI teams with modeling needs; Looker Studio is the no-cost option for sharing; spreadsheets serve teams that have not adopted BI yet. The trial includes 30 active pipelines, 10M records, and no credit card required.
Who should centralize Mercado Libre data?
Mercado Libre sellers know the drill: dozens of browser tabs open at once to track sales, questions, paid listings, shipping deadlines, and reputation. Once operations scale, exporting one CSV at a time becomes the bottleneck. The profiles that gain the most from centralizing this data include:
- SMBs and e-commerce operations selling on several channels who need to compare Mercado Libre with Shopify, VTEX, Tray, Nuvemshop, and other marketplaces.
- Marketing and BI agencies managing Mercado Libre accounts for clients who need standardized reports.
- Mid-market and enterprise operations cross-referencing marketplace data with ERPs (Tiny ERP, Bling!, Omie, Conta Azul) for financial and tax reconciliation.
- Paid-media teams who want to cross Mercado Libre Ads spend with revenue, ROAS, and true margin per listing.
Kondado serves these profiles together. The same Mercado Libre pipeline supports the operator who only wants daily sales in a spreadsheet and the BI team that needs dimensional modeling in Power BI.
Which Mercado Libre data can you extract?
To see all available data sources in Kondado, visit the data source catalog.
The Mercado Libre data source in Kondado exposes the marketplace's main entities so you can model reports, report templates, and spreadsheets with real depth. The available data includes:
- Sales and orders, including status, totals, fees, discounts, payment terms, and line items.
- Listings, with title, category, condition, price, stock, visits, and conversion.
- Shipping and logistics, with shipping type (Flex, Full, Pickup, Agency), deadlines, cost, and delivery SLA.
- Reputation and quality metrics, such as MercadoLíder tier, claims, cancellations, and response time.
- Questions and messages, useful for tracking pre-sales and customer service.
- Paid ads (Product Ads), with spend, impressions, clicks, and sales attribution.
This data is replicated to the destination you pick and is available to any BI tool or spreadsheet connected to it.
How to connect Mercado Libre with Power BI step by step
Power BI is Microsoft's tool for data analysis and report building. To replicate Mercado Libre data into Power BI with Kondado:
- Create your Kondado account at app.kondado.com.br and start the trial.
- In the side menu, open "Sources" and add Mercado Libre. The flow opens a Mercado Libre window for authentication, with no tokens or API keys to manage.
- Pick the Mercado Libre account you want to connect and authorize access. Kondado requests only the permissions needed to read sales, listings, shipping, and reputation.
- Under "Destinations", add Power BI. This destination is one of the native cards listed on Kondado's destinations page.
- Create a pipeline linking the Mercado Libre source to the Power BI destination, picking which tables (sales, listings, etc.) you want to replicate.
- Set the refresh frequency. It can be every few minutes, hourly, or daily, depending on your business needs.
- In Power BI Desktop or the Power BI Service, connect to the dataset generated by Kondado and start building your reports.
From that point on, each pipeline run refreshes Power BI without manual intervention. You can publish the report to the Power BI Service and share it with the team or clients.
How to connect Mercado Libre with Looker Studio step by step
Looker Studio is Google's no-cost data visualization tool, often the first choice for teams that need to share reports with clients or colleagues without extra license cost. To replicate Mercado Libre data into Looker Studio:
- Open your Kondado account and add Mercado Libre as a source (same step as the Power BI tutorial: OAuth authentication, no code).
- Under "Destinations", add Looker Studio. This destination also appears on Kondado's destinations page and is available across all plans.
- Create a pipeline linking Mercado Libre to Looker Studio. Choose the tables you want to make available for visualization.
- Set the pipeline refresh frequency.
- In Looker Studio, connect to the source generated by Kondado. From there, drag fields to build charts, tables, and scorecards.
- Share the report with clients, teammates, or stakeholders using Looker Studio's built-in permissions system.
Because Looker Studio is free, this combination is the usual entry point for sellers and agencies that do not yet have budget for enterprise BI licenses.
How to connect Mercado Libre with spreadsheets (Google Sheets and Excel)
Spreadsheets remain the most-used tool in SMBs, agencies, and operations that have not migrated to BI. Kondado replicates Mercado Libre data into both Google Sheets and Microsoft Excel, and both are supported destinations.
To replicate to Google Sheets:
- Add Mercado Libre as a source in Kondado.
- Under "Destinations", add Google Sheets and authorize Kondado to write to a spreadsheet in your account.
- Create a Mercado Libre to Google Sheets pipeline. Each table becomes a tab in your Sheet.
- Set the refresh frequency. The spreadsheet is rewritten on every pipeline run with the latest data.
To replicate to Microsoft Excel:
- Add Mercado Libre as a source in Kondado.
- Under "Destinations", add Excel. Files can be generated in a format compatible with local Excel or Excel Online.
- Create a Mercado Libre to Excel pipeline and pick the tables you want to replicate.
- Set the refresh frequency and use the file in Excel as the base for your analyses or reports.
For teams that still make decisions directly in a spreadsheet, this combination removes the daily chore of manually exporting reports from the Mercado Libre back office.
Which destination should you pick for your Mercado Libre data?
| Destination | Best For... | Cost | Technical Level |
|---|---|---|---|
| Power BI | BI teams, dimensional modeling, corporate reports, high data volume operations | Paid license | Advanced |
| Looker Studio | Agencies, freelancers, teams sharing reports with multiple clients | Free | Intermediate |
| Spreadsheets (Google Sheets or Excel) | SMBs without BI adoption yet, ad-hoc analyses | Variable (Sheets free) | Beginner |
The three destinations solve different scenarios. Instead of picking the most popular tool, pick the one that matches your team's routine. One reminder: the same Mercado Libre pipeline in Kondado can feed more than one destination in parallel. You do not have to pick just one. A common pattern is to feed Power BI for the BI team and Google Sheets for the operations manager from the same source at the same time.
Mercado Libre report templates
If you do not want to start from scratch, Kondado maintains a catalog of report templates for Power BI, Looker Studio, and spreadsheets. These templates serve as a starting point for you to adapt to your operation, including common calculations for net sales, fees, shipping, and reputation. Templates are free during the Kondado trial and remain available on paid plans for continuous use.
Frequently asked questions
How does Kondado connect to Mercado Libre? Do I need an API key?
No. The connection runs through OAuth authentication inside Mercado Libre itself. You pick the account and authorize access, with no need to handle tokens, refresh tokens, or API keys manually.
Which tables are available in the Mercado Libre source?
The source exposes sales, line items, listings, questions, messages, reputation, shipping metrics, and paid-ads data. For the updated list, check the Mercado Libre data source catalog.
Can I use the same pipeline for multiple Mercado Libre accounts?
You can connect several Mercado Libre accounts in parallel in Kondado. Each account becomes a separate source, and you can merge everything at the destination (Power BI, Looker Studio, or spreadsheet) using seller_id filters.
Does the pipeline work for sellers across Latin America?
Yes. Mercado Libre operates across several Latin American countries, and Kondado connects to the same source regardless of the origin site.
What does it cost to replicate Mercado Libre into Power BI or Looker Studio with Kondado?
Kondado offers a trial with 30 active pipelines, 10M records, and no credit card required. Paid plans afterwards start at competitive entry prices and can be billed in USD or BRL, with NF, Pix, and boleto as billing options. Bilingual support is available in English and Portuguese. See the pricing page for current rates.
Centralize your Mercado Libre data today
Sellers, agencies, and BI teams already using Kondado save hours every week on manual exports and get reports refreshed automatically in Power BI, Looker Studio, and spreadsheets. Create your account and start the Kondado free trial to replicate Mercado Libre data into your destination of choice today.
