Google Sheets

Good to know

• Your data feed URL must be in an accessible online location.

• Channable supports compressed file formats:

  • XML, JSON, CSV, text, and Google spreadsheet files in the .gz format

  • XML and JSON files in the .zip format.

• The data feed has to be updated on the same URL (recommended at least once a day) with the latest product information (e.g. available stock, prices).

Step 1: Set up import

1

Important: Before you start, make sure your Google sheet is shared and publicly available.

• In Channable, go to Setup > + Setup import.

• Select the Google sheets file type.

• Provide the requested information:

  • For Name, give your import a descriptive name (e.g., "Webshop Google import").

  • For Google sheets url, add the URL to fetch your live product data.

• Click Start import. You will be directed to the Edit mapping page to import your product data.

Step 2: Map your products

This page displays fields retrieved from your data feed (e.g. price, description, title).

• Import field: Fields from your import data.

• Project field: Corresponding project fields in Channable. Our system will automatically detect and link most fields to standardized fields.

Match (map) your imported fields to a corresponding project field. Channable does most mapping automatically, but review and adjust before importing.

Note: We create new project fields if we can't assign your import field to a standardized field. These fields will have a project field with the same name as your import field.

Before you continue

1. Compare and adjust mapping:

   • Review your Import fields against Channable's matched Project fields. If a field was matched incorrectly, click on the field to select a different field.

2. Check and correct field types:

   • Check that the right field type is assigned to your project fields. If a field has the wrong type, click Edit next to the field, select the correct type in the dropdown, and click Save & Import.

3. Exclude fields (optional):

   • To exclude a field from being included in your product data, click the checkbox in the Select column for that field and click Do not import selected fields.

Once you've finished mapping, click Save & Import to start importing your product data. Depending on how much data you're importing, it can take a while to finish.

Note: Check the Status column in Setup to check your import progress. Your product data is fully imported when the Status is Finished.

Step 3: Review your imported items

After your product data has finished importing:

• Go to the Items page to view your imported products.

• Click on an item to see detailed information.

Your import is now successfully set up! You can now use this product data to create and optimize Feeds, Marketplaces, Shopping Ads, and more in Channable.