Get data from Mergado to Google Sheets

Do you need to monitor data from Mergado, 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.

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.
  2. Take the URL from Mergado -> use the output URL.
  3. You can set the XPath 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.

 

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".

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:

The Ecommerce Warsaw Expo brought a detailed insight into Polish e-commerce

The Ecommerce Warsaw Expo is the largest marketing event in Central Europe. It offers a lot of up-to-date information and inspiration on how to improve their services. Mergado and Feed Image Editor teams set out to explore the local environment and show that the Polish e-commerce scene will also appreciate the quality of their tools.

24.10.2019
Import store's CSV files via URL with the latest Mergado release

Are you also a user of Mergado who has been eagerly awaiting the feature of importing CSV data files into our platform? You can do this for several weeks using the new Data File Import rule. Starting this afternoon, you will also be able to add the data in this rule via the URL.

17.10.2019
Simplify your advertising settings with Mergado apps

The Mergado apps family is wide. To get an overview of what apps help you set up your advertising, we've made you a list of all the useful information. Read what Mergado apps are perfect for you.

11.10.2019

Add new comment