All Integrations
Google Cloud Storage
x

Connect Google Cloud Storage to Pigment and stop manual uploads

Load the CSV extracts your data teams already store in Google Cloud Storage into Pigment, and export planning data back to your buckets through Pigment’s API. Built for IT and Transformation teams fitting planning into an existing Google Cloud stack, and for FP&A teams who want current actuals without handling files.

Google Cloud Storage

Google Cloud Storage

Load CSV files from a Google Cloud Storage bucket into Pigment Blocks

Category

File Storage Systems

Integration method

Native Connector
API

Best for

Actuals for FP&A models · Dated CSV extracts · IT-governed data handoffs

See documentation

What can you do with Google Cloud Storage and Pigment?

  • Refresh actuals before the reforecast. An FP&A analyst loads the newest transactions extract into a Transaction list, then rolls it into the forecast.
  • Give modelers data without cloud credentials. IT stores the service account key in the connection, so model builders import without their own Google Cloud access.
  • Feed headcount cost plans from payroll extracts. A workforce planning lead imports the latest dated salaries file, so compensation assumptions match current pay.
  • Split planning data from everything else. An IT architect creates a dedicated bucket holding only files meant for Pigment, so the handoff stays contained.

How the Google Cloud Storage integration works

Setup starts in Google Cloud, where the bucket’s project owner creates a dedicated service account, generates a JSON key, and grants it the Storage Object Viewer role on the bucket. In Pigment, a Workspace Admin adds the connection under Settings > Integrations with the bucket name, the key, and the Applications allowed to use it.

To import into a Block such as a Transaction list, choose Integration instead of Upload file, then select the Google Cloud Storage connection. Pigment loads either one fixed file or the most recent file that matches a dated naming convention. Exports run through a different path, with a Google Cloud function running a Python script that calls the Pigment REST API and saves Views, Lists, Metrics, or Tables as CSV files in a bucket.

Key capabilities

  • Keep your pipeline's file names. Pigment reads ISO-8601 dates in file or folder names, so data teams don’t rename exports for planning.
  • Grant read-only access at bucket level. The service account only needs Storage Object Viewer on the bucket, so IT skips project-level policy bindings.
  • Keep your current bucket settings. The connection works with both Uniform and Fine-grained access control, so IT doesn't have to reconfigure an existing bucket.
  • Decide which Applications use each bucket. Each connection covers one bucket, and its Application access setting controls which Pigment Applications can import from it.
  • Export on your own schedule. Run the export from a Google Cloud function on a schedule, and choose which Views, Lists, Metrics, or Tables land in your bucket.

View technical documentation

Frequently Asked Questions

Which file formats and import modes does the Google Cloud Storage integration support?

The integration loads CSV files in two modes. Fixed file mode loads one exact path, such as folder1/folder2/file.csv. Most recent file mode uses a date placeholder in the file or folder name and loads the newest matching file.

Can Google Cloud Storage imports run on a schedule?

Yes. You can schedule a Google Cloud Storage import configuration to run automatically, with up to four schedules per configuration and notifications if an import fails. With most recent file mode, each scheduled run picks up the newest dated file in the folder.

Can Pigment export data back to Google Cloud Storage?

Yes, through the Pigment REST API rather than the native connector. A Google Cloud function calls the export API and saves data from Views, Lists, Metrics, or Tables to a bucket, and you can schedule it to run regularly.

See Pigment in action

The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

Three colleagues focused on an iMac screen in a bright office with plants and modern artwork.

From 8 days to 4 min

Update P&L actuals & financial forecasting

80%

Time cut on data aggregation

12 hours

Saved per month on executive reporting

6 days faster

For scenarios creation and analysis