Integrate your GCP Account with CloudSpend

Google Cloud Platform (GCP) cost management is essential for anyone responsible for running their resources in the GCP. CloudSpend allows you to integrate your GCP account and manage your cloud bills.

You can connect your GCP account with CloudSpend by following the steps below:

  1. Export billing data to the BigQuery data set from your GCP account.
  2. Create a service account and obtain the service account JSON key.
  3. Connect your GCP account with CloudSpend.
  • GCP Cloud Billing report uses the Pacific Time Zone and observes daylight saving time shifts. However, CloudSpend uses the UTC time zone. You may notice some cloud cost differences between CloudSpend and the GCP Cloud Billing report due to the time zone difference.
  • GCP offers two types of time ranges for cost breakdown: Usage date and Invoice month. Currently, CloudSpend provides usage-based costs within a specified time range for GCP accounts.

CloudSpend-GCP integration workflowCloudSpend-GCP integration architecture

Export billing data

Export the billing data to the BigQuery data set and obtain the Dataset ID to integrate your GCP account with CloudSpend.

Follow the steps below to export the billing data:

  1. Log in to the GCP console and navigate to the Billing section in the menu.select billing
  2. Select the Billing Export tab.
  3. In the BIGQUERY EXPORT tab, click EDIT SETTINGS under the Detailed usage cost section.bigquery export
  4. Select the applicable project from the Projects list. The billing data will be exported to BigQuery in the selected project.select project
  5. Create a new data set or select an existing data set for exporting billing data to BigQuery from the Data set drop-down.
  6. Click SAVE.
  7. Ensure that Detailed usage cost is enabled.
  8. Click the Data set name hyperlink.
  9. Copy the Data set ID and paste it in the Dataset ID field found on the CloudSpend Integrate Account page.

Create a service account and obtain the service account JSON key

Follow the steps below to create service accounts:

  1. From the navigation menu, go to IAM and admin > Service accounts. Ensure that you are in the same project that has configured billing to be exported to BigQuery.select IAM
  2. Click CREATE SERVICE ACCOUNT.create service account
  3. Provide the Service account details.
  4. Click CREATE AND CONTINUE.service account details
  5. Choose Viewer as the role in the Grant this service account access to the project section.viewer role
  6. Click DONE.

To download the service account JSON key, follow the below steps:

  1. On the Service accounts page, click the vertical ellipsis icon under Actions for the respective service account. manage keys
  2. Select Manage keys.
  3. Click ADD KEY. add the keys
  4. Select Create new key.
  5. Select JSON as the Key type. download JSON
  6. Click CREATE. The private key will be downloaded to your system.

Connect your GCP account with CloudSpend

After entering the Dataset ID and obtaining the JSON key, you can connect your GCP account with CloudSpend.

To connect your GCP account with CloudSpend:

  1. Open the CloudSpend web console and sign in.
  2. When you open the CloudSpend console for the first time, you'll land on an onboarding carousel highlighting the features of the app. You can read and understand how the app can help you, or you can choose to skip.
  3. Click Integrate Account.
  4. Provide a Display Name.
  5. Set the Public Cloud Provider as GCP. GCP integration
  6. Enter the Dataset ID that you created while exporting the billing data. Paste dataset ID
  7. Upload the JSON key file from your system to the Service Account JSON Key File field. Upload JSON file
  8. The Start date for bill processing determines the month from which your bills get processed. Select the applicable month.
  9. Click Save to connect your GCP account with CloudSpend.
Top