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:

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
Setting categories is not difficult anymore. With the smart rule in Mergado

When managing advertising for comparison engines, you need to set the correct categories according to the category tree of the specific engine. Mergado users can do it with a rule which will significantly speed up the selection of categories. See how to do it.

29.10.2020
Learn how to work with the Find and Replace rule. It speeds up your work in the feed

Set up advertising as you need by using a handy tool for editing text in an XML feed. With the Find and Replace rule, you can replace, remove, or fix bugs on products across the entire feed. Let's show you how to use the rule and set it up for your online store.

20.10.2020

Add new comment