Hi all,
for 2 days I am trying to build my own scenario, without any succes
My frustration level is getting to high, I tried to make it together with chatgpt without the succes.
In the sheet watch new row is the date and all the blanks need to be filled by chatgpt, who can help?
Many thanks in advance
1 Like
Hello @Mustapha_Aatimine, welcome to the Make Community!
And sorry for the long time to answer!
Can you please give details about what you want to ask ChatGTP and what result you want?
Usually, you need to ask ChatGPT to answer you with a JSON document do that you can easily use it in the scenario.
From what I in your screenshot, I think you donât need the iterator.
And, you may already know, but the âWatch new Rowsâ Google Sheets module is what we call a âPolling Triggerâ; everytime you run it, it keeps track of the last row it found. It means that if you are testing multiple times, you need to âresetâ it, or to add multiple rows in the Google Sheets.
But before I help you with it, can you give me more information about what you are trying to achieve?
Kind regards,
Benjamin
1 Like
Hello Benjamin,
first of all Iâd like to thank you for your response.
ChatGpt should fill out the blank fields and then all the data should go into shopify. Hopefully I could do about 50 new products entries.
Furthermore Iâlike to import products that have a variant (this is a wish) not a need.
Could you tell me were I can do the âresetâ.
If you need anymore info, please do not hesitate, I hope you understand.
Best Regards,
Mustapha
Hello @Mustapha_Aatimine,
Itâs a little bit tricky to help you here, because there are lots of things you need to do:
- you have to configure the ChatGPT prompt to perform some action, and ask it to return a JSON document: It could be something like âFrom this product information, generate a description, and xxxxxxxx, send the result in JSON format with a field called âdescriptionâ and âxxxxâ and âyyyyââ. You know better than me what you want to get from ChatGPT
- then, you will need a Parse JSON to parse the result from ChatGPT. Itâs because it will send you a string that contains the JSON; if you want to be able to map it to the columns in your spreadhseet, you need to parse it before.
- Then you will map the result of Parse JSON to your columns.
Itâs hard to give you details here, because it depends on the data you want to get from ChatGPT, as well as the data you want to send it.
May I suggest that you contact a service partner to help you at least on the initial steps? And maybe you could follow the Make Academy trainings that will you the basics about Make Scenarios.
I hope you will manage to make it work.
kind regards
Benjamin