Hi everyone.
I created a Zap with the following structure:
1) every week the trigger is activiated
2) formatter is used to create a “previous week” -7 days
3) parsing data from Apify as CSV
4) formatter is used to split CSV into separate columns
5) save 3 columns (stars, comment and date) in an existing Google Sheets file
6) chatgpt is used to classify the data from column “comment”
7) add this classification to another column “category” of the existing Google Sheets file for each newly created raw.
The problem is that I do not get the classification generated by ChatGPT for each batch of newly added raws but only for the last of them. I do not understand the logic how Zapier is going to add it to all newly raws if I refer to only 1 single Raw ID…
Would be glad to get help from you.