Hello Community,
My scenario currently looks like this:
- I upload a CSV with lots of different data to my Drive
- the file is downloaded
- ChatGPT should only extract very specific data from this CSV
- then ChatGPT should bring the data into a table format, with headings that I have previously defined
- in the last ChatGPT step, it should remove the headings so that the extracted data is in the desired format
Now I want this data to be transferred to a Google Sheet in the format I want.
The headings are already in the Google Sheet. The data should simply be inserted into the list each time.
(Do I have to split the Output into multiple Rows so I can insert them into the Google Sheet?)
Can anyone help me please?
See duplicate topics about the use of the “Bulk add rows” module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
Thank you for your reply.
I’m still a bit new to make, so I dont know exactly if I have to add some modules like “JSON” or “Iterators” to my scenario. Could you help me with that?
@samliew forgot to mention you in the reply
You already have a search module, that should function like an iterator because each result is one bundle.
You need an array aggregator somewhere before the bulk add rows module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
@samliew
It inserted the data, but all in one Cell “A1”.
How can I change that
And one more thing. Can I format the output of Chatgpt so that this separator “|” is not transmitted?
