Push data from Google Sheets Into Pigment

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.

🎓 Pigment Academy

Check out the Google Sheets Integration 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 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

      Working with a pivoted file in Google Sheets? No problem! During this initial import, select Pivoted, and configure the appropriate mappings.

      ⚠️ 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.

⚠️ 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.