Hello,
I need to make multiple different imports from Pigment to Google Sheets within a preset presentaion frame (namely, fixed row titles and fixed column titles). But instead of filling the existing available empty cells of the sheet under those row and colum titles, the import seems to be inserting new rows and new columns (as many as the total surface of the import) between existing rows and columns. Can you please help me solve this ?
Thanks
Erwan
Hello Erwan,
If I understood correctly, you have a template that you would like to fill using the Google Sheet connector to export from Pigment to Gsheet. If what you said is true about Pigment not using the existing available cells, then you could use another tab to display your result as expected.
So one tab to get the data and another one to do the formatting, which will be referring to the first tab with the data from Pigment.
I’m not sure about this solution, but it’s probably worth a try. Let me know how it goes :)
Gawain
Did Gawain’s answer help,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.