How to add data to goodle sheet line by line and not in one cell

How To
1

What are you trying to achieve?

Hi Guys,
can you help me please,

I’m taking data from google doc and it’s presented there as a table,
after processing with chatgpt I need to add them to google sheet as a table (line by line, column by
column), but I got everything in one cell, please check below two screenshots

thanks in advance

Screenshots: scenario setup, module configuration, errors

Screenshot 2024-09-03 at 21.21.07.png
Screenshot 2024-09-03 at 21.21.07.png1724×350 27.8 KB

Screenshot 2024-09-03 at 21.21.00.png
Screenshot 2024-09-03 at 21.21.00.png1350×362 25.1 KB

2

Convert the doc into html and use the “Get content from HTML table” module. From there you might have to manipulate the text further but it will let you map the data into google sheets.

Hope this helps!

3

thanks for replying,
Unfortunately the problem is in the module “google sheet” as that module can only add data to a specific single cell.
so, the table is read and analyzed correctly but the next module is exactly “google sheet” which put all in one cell.

4

I’m wondering if nobody had such problem before,
maybe there is another way how to solve it and I would appreciate for any help/ ideas/ guess.

thanks

5

Hi @Alex_Malinin
We recommend obtaining the JSON structure output from ChatGPT and then using the “Parse JSON” function to easily map the values into the “Add a Row” module.

Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation

6

Once the text is iterated from parsing the html table you can use a text or json aggreagtor. From there parse the json and you will have a json that you can map the required fields into the google sheet.

If you are unfamiliar with using these tool take a look at the learning modules make has on arrays and jsons.

Hope this helps!