> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Cloud Storage Service Connector

<Warning>
  ****Important:**** Due to Google’s change in allowing Domo connectors to use OAuth authentication, all users must now use service account key authentication to create new data connections. To create new Google Cloud Storage DataSets, use this connector. All pre-existing Google Cloud Storage DataSets will continue to run normally.
</Warning>

## Intro

Google Cloud Storage is an Internet service used to store data in Google's cloud. You can use Domo's Google Cloud Storage Service connector to get data about project buckets and objects in Google Cloud Storage. Buckets are general locations and destination for files to be stored. Projects organize the resources and permissions. Most people will use this connector to connect to the buckets that store their data.

To find out more about the Google Cloud Storage API, visit [https://cloud.google.com/storage/docs/json\_api/](https://cloud.google.com/storage/docs/json_api/ "https://cloud.google.com/storage/docs/json_api/").

The Google Cloud Storage connector is a "File" connector, meaning it retrieves files and outputs them to Domo. In the Data Center, you can access the connector page for this and other File connectors by clicking **File** in the toolbar at the top of the window.

You connect to your Google Cloud Storage account in the Data Center. This topic discusses the fields and menus that are specific to the Google Cloud Storage connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Data Connector").

<table class="mt-responsive-table" data-aura-rendered-by="33:201;a"><tbody><tr><td class="mt-noheading" colspan="1" rowspan="1"><p><b> Primary Use Cases </b></p></td><td class="mt-noheading" colspan="1" rowspan="1"><p> Files of any size can be delivered to the Google Cloud Storage buckets. You can list the files in a bucket or retrieve individual files. You can also use this connector to pull details about the buckets and projects associated with the bucket or project name. </p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p><b> Primary Metrics </b></p></td><td class="mt-noheading" colspan="1" rowspan="1"><p> None. This connector is primarily used for grabbing files out of a cloud storage bucket. </p></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p><b> Primary Company Roles </b></p></td><td class="mt-noheading" colspan="1" rowspan="1"><ul><li><p> Data specialists </p></li><li><p> Analysts </p></li><li><p> MajorDomos </p></li></ul></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p><b> Average Implementation Time </b></p></td><td class="mt-noheading" colspan="1" rowspan="1"><ul><li><p> Entering credentials - 15 minutes or less </p></li><li><p> Configuring the connector - 20 minutes </p></li><li><p> Allowing the connector to run - Time varies depending on file size </p></li></ul></td></tr><tr><td class="mt-noheading" colspan="1" rowspan="1"><p><b> Ease of Use (on a 1-to-10 scale with 1 being easiest) </b></p></td><td class="mt-noheading" colspan="1" rowspan="1"><p> 4 </p></td></tr></tbody></table>

## Prerequisites

To connect to a Google service account, you must have a Google service account JSON key. To generate a key, do the following:

1. In the GCP Console, open the
   ********IAM & Admin******** page.
2. Click
   ****************Service accounts**************** in the left-hand navigation pane.
3. Select your project and click
   ****************Open****************.
4. Click
   ****************Create Service Account****************.
5. Enter a name and description for the service account.
6. Click
   ****************Create****************.
7. Select
   ****************Project Owner****************.
8. Click
   ****************Continue****************.
9. Click
   ****************Create key****************.
10. Select
    ****************JSON**************** as the key type.
11. Click
    ****************Create****************.

A private key will be saved to your computer.

## Connecting to a Google Service Account

This section enumerates the options in the **Credentials** and **Details** panes on the Google Cloud Storage Service Connector page. The components of the other panes on this page, **Scheduling**, and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Data Connector").

### Credentials Pane

This page contains fields for entering credentials to connect to a Google service account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:201;a"><thead><tr><th colspan="1" rowspan="1"><p> Field </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Service Account Key JSON </p></td><td colspan="1" rowspan="1"><p> Copy and paste the JSON for your Google service account key. For information about creating a key, see "Prerequisites," above. </p></td></tr></tbody></table>

Once you have entered a valid key, you can use the same account any time you go to create a new Google Cloud Service DataSet. You can manage connector accounts in the ****************Accounts**************** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](https://domo-support.domo.com/s/article/360042926054?language=en_US "Managing User Accounts for Connectors").

### Details Pane

This pane contains a primary **Report** menu, along with various other menus which may or may not appear depending on the report type you select.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:201;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Report </p></td><td colspan="1" rowspan="1"><p> Select a Google Cloud Storage report. The following reports are available: </p><table border="1" cellpadding="1" cellspacing="1"><tbody><tr><td colspan="1" rowspan="1"><p><b> Report Name </b></p></td><td colspan="1" rowspan="1"><p><b> Description </b></p></td></tr><tr><td colspan="1" rowspan="1"><p> List Buckets </p></td><td colspan="1" rowspan="1"><p> Returns the list of buckets in the project associated with the authenticated service account. </p></td></tr><tr><td colspan="1" rowspan="1"><p> List Objects </p></td><td colspan="1" rowspan="1"><p> Returns data about the objects in the specified bucket. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Import All Objects </p></td><td colspan="1" rowspan="1"><p> Lets you import a CSV, XLS, XLSX object or a CSV, XLS, XLSX file that is inside all objects. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Import Multiple Objects </p></td><td colspan="1" rowspan="1"><p> Lets you import a CSV, XLS, XLSX object or a CSV, XLS, XLSX file that is inside the ZIP/GZIP objects. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Import Object </p></td><td colspan="1" rowspan="1"><p> Lets you import a CSV, XLS, XLSX object or a CSV, XLS, XLSX file inside a ZIP/GZIP object. </p></td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"><p> How Would You Like to Select the Cloud Storage Bucket Name? </p></td><td colspan="1" rowspan="1"><p> Select <b> Discover Bucket Name </b> or <b> Enter Bucket Name </b> from the drop-down list. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Enter the Storage Bucket Name </p></td><td colspan="1" rowspan="1"><p> Enter the bucket you want to use. This field populates when you select <b> Enter Bucket Name </b> from the <b> How Would You Like to Select the Cloud Storage Bucket Name? </b> field. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Bucket Name </p></td><td colspan="1" rowspan="1"><p> Select the bucket you want to use from the drop-down list. This field populates when you select <b> Discover Bucket Name </b> from the <b> How Would You Like to Select the Cloud Storage Bucket Name? </b> field. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Prefix (optional) </p></td><td colspan="1" rowspan="1"><p> Filters result for objects whose name begins with a prefix. </p></td></tr><tr><td colspan="1" rowspan="1"><p> File Name </p></td><td colspan="1" rowspan="1"><p> Enter <b> \* </b> to import all files. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Object's File Type </p></td><td colspan="1" rowspan="1"><p> Select the file type for the object you want to pull into Domo. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Sub File Type </p></td><td colspan="1" rowspan="1"><p> Select the file type for the zipped data file you want to retrieve. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Add Filename Column (optional) </p></td><td colspan="1" rowspan="1"><p> Select YES if you want to add the BATCH\_FILE\_NAME column to the final output, or select NO. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Contains Header Row? </p></td><td colspan="1" rowspan="1"><p> Select No if the CSV file does not contain a header row. The Connector will generate header rows for such files. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Select the Delimiting Character </p></td><td colspan="1" rowspan="1"><p> Select the character used by your character-separated values (CSV) text to separate your columns. If your delimiter is not listed, select 'Other.' </p></td></tr><tr><td colspan="1" rowspan="1"><p> Specify Your Delimiter </p></td><td colspan="1" rowspan="1"><p> Enter the character used to delimit your character-separated values (CSV) text. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Select the Quote Character (optional) </p></td><td colspan="1" rowspan="1"><p> 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.' </p></td></tr><tr><td colspan="1" rowspan="1"><p> Specify Your Quote Character </p></td><td colspan="1" rowspan="1"><p> Enter the quote character for your character-separated values (CSV) text. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Select the Escape Character (optional) </p></td><td colspan="1" rowspan="1"><p> Select the desired escape character for the character-separated values (CSV) text. If the escape character is not listed, select 'Other.' </p></td></tr><tr><td colspan="1" rowspan="1"><p> Encoding </p></td><td colspan="1" rowspan="1"><p> Select the charset encoding of your file. This fields appears when you select the <b> Import Object </b> and <b> Import Multiple Objects </b> reports. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Specify the Escape Character </p></td><td colspan="1" rowspan="1"><p> Enter the escape character for the character-separated values (CSV) text. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Header Start Row (optional) </p></td><td colspan="1" rowspan="1"><p> Enter the header start row number in the file. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Data Start Row (optional) </p></td><td colspan="1" rowspan="1"><p> Enter the data start row number in the file. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Footer Rows to Skip (optional) </p></td><td colspan="1" rowspan="1"><p><b /> Enter the number of rows at the end of the file to skip. For example, to skip the last two rows you should enter <tt> 2 </tt>. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Sheet Name (optional) </p></td><td colspan="1" rowspan="1"><p> 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. <b /></p></td></tr><tr><td colspan="1" rowspan="1"><p> Excel File Password (optional) </p></td><td colspan="1" rowspan="1"><p> Enter the password for the Excel file. </p></td></tr><tr><td colspan="1" rowspan="1"><p> File Name Match Type (optional) </p></td><td colspan="1" rowspan="1"><p> Specifies whether the file to be retrieved starts with or contains the name entered in the File Name field. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Subfile Name </p></td><td colspan="1" rowspan="1"><p> Enter the name or a portion of the subfile name that you would like to import. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Object Name </p></td><td colspan="1" rowspan="1"><p> Select the object you want to use. </p></td></tr></tbody></table>

## Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Data Connector").

## Troubleshooting

Ensure you have the right permissions with the project to get to the bucket you're interested in.
