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

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

Method:

  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.

Method:

  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:

How Mergado works and why it is so handy

To make your advertising on product search engines successful, you must have an XML feed set up according to their required specifications. You no longer have to hire a programmer to make these modifications. With Mergado, you can set up advertising campaigns for your online store yourself. How does this tool work?

07.01.2021
Why you need so much personal information to register in Mergado, and why you don't have to be afraid of it

Do you think that the Mergado registration form has a lot of fields and wants a lot of information from you right away, even if you want to try it? No need to worry about that. Below, we will explain why.

09.12.2020
Manage to advertise centrally using configuration CSVs

Learn a new way to set up advertising in Mergado automatically and in bulk. Ever since we introduced the rule for importing data from CSV files, you can edit specific parts of your advertising from one place by creating configuration CSVs.

11.11.2020

Add new comment