Adding Product Files from Google Sheets

DataFeedWatch Updated by DataFeedWatch

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

To add a product file from Google Sheets, follow the steps below:

  1. In Google Sheets:
    1. Select Share > Change
    2. Select Anyone with the link, and click Copy link
  2. Log in to your DataFeedWatch Account > Shops > Add shop
    1. Enter a Name for your shop
    2. In the Main Feed section, choose Google Sheets
    3. Paste the address in Source location field (copied from Google Sheets)
  3. To continue to Updates Schedule tab, click Next Tab
    1. From the drop-down, choose your timezone (e.g. UTC, Central Time, or London)
      Time is money, so this setting may be quite important. Remember 3 PM may mean different time of gathering your data if you chose London, and different for Sydney.
    2. Use Add Another Update button, to add more than one daily update times
      If you need more downloads that what's available for your plan here—you'll easily do that after you add this shop, in Shop Settings.
  4. To continue to Internal Fields tab, click Next Tab
    1. For each field on the left, select a main mapping type from the first drop-down
      You can just check and accept our suggestions where available.
    2. From the second dropdown, choose one of the attributes from your shop
    If you'd like to change and optimize your product attributes, try using also our IF Conditions and Edit Values options.
  5. To create a shop, click Finish

Did this article help you solve the problem?

Adding Product Files (CSV/TXT, XML, JSON)

Merge Your JSON data feed with other sources