Step-up Your Presentations With Pigment’s Google Sheets Connector

Pigment news

Easily move data between Google Sheets and Pigment with the Google Sheets connector. Save time to focus on delivering your message over formatting and data tweaks.

Text Link
Priyaanka Arora
July 15, 2022

Create flexible and predictable sales forecasts

Pigment live product tour icon
Watch Pigment in action
Register now
Step-up Your Presentations With Pigment’s Google Sheets Connector


It’s a tale as old as time.

You build beautiful, highly accurate models in your EPM tool and can’t wait to communicate your outputs. You’re proud of how you used state-of-the-art technology to predict, plan, and forecast the future.

But when it’s time to actually share those insights with executives or the board, you’re back to… manually copy-pasting data into spreadsheets and slides?

We have good news: with the new Google Sheets connector from Pigment, you can now update your slides or sheets with the click of a button. That’s right, no more manual data exports and reformatting into rigid charts.

Read on to find out how the new Google Sheets connector will help you rock your next board meeting by reducing time spent on tedious formatting and manual data transfers.

Yes, Pigment can connect to Google Sheets!

If you’re a Pigment fan or a participant in one of the 60+ active threads on the Pigment Community, you already know that a Google Sheets connector is a much sought-after feature. We’ve had numerous questions from customers and community members on whether Pigment can connect to Google Sheets. Short answer: yes!

Pigment Google Sheets connector community answer

You’ve always had the ability to push data from Google Sheets into Pigment. With the latest update, you can now pull updated data from Pigment views into Google Sheets. This two-way transition of data cuts hours of time spent on manual data transfer and prevents human error.

This important update will level up your presentations and analyses. Think about it: not only can you leverage all your data integrations to build a single data repository on Pigment, but you can also now build views that export seamlessly into your sheets and decks, ready for presentation.

Seven advantages of using a Google Sheets connector

Here’s what you can do when you install and start using Pigment’s Google Sheets connector today:

  1. Pull data from any view within a Pigment model into your Google Sheets
  2. Refresh pulled data in your Google Sheets with the click of a button
  3. Seamlessly update your presentations without breaking any charts
  4. Eliminate human data error when transferring information
  5. Save hours of time bypassing manual data transfers
  6. Focus on communicating the message rather than fixing formatting issues
  7. Pull data joined with other data sources into your Google Sheets

Pigment connector for Google Sheets

In summary, save time, be more efficient, and stun your audiences with a sharply delivered message.

How to connect and load data from Pigment into Google Sheets

It’s as easy as 1-2-3-4-5 to connect and load data from your Pigment models into Google Sheets. Here are five easy steps to get started and be on the track to easy data refreshes in Google Sheets. Note: you will have to first install the Pigment connector as an add-on from within Google Sheets.

  1. From the extensions panel in Google Sheets, activate the connector by opening the Pigment Sidebar
  2. Login by entering your Pigment credentials
  3. Select the Load Pigment View option to pull data
  4. Select the sheet to import your data into
  5. Set up a few configurations to define your data and destination

Repeat as many times as necessary to pull all your data into Google Sheets. You can always manage your connections by editing, reloading, duplicating, or deleting them.

With this two-way connector, your presentations should know no bounds!

Join the buzz around the Google Sheets connector and swap presentation ideas with your peers over at the Pigment Community.

SWTCH Online: access all sessions on-demand

Watch now

Join our Live Tour Series

Save your seat

Related articles