Skip to main content

Connect Google Cloud

AvailableReviewed 21 August 2026

Connect Google Cloud by pointing FinomateAI at a BigQuery billing export and a service account that can read that dataset.

Before you begin​

  • Access to the Cloud Billing account
  • Permission to create a service account in the export project
  • Standard or detailed billing export already writing to BigQuery

What FinomateAI asks for​

FieldPurpose
Billing account IDFormat 012345-6789AB-CDEF01
Project IDProject that hosts the export dataset
BigQuery dataset IDDataset that receives the export
Table prefixOptional
Service account JSONKey stored securely
Connect Google Cloud form with billing account, project and BigQuery dataset
Grant dataset-level read access only. Do not grant editor on the billing account.

Step 1: Confirm the export​

In Google Cloud Console:

  1. Open Billing → Billing export.
  2. Enable Standard (and Detailed if you want resource-level rows).
  3. Point it at a dedicated project and dataset (for example nw-finops-billing.billing_export).
  4. Confirm daily partitions are arriving (gcp_billing_export_v1_*).

Step 2: Create a service account​

  1. Create a service account in the export project, for example finomate-billing-reader.
  2. Grant BigQuery Data Viewer on the export dataset only (roles/bigquery.dataViewer).
  3. If the dataset is in another project, also grant BigQuery Job User on the project that runs queries, if your tenant requires it.
  4. Create a JSON key. Use it once in onboarding; rotate if it leaks.

Do not grant Billing Account Administrator.

Step 3: Complete onboarding​

  1. Open Complete onboarding and select GCP.
  2. Enter billing account ID, project ID, dataset ID, optional table prefix and the JSON key.
  3. Select Complete onboarding.

Step 4: Validate​

  1. Confirm Healthy on Connected accounts.
  2. In Cost Explorer, select GCP.
  3. Compare a completed period with Cloud Billing reports for the same billing account.

Troubleshooting​

SymptomCheck
JSON rejectedKey type is service_account, not a user credential
Dataset emptyExport enablement and first partition
Access DeniedDataset IAM, not project Owner
Projects missingBilling account linkage to those projects
Totals differCredits, committed use discounts, invoice-level items, Standard vs Detailed

Expected result​

FinomateAI can read the approved BigQuery export, expected projects appear, and a completed period reconciles.