Google watch new row, chatgpt productdescription, google update row, shopify make new product

How To
,
1

Hi all,

for 2 days I am trying to build my own scenario, without any succes :frowning:

My frustration level is getting to high, I tried to make it together with chatgpt without the succes.

Google_Sheet
Google_Sheet1920×1005 79.4 KB

Community_Flow
Community_Flow1920×1002 106 KB

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
3

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
4

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

5

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 :blush:
  • 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