- [Case Studies](https://www.mergado.com/category/case-studies)
- [eCommerce tips](https://www.mergado.com/category/ecommerce-tips)
- [Online Store Solutions and Platforms](https://www.mergado.com/category/online-store-solutions-and-platforms)
- [Mergado Pack](https://www.mergado.com/category/mergado-pack)
- [Mergado tips](https://www.mergado.com/category/mergado-tips)
- [Mergado News](https://www.mergado.com/category/mergado-news)
- [eCommerce News](https://www.mergado.com/category/ecommerce-news)
- [How to use Mergado](https://www.mergado.com/category/how-to-use-mergado)
- [Interviews with e‑commerce gurus](https://www.mergado.com/category/interviews-e-commerce-gurus)
- [Extensions](https://www.mergado.com/category/apps-bidding-image-marketing-and-more)
- [Expansion with Mergado](https://www.mergado.com/category/expansion-with-mergado)
- [Mergado Lifestyle](https://www.mergado.com/category/mergado-lifestyle)
1. [ Home ](https://www.mergado.com/)
2. [ Mergado Blog ](https://www.mergado.com/blog)
3. [ How to use Mergado ](https://www.mergado.com/category/how-to-use-mergado)
4. **Get data from Mergado to Google Sheets**
# **Get data from Mergado to Google Sheets**
[  Lukáš Horák ](https://www.mergado.com/blog/lukas-horak) [How to use Mergado](https://www.mergado.com/category/how-to-use-mergado)
1. 11. 2019
2 minutes read
Do you need to **monitor** data from [Mergado](https://www.mergado.com/get-started), **filter** it, or **share** it with team members? In the new mini-series, we’ll show you how easily you get them **from Mergado to the services you use**. First, we’ll show you how to send Mergada data to [Google Sheets](https://www.google.com/intl/cs_cz/sheets/about/).
function tableOfContents() {
return {
headings_menu: [],
heading_active: '', // Added to track the active section
shouldBeSticky: false,
generateToC() {
const headings = document.querySelectorAll('.js-article-full-headings h2, .js-article-full-headings h3');
let headingMap = {};
headings.forEach((heading) => { // Use an arrow function to maintain `this` context
// Normalize heading text to remove diacritics, then replace non-alphanumeric characters with dashes
var normalizedText = heading.textContent.normalize("NFD").replace(/[\u0300-\u036f]/g, ""); // Remove diacritics
var id = heading.id ? heading.id : normalizedText.trim().toLowerCase()
.split(' ').join('-').replace(/[^a-z0-9\-]/ig, ''); // Updated regex to replace non-alphanumeric characters
headingMap[id] = headingMap[id] !== undefined ? ++headingMap[id] : 0;
// Use the updated `id` with diacritics removed for the heading id and the TOC
const finalId = headingMap[id] ? `${id}-${headingMap[id]}` : id;
this.headings_menu.push({
id: finalId,
title: heading.textContent,
level: heading.tagName.toLowerCase(), // Track heading level
active: false, // Initially set active to false
});
heading.id = finalId;
});
},
checkStickyNeeded() {
const ul = this.$el.querySelector('ul');
if (ul) {
this.shouldBeSticky = ul.scrollHeight < window.innerHeight;
}
},
setActiveHeading() {
// disabled not working with active state on click
// add @scroll.window="setActiveHeading()" to the parent div
// const headings = document.querySelectorAll('.js-article-full-headings h2');
// let activeHeading = '';
// let closestHeadingDistance = Infinity;
// headings.forEach((heading) => {
// const rect = heading.getBoundingClientRect();
// const offset = rect.top - window.innerHeight / 2; // Consider heading in the middle of the screen as active
// if (offset < 0 && Math.abs(offset) < closestHeadingDistance) {
// activeHeading = heading.id;
// closestHeadingDistance = Math.abs(offset);
// }
// });
// // Update the active state in headings_menu
// if (activeHeading !== this.heading_active) {
// this.headings_menu = this.headings_menu.map(item => ({
// ...item,
// active: item.id === activeHeading,
// }));
// this.heading_active = activeHeading;
// }
},
setActiveItem(clickedId) {
this.headings_menu.forEach(item => {
item.active = (item.id === clickedId);
});
this.heading_active = clickedId; // Optionally update the heading_active property if used
},
};
}
1. —
Do you need to **monitor** data from [Mergado](https://www.mergado.com/get-started), **filter** it, or **share** it with team members? In the new mini-series, we’ll show you how easily you get them **from Mergado to the services you use**. First, we’ll show you how to send Mergada data to [Google Sheets](https://www.google.com/intl/cs_cz/sheets/about/).
## Easy collaboration with Mergado and Google Sheets
Google Sheets is a frequently used tool in which you can **create** easy-to-use **spreadsheets** to work with colleagues from your team. Many professionals use this service for further data processing (sorting, filtering, monitoring, etc.).
**If you need to get data from Mergado to Google Sheets, here’s how:**
1. In the new sheet, **enter** the XML feed import function in the first cell: IMPORTXML, which has the following syntax: [https://support.google.com/docs/answer/3093342?hl=en](https://support.google.com/docs/answer/3093342?hl=cs).
2. **Take the URL from Mergado** -> use the output URL.
3. You can **set** the [XPath](https://www.w3schools.com/xml/xpath_syntax.asp) **as** **needed**, for example, if you have products in the SHOPITEM element, use “//SHOPITEM”.
4. Google Sheets will **retrieve and divide your data into columns** — each product in one line.
[  ](https://www.mergado.com/sites/default/files/perm/paragraph-image/obr2sheets.png)
When importing into Google Sheets, you can **import some data and create simple conditions** using a properly specified XPath. For example, if you only want to list PRODUCTNAME for products with PRICE\_VAT bigger than or equal to 500, use XPath: *“//SHOPITEM\[PRICE\_VAT>=500\]/PRODUCTNAME”*.
[  ](https://www.mergado.com/sites/default/files/perm/paragraph-image/obr1sheets.png)
In Google Sheets, you can filter data by adding filters, apply conditional formatting, use scripts, get a summary of changes and other features of the Google spreadsheet itself.
Google Sheets has some **limitations on the size of the imported data**; Linking data from Mergado is easy, and you and your team get a real **overview** of your data.
### **You could be also interested in:**
[ 
### Simplify your advertising settings with Mergado apps
](https://www.mergado.com/mergado-apps-overview)
[ 
### What should a proper client context look like for performance specialists?
](https://www.mergado.com/blog/master-prompt-eshopy-b2c)
[ 
### How Feed Optimization Unlocked Meta Ads Performance without Increasing Ad Spend
](https://www.mergado.com/blog/feed-optimization-for-meta-ads)
[  ](https://www.mergado.com/blog/lukas-horak)### [ Lukáš Horák ](https://www.mergado.com/blog/lukas-horak)
Lukáš takes care of most of the Czech and English communication in Mergado. Through blogs, e‑mail, and social networks, he regularly supplies readers with e‑commerce news and news and tips from Mergado. In his time off, he enjoys simple things like badminton, digging the hidden gems of the 80’s, and seafood served with red wine.
## What you *might be interested in next*
[ 
### How We Migrated an E‑Shop from Shoptet to Shopify with Mergado: A Complete Migration Without Data Loss
](https://www.mergado.com/blog/how-we-migrated-e-shop-shoptet-shopify-mergado-complete-migration-without-data-loss)
[ 
### How to open large XML file
](https://www.mergado.com/blog/how-to-open-large-xml-file)
[ 
### Introducing smart value insertion. It will speed up the creation of bulk rules
](https://www.mergado.com/blog/smart-value-insertion)
## Don’t miss *anything*
Sign up for our newsletter
By logging in, you agree that we will process your data by the [terms of personal data protection](https://www.mergado.com/cookies).
Thank you, you have successfully joined our subscriber's list.
function ml_webform_success_5807248() {
var r = ml_jQuery || jQuery
r('.ml-subscribe-form-5807248 .row-success').show(), r('.ml-subscribe-form-5807248 .row-form').hide()
}