Google Cloud Storage

Import XML, CSV, TXT, or JSON files from Google Cloud Storage.

You can import an XML, CSV, TXT, or JSON file directly from your Google Cloud Storage (GCS).

1

Your data source and Import settings

• In Channable, go to Setup > Import and click + Choose import method (or Combine imports if you added an import in this project).
• Select the file type you need: XML, CSV, TXT, or JSON.

2

• At Name, add a name for your import.
• At [type of] file url, paste your GCS file URL from Google Cloud.

  • Make sure your URL starts with “https://storage.cloud.google.com”.
• At Authentication, select "Google Cloud Storage (GCS)".
• For Upload GCS Service Account Key file, create and download a Service Account key file using Google Cloud. Once you have created the file, upload it.
• For Encoding, Quoting and Delimiter, select "Automatically detect".
• Click Run import.

For security reasons, make sure that your Google Service Account has as few permissions as necessary. For example, make sure the account only allows read access for the files you want to import.

If a file in GCS is available publicly, you do not need to set up authentication (Check Public URL in Google Cloud). You can select “No authentication” at Authentication.

3

Import mapping

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

• Imported data 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 it's important to 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

• Compare and adjust mapping:

  Review your Imported data fields against Channable's matched Project fields. If a field was matched incorrectly, click on the field to select a different field.
• 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.
• 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.

Your data will start importing from Google Cloud Storage.