How to install Pigment's Connector for Google Sheets

  • 12 July 2022
  • 0 replies

Userlevel 5
Badge +4
  • Community Manager
  • 68 replies

Pigment’s Google Sheet Connector allows Pigment users to load pigment saved views into Google Sheets, as well as Push data from Google Sheets into Pigment.  This article will show you how to install and log-in to the Pigment Connector.  There are two separate articles on the specifics of loading data from Pigment into Google Sheets and loading data from Google Sheets into Pigment. 


Table of Contents


How to Install


Below are the instructions on how to install from the Extensions tab within a Google Sheet, you can simply click this link to go directly to the Google Workspace Martketplace.


The Pigment Google Sheet Connector is available through the Google Workspace Marketplace.  Follow the steps below to install the add-on.


 Link to store

  1. Open a Google Sheet spreadsheet and navigate to: Extensions > Add-ons > Get add-ons
  2. Type Pigment Connector into the search bar at the top
  3. Locate the Pigment Connector add on and click Install
  4. Use your Pigment credentials to log in
  5. Select Allow to give the Connector 


How to activate Google Sheet Connector


Once installed, you will be able to use your Pigment login credentials to sign into the connector.  Your access in Pigment will be the same when you log in through the connector. This means you have access to the same Applications, with the Access Rights. This means you won’t be able to pull data that is restricted. 


  1. Open any Google Sheet
  2. In the Google Sheet Menu, navigate to Extensions > “Pigment Connector” > “Open Pigment side bar”
  3. Click Login and type in your Pigment credentials.
  4. Close tab


0 replies

Be the first to reply!