---
title: "How to install Pigment's Connector for Google Sheets"
slug: "install-gsheets-connector"
description: "Easily install the Pigment Google Sheet Connector to load saved views and push data between Pigment and Google Sheets, all with your Pigment credentials."
tags: ["Data Integration", "Google Sheets", "Importing Exporting Data", "Pigment Connector"]
updated: 2025-08-29T09:30:20Z
published: 2025-08-29T09:30:20Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to install Pigment's Connector for Google Sheets

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(2).png)

The Pigment Google Sheets Connector enables users to load saved Views from Pigment into Google Sheets, as well as push data from Google Sheets back into Pigment. You can import data from any View in your model, such as Metrics, Dimensions, Transaction Lists, or Tables, directly into a Google Sheet. The connector supports loading up to 50 MB of data at a time. This article shows 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](/v1/docs/load-data-gsheets) and [loading data from Google Sheets into Pigment](/v1/docs/push-gsheets).

> [!TIP]
> 🎓 Resources
> 
> Check out the [Google Sheets Integration Micro-learning series](https://academy.gopigment.com/google-sheets-integration-with-pigment-micro-learning-series) in the Pigment Academy!

## How to Install

> [!TIP]
> 🎓 **Resources**
> 
> Below are the instructions on how to install from the Extensions tab within a Google Sheet, you can simply click [this link](https://workspace.google.com/marketplace/app/pigment_connector/40115800624)to go directly to the Google Workspace Marketplace.

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

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/e77c4aa4-e15e-4548-bb3f-eab85821868b.png)

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. **U**se your Pigment credentials to log in.
5. Select **Allow** to give the Connector.

> [!WARNING]
> **⚠️****Important**
> 
> If your company requires Google Workspace admin to install apps, you might need to reach your IT to get the Add-on approved. Here is the [Google Documentation](https://support.google.com/a/answer/172482?hl=en) regarding how an Admin can install Add-on for specific users.

## 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.