--- title: "Push data from Google Sheets Into Pigment" slug: "push-gsheets" description: "Learn how to configure the Pigment Connector for Google Sheets to seamlessly push data into Pigment with easy installation and mapping steps." tags: ["Data Import", "Google Sheets", "Importing Exporting Data", "Pigment Connector"] updated: 2025-05-30T13:40:56Z published: 2025-08-22T11:22:15Z --- > ## 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. # Push data from Google Sheets Into Pigment ![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(4).png) The Pigment Connector for Google Sheets allows you to push data from Google Sheets into Pigment. This article discusses the different configuration options, including how to install the connector and how to push data. > [!TIP] > 🎓 **Pigment Academy** > > 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! ## Set up the Google Sheets configuration First, you need to prepare a Google Sheet that outlines the required configuration you need to push data into Pigment. 1. In the Google Sheet that contains the data you wish to push, sign into the Pigment Connector. 2. Click **Push to Pigment** in the Pigment sidebar. 3. Click **Create Sheet Configuration.** This opens a new sheet named **Pigment.** The purpose of this sheet to specify precisely which data you wish to push to Pigment and its required configuration options. 4. Enter the following mandatory information: | Column | Description | Example | | --- | --- | --- | | Sheet | Name of sheet containing your data. | Lists | | Named Range | Use either Named Range cell, or the **Begin Range** and **End Range** cells described below. If you use the Named Range cell, see the [Google documentation](https://support.google.com/docs/answer/63175?co=GENIE.Platform%3DDesktop&hl=en) for more information. | country_list | | Begin Range | Use either the Begin Range and End Range cells, or the **Named Range** cell described above. | A1 | | End Range | Use either the Begin Range and End Range cells, or the **Named Range** cell described above. | C7 | | Show CSV | Enter TRUE. This allows the download of a CSV file containing the extracted data. | TRUE | 5. Click **Download export data as CSV**. A confirmation displays with a link to the downloaded CSV file. ## Create the Import Configuration in Pigment Next, use the downloaded CSV file to create an import configuration in Pigment. This ensures that data is accurately mapped when pushed from Google Sheets to Pigment. 1. In Pigment, go to the Block where you want to push your Google Sheets data, and click **Import Data**. 2. Do the following: 1. Upload the CSV file you just downloaded from Google Sheets. 2. Configure and map the CSV settings so that the CSV data matches the requirements in Pigment. > [!NOTE] > ℹ️ **Note** > > Working with a pivoted file in Google Sheets? No problem! During this initial import, select **Pivoted**, and configure the appropriate mappings. > [!WARNING] > **⚠️****Important** > > The number and dates format must be **en-GB**. 3. Click **Import**, and save the import configuration. 3. In the Block settings, go to **Import configurations**. 4. In the three dots menu, click **Copy ID**. You need this ID to finish your Google Sheets setup. ## Add the Import ID to the Google Sheet The final part of the Google Sheet configuration is to add the Pigment import ID to the Pigment connector. This specifies how data is mapped and organized each time it is pushed from the Google Sheet to Pigment. > [!WARNING] > **⚠️****Important** > > This import ID is unique to this Google Sheet. If you try to use other import IDs in this process, this will likely result in failed imports. 1. In the Google Sheet sheet that contains the data you wish to push, open the sheet called **Pigment.** 2. Enter the following information: | Column | Description | Example | | --- | --- | --- | | Import ID | Paste the import ID with your import in Pigment. This is mandatory for Google Sheets to correct push data to Pigment. | c5f852f7-5981-42c3-841s-6a4ab996cbee | 3. *(Optional)*The following information can also be included in the Pigment sheet: | Column | Description | Example | | --- | --- | --- | | Description | Name for your export type. | Country List | | Header Row | Row number including the headers if not included in the range selected. | 11 | | Debug | Return detailed information about a specific row. | TRUE | | Dimension: x | If you need to add a Dimension modality that is not included in the range selected: • Replace x in the column name with the exact name of the Dimension • In the field, enter the specific item from within that Dimension | Column Header would be **Dimension: Scenario** The cell’s data would be **Actuals.** | ## Push Google Sheet data to Pigment When the setup is complete: - Click **Export data to Pigment** to push data from your Google Sheet to Pigment. - Click **View export data as CSV** to view the values that were pushed from your Google Sheet to Pigment.