Connect Google Sheets to Pigment and cut manual file handling
Give Finance, Sales, HR, and Supply Chain teams Pigment data inside the Google Sheets they already use, without exporting files or copying and pasting. Load a saved Pigment View into a sheet, refresh it when you need to, and push updated inputs back into Pigment.

Google Sheets
Connect Google Sheets to Pigment to analyze business data, collect planning inputs, and keep spreadsheets connected to your plans
Category
Integration method
Best for
Budget input collection · Ad hoc analysis · Management reporting
What can you do with Google Sheets and Pigment?
- Build reporting packs from Pigment. Load a saved forecast View with Include View Format on, then select Pull All before sharing the pack.
- Run variance analysis in Sheets. Load budget and actuals Views into separate sheets and use spreadsheet formulas while source numbers stay in Pigment.
- Collect planning inputs across departments. HR teams submit hiring plans, Sales teams update territory assumptions, and Supply Chain teams revise operational forecasts in Sheets, then push their ranges into the Blocks Finance owns.
- Tag actuals to a scenario. Push actuals into Pigment with a “Dimension: Scenario” column set to Actuals, so they land in the right Scenario even when the range has no Scenario field.
How the Google Sheets integration works
The Pigment Connector is an add-on in the Google Workspace Marketplace, and you sign in with your Pigment account. Each connection loads a saved Pigment View into one sheet, with up to 50 MB of data per connection, and refreshes only when someone selects Pull or Pull All. To send data back, you create a Sheet Configuration that defines the range to push, then link it to an import configuration on the target Block using its import ID. Each push starts an import in Pigment, and Pigment access rights apply in both directions.
Key capabilities
- Pull only what each user can read. Every load applies Pigment access rights, so each person sees only the data they have Read or Write access to.
- Bring in any planning data. Load Metrics, Dimensions, Transaction Lists, or Tables from any View, up to 50 MB at a time.
- Keep the layout readers expect. Turn on Include View Format to keep the View's formatting and layout, with Tree Views exported in Tabular form.
- Check what each push sent. View export data as CSV shows the values pushed from your sheet to Pigment, so you can confirm each push.
- Roll out through Google Workspace. Google Workspace admins can install the Pigment Connector for specific users, so teams don’t each install it themselves.
Frequently Asked Questions
What Pigment data can I load into Google Sheets?
You can load data from any View, including Metrics, Dimensions, Transaction Lists, and Tables, up to 50 MB at a time. Each connection links one View to one sheet. Use a saved View rather than the default View, since any change to the default View also changes what the next load returns.
Does the integration respect Pigment access rights?
Yes. You need Display Application permission, and you only load data you have Read or Write access to in Pigment. Page selectors stay visible, but they return no data for values you can’t access. Pushes run under each person’s own Pigment credentials, so their access applies when sending data too.
Do I need a Google Workspace admin to install the Pigment Connector?
It depends on your company’s Google Workspace settings. If add-on installs need admin approval, IT can approve the Pigment Connector or install it for specific users.
Related integrations
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.

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