Skip to content
  • There are no suggestions because the search field is empty.

Import Product Data from Google Sheets

To add your shop, and then optimize your product feeds, first we need to import the product information from the source you select.

For adding other files, refer to Adding Product Files (.csv, .xml, .txt, .json).

Before you start

  1. Open your Google Sheets file you want to import product data from, and: 
    1. Select Share in the top right corner
    2. Select Anyone with the link, and click Copy link.

 

2. Log in to your DataFeedWatch Account.

3. Navigate to Shops.

4. Click the button Add shop.



4. Before you select the (CSV/TXT, JSON, XML as an import file, you need to name your shop.

 

Why should you name your shop?
Giving your shop a name makes it easier to identify among others on your shop list. You can choose any name you like—it won’t affect feed optimization.

 

name_your_shop

5. Next, you can start setting up your input feed. 

What is input feed? 

An input feed is the product data you import from your shop or another source so we can create an optimized channel feed. 

To add Google Sheets as an input feed: 

  1. When setting up your input feed, choose Google Sheets as an import file.
  1. google_sheets_as_the_import_file

2. Enter Google Sheets URL. 

enter_google_sheets_URL

3. Click Next: Update Schedule to continue.