Google Cloud Storage Service Connector

Service Account Key JSON

Copy and paste the JSON for your Google service account key. For information about creating a key, see “Prerequisites,” above.

Report

Select a Google Cloud Storage report. The following reports are available:

How Would You Like to Select the Cloud Storage Bucket Name?

Select Discover Bucket Name or Enter Bucket Name from the drop-down list.

Enter the Storage Bucket Name

Enter the bucket you want to use. This field populates when you select Enter Bucket Name from the How Would You Like to Select the Cloud Storage Bucket Name? field.

Bucket Name

Select the bucket you want to use from the drop-down list. This field populates when you select Discover Bucket Name from the How Would You Like to Select the Cloud Storage Bucket Name? field.

Prefix (optional)

Filters result for objects whose name begins with a prefix.

File Name

Enter * to import all files.

Object’s File Type

Select the file type for the object you want to pull into Domo.

Sub File Type

Select the file type for the zipped data file you want to retrieve.

Add Filename Column (optional)

Select YES if you want to add the BATCH_FILE_NAME column to the final output, or select NO.

Contains Header Row?

Select No if the CSV file does not contain a header row. The Connector will generate header rows for such files.

Select the Delimiting Character

Select the character used by your character-separated values (CSV) text to separate your columns. If your delimiter is not listed, select ‘Other.’

Specify Your Delimiter

Enter the character used to delimit your character-separated values (CSV) text.

Select the Quote Character (optional)

Select the desired quote character for parsing CSV files. (A double quote is the CSV standard.) If your quote character is not listed, select ‘Other.’

Specify Your Quote Character

Enter the quote character for your character-separated values (CSV) text.

Select the Escape Character (optional)

Select the desired escape character for the character-separated values (CSV) text. If the escape character is not listed, select ‘Other.’

Encoding

Select the charset encoding of your file. This fields appears when you select the Import Object and Import Multiple Objects reports.

Specify the Escape Character

Enter the escape character for the character-separated values (CSV) text.

Header Start Row (optional)

Enter the header start row number in the file.

Data Start Row (optional)

Enter the data start row number in the file.

Footer Rows to Skip (optional)

Enter the number of rows at the end of the file to skip. For example, to skip the last two rows you should enter 2 .

Sheet Name (optional)

Enter the sheet name you want to retrieve from the specific spreadsheet. Ensure to check the sheet name for accidental spaces. Use the first sheet of the workbook if the field is blank.

Excel File Password (optional)

Enter the password for the Excel file.

File Name Match Type (optional)

Specifies whether the file to be retrieved starts with or contains the name entered in the File Name field.

Subfile Name

Enter the name or a portion of the subfile name that you would like to import.

Object Name

Select the object you want to use.