You don't have access to a FTP or you aren't able to create an url which leads to your products data?

It is possible to create a products catalog from scratch using Google Sheets and save it in Lengow. This way, changes you'll made on your Google Sheets file will be automatically available for the next update of your file by Lengow.

How to create this file?

Open a new Google Sheets file (or open your file, if it already exists).

Complete this file with data you want to send to Lengow (articles such as Products Catalog and EAN codes and product variations could be useful)

2019-07-10_12h14_44.png

How to create a URL allowing Lengow to get access to my updated data?

Once your catalog/file is ready, in Google Sheets:

  • Go to "File"
  • "Publish to the web..."
  • "Link"
  • Select the page you want to share (using the "Entire document" dropdown menu) and "Comma-separated values (.csv)" (using the "Web page" dropdown menu)
  • Click on "Publish"
  • Copy the displayed link.

Then, in your Lengow account, you can choose to use this file as a products catalog or as an additionnal source for a registered catalog:

Add a new catalog Add this file to a registered catalog
Import your new catalog selecting "URL" as import method then paste the url you just got from Google Sheets, then follow listed steps.

 

File update

You can update your file at any time in Google Sheets, data will be automatically updated in your Lengow account, at the next planned indexing.

Import / Update data from Google Sheets

You don't have access to a FTP or you aren't able to create an url which leads to your products data?

It is possible to create a products catalog from scratch using Google Sheets and save it in Lengow. This way, changes you'll made on your Google Sheets file will be automatically available for the next update of your file by Lengow.

How to create this file?

Open a new Google Sheets file (or open your file, if it already exists).

Complete this file with data you want to send to Lengow (articles such as Products Catalog and EAN codes and product variations could be useful)

2019-07-10_12h14_44.png

How to create a URL allowing Lengow to get access to my updated data?

Once your catalog/file is ready, in Google Sheets:

  • Go to "File"
  • "Publish to the web..."
  • "Link"
  • Select the page you want to share (using the "Entire document" dropdown menu) and "Comma-separated values (.csv)" (using the "Web page" dropdown menu)
  • Click on "Publish"
  • Copy the displayed link.

Then, in your Lengow account, you can choose to use this file as a products catalog or as an additionnal source for a registered catalog:

Add a new catalog Add this file to a registered catalog
Import your new catalog selecting "URL" as import method then paste the url you just got from Google Sheets, then follow listed steps.

 

File update

You can update your file at any time in Google Sheets, data will be automatically updated in your Lengow account, at the next planned indexing.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request