Add Multiple lines to Google sheets from csv formatted data

[tyrone]

Hi,
I am trying to add multiple lines to a google sheet, however the original data format is csv so the iterator won't let me select the csv data. How can I get Pabbly to add this sort of data to google sheets?
The label will specify the column and each comma in the value column needs to represent a new line.

Here is the output from the original data source

 

[Pabblymember11]

Hey @tyrone

If you are trying to pass the row data in commas separately in the Google Sheets at once then it is not possible.

You have to use the Iterator action step to pass the values one by one in the respective row-column cell.

(Watch the second part of the video to send the data in your Google Sheets one by one)

 

[tyrone]

Unfortunately I can not use the iterator function as it only lets me select data that is in JSON format not csv format.
Can I convert the csv data to JSON so that the iterator can handle it?

 

[Pabblymember11]

Hey @tyrone

You can only process JSON data on the platform, direct CSV files cannot be derived from any action step.

If you are retrieving the row data from Google Sheets then you can only process the data via the Iterator action step as mentioned in the above-mentioned tutorial video.