You can import an XML, CSV, TXT, or JSON file directly from your Google Cloud Storage (GCS).
Contents
- Step 1: Add a new XML/CSV/TXT/JSON import
- Step 2: Configure the GCS import settings
- Step 3: Import your items
Step 1: Add a new XML/CSV/TXT/JSON import
- Go to Setup > Import.
- Click Setup import (or Combine imports if you added an import in this project).
- Select the file type you need: XML, CSV, TXT, or JSON.
Step 2: Configure the GCS import settings
- 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".
Important: 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.
Note: 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.
Step 3: Import your items
After configuring the GCS settings for your import, click Start import. You will be directed to the Edit mapping tab where you need to click Save & Import.
Your data will start importing from Google Cloud Storage.