Push data from Google Sheets Into Pigment

Hi ​@Nah,

You can try the following :
1-Download the file that was pushed from GSheet. You can do that from the “…” next to Edit in the Import Summary Screenshot.

2-Check if the file is aligned with your GSheet view. You might have a missing column in that file. In that case you will need to update the GSheet configuration page to include the missing one as it wasn’t correctly setup.

3-If it matches, then try to load this csv file directly using the same configuration but first edit the configuration using this file. You might have a mismatch in the file columns and the Transaction list properties : one is not correctly mapped (check for a red settings next to the properties).

Hope this helps,
 

Hi there,
 

We recommend downloading the Gsheet file using the Pigment add-on option “Download export data as CSV.” Once downloaded, use the CSV file to review and update your existing import configuration in Pigment. You should notice some discrepancies in the configuration mapping. After making the necessary updates, your import from Gsheet to Pigment should work as expected.

If you’re still facing difficulties after completing these steps, please let us know!

Thank you, and have a wonderful day!

Hi there, ​@Julie Guérin, ​@CDALMAY 

Thank you for your guidance. I applied all your instructions as described, but I am still having the same error message:

"Missing column in CSV - Some header(s) in the mapping configuration are not found in the CSV."

I used the CSV file to review and update my existing import configuration in Pigment, and it worked ("the Items were Imported"). However, when I pushed the data from Google Sheets to Pigment using the same CSV file, it does not work. I tried to do this with the Pigment Connector add-in for Excel, and it gives me the same error message.

Thank you for your help, and have a wonderful day!