Speed up the import and export of data in Mergado. Using Google Sheets

Article published 20.11.2020

The goal of every e-shopper and marketer is to speed up the work of setting up advertising. In Mergado, in addition to the usual tasks, you can now reduce the time of data import and export by using Google Sheets. Let's show you how to use this function.

Google Sheets is a convenient tool for catalog management

Google Sheets is a popular tool used to create spreadsheets. With it, you can not only monitor data from Mergado, filter it, or share it with team members but also speed up the import and export of data in Mergado thanks to the newly added feature. Let's see how you set everything up.

Export data to Google Sheets


  1. Export to Google Sheets takes place in the standard way via New Export.
  2. Enter the URL of the feed you want to export in the address.
  3. After downloading and analyzing the feed, either select an existing online store or create a new one.
  4. Then select the input format of the feed. Mergado can recognize it, but you can also choose it manually and define it if necessary.
  5. Select Google Sheets as the output format.
  6. Complete the export.
  7. Mergado will notify you if you do not have a connection set up in the Keychain application.
  8. Create a connection by signing in to your Google account.
  9. After a successful connection, you will be redirected back to creating a new export.
  10. Finish the creation.
  11. The resulting export is available on your Google drive under the name Your_online_store_input format_project id. The link is available in Mergado.
  • Save your Google Account login to both the online store and the user.
  • If a user tries to create a new store connection with a Google account and already has another store connected, the existing connection is going to be used.
  • You can also create connections in the Keychain in advance.

Import data from Google Sheets

What you should know:

  • The table must not contain data outside the named columns.
  • Changes made to Google Sheets will not take effect in Mergado until they are regenerated.
  • Google Sheets is not considered to be a format. It is therefore not possible to identify it at the input. The table can be of any format.


  1. Before entering into the Mergado interface, you must set up a table for sharing (path: Google - Get link - All users who have the link - Reader / Editor).
  2. Import from Google Sheets takes place in the standard way via New Export. Enter the URL of the spreadsheet into the address.
  3. Select either an existing online store or create a new one.
  4. Select the format that is included in the spreadsheet.
  5. Select the output format.
  6. Finish creating the export.

And that's all. Try this way to speed up export and import. Mergado offers many ways to work with feeds in bulk and automatically.

Read more:

What places does your feed pass through?

Do you advertise on comparison engines using Mergado, and it happens to you that the modified product data reaches them with a delay? To give you a better picture of ​​how data transfer works, we are going to describe the process of transiting an XML or CSV feed from your online store via Mergado to a comparison engine.

Transfer settings and data from one export to another in Mergado

Do you want to transfer already created queries and rules in one export to another in Mergado. Or be able to create a new export from the output URL of another export? All this is possible in our tool.

How to import a feed from Dropbox to Mergado

Do you use Dropbox to store your shop data? Save time searching for instructions on how to manage the import of feed into Mergado. We have prepared a simple procedure which help you to set up file sharing correctly. Let's get to it.


Add new comment